Finance | Project Operations, Human Resources, ...

I would like to ask about entity that connect from D365

(1) Share

Report

Posted on by Chomchanok

276

Hi Everyone,

Recently I just develop power automate to create a customer profile in D365 but when we want to write information in D365 I got error like this image.

"An error has occurred. Write failed for table row of type 'CustCustomerV3Entity'. Infolog: Warning: Matching record with key 'ReliefGroupId': OKT TAICAN for the data source 'TaxGSTReliefGroupHeading_MY' does not exist.
clientRequestId: e4ace4d6-d20e-4f4f-8789-346f72a1fded"

Can someone guide me how to solved it? I test with entity "Customers","CustomersV2","CustomersV3", Error is the same.

Thanakorn

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

It means that you're sending a wrong value in ReliefGroupId field. It's a reference to TaxGSTReliefGroupHeading_MY table, but the record with ReliefGroupId = 'OKT TAICAN' doesn't exist there.

(Moved from Dynamics AX forum.)

Was this reply helpful? Yes No
Chomchanok 276 on at

Like (0)

Report

Dear Martin Dráb

Thank you for your reply,

I try to send only mandatory field to test on this entity but the response sound like "I can't save" and error show "ReliefGroupId field" reference to TaxGSTReliefGroupHeading_MY table.

My question is what is entity that I can write in it like I create new records in D365?

I test with entity "Customers","CustomersV2","CustomersV3", Error is the same.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

CustomersV3 is the latest version of the entity; you should use that.

The idea that CustomersV3 can't be used to import customers is a bad one. It's the the correct entity; either you're using it in a wrong way and or the entity is broken (e.g. by a wrong customization) and the right approach is fixing it.

Was this reply helpful? Yes No
Chomchanok 276 on at

Like (0)

Report

Dear Martin Dráb ,

After I digest my code then I lean concept by delete unnecessary code to check and I search by youtube then found this solution and now I can fixed it case.

thank you.

https://www.google.co.th/search?q=power+automate+create+new+customer+in+D365&sca_esv=13f83d3e4d744b27&sca_upv=1&sxsrf=ADLYWIL4YVFgzo8vtmX8jJAK-rT4XDfQnQ%3A1718332857382&source=hp&ei=ua1rZrDZFKS4seMP8sOimQg&iflsig=AL9hbdgAAAAAZmu7yf6B-xomqoNm6dDObaqviVDHRAB1&ved=0ahUKEwjwmcXciNqGAxUkXGwGHfKhKIMQ4dUDCA4&uact=5&oq=power+automate+create+new+customer+in+D365&gs_lp=Egdnd3Mtd2l6Iipwb3dlciBhdXRvbWF0ZSBjcmVhdGUgbmV3IGN1c3RvbWVyIGluIEQzNjUyBRAhGKABMgUQIRigATIFECEYnwUyBRAhGJ8FMgUQIRifBTIFECEYnwUyBRAhGJ8FMgUQIRifBTIFECEYnwUyBRAhGJ8FSLVQUABYi09wA3gAkAEAmAFzoAHPH6oBBTM1LjEwuAEDyAEA-AEBmAIwoALSIMICBBAjGCfCAgoQIxiABBgnGIoFwgIKEAAYgAQYQxiKBcICCxAAGIAEGJECGIoFwgIQEAAYgAQYsQMYQxiDARiKBcICCxAAGIAEGLEDGIMBwgIOEAAYgAQYsQMYgwEYigXCAg0QABiABBixAxhDGIoFwgIIEAAYgAQYsQPCAhEQABiABBiRAhixAxiDARiKBcICBRAAGIAEwgIHEAAYgAQYCsICChAAGIAEGBQYhwLCAgYQABgWGB7CAgsQABiABBiGAxiKBcICCBAAGIAEGKIEmAMAkgcFMzYuMTKgB4OaAw&sclient=gws-wiz&safe=active&ssui=on#fpstate=ive&vld=cid:f34f3332,vid:B4NhaPDUgbk,st:0

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

Your verified answer contains just a Google search phrase, which does not really explain anything and therefore it wouldn't help anyone looking for an answer in this thread. Please provide an actual answer. Many thanks.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

As Martin suggested, The entity that needs to be used is CustCustomerV3Entity and this is the entity that's the latest entity version for Customers.

To answer your question on creation of new records, you need to export a csv template through Data Management from D365 FO ; add the required information and then import it (if you are after data migration). Else you can use PowerAutomate by exposing the entity and its relevant method postGetStagingData().

Happy to answer questions, if any.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

Note that the last reply applies to data management, but Thanakorn seems to be using the F&O connector (backed by OData), not a data management API.

Was this reply helpful? Yes No