Power Platform Community Forum Thread Details

We currently use Dynamics Finance and Operations and would like to Synchronize some fields from the Customers & Projects Entities. I have created a custom entity from both of these. Created a connection set, Created an integration project using the Fin and Ops to CDS template. Created my tasks, see images.

My results,

Project ID works first Sync and than the following,

Precondition Failed {"error":{"code":"0x80060892","message":"A record that has the attribute values Project ID already exists. The entity key Project ID requires that this set of attributes contains unique values. Select unique values and try again.","innererror":{"message":"A record that has the attribute values Project ID already exists. The entity key Project ID requires that this set of attributes contains unique values. Select unique values and try

Customers works every time however is creating a duplicate customer each Sync.

We are using the HR Talent Microsoft Pre-Built integration jobs which seem to be working as expected, no duplicates or errors that a record already exists. When I created my two custom entities Projects & Customers I reviewed the working talent entites and mimicked the Personnel Number settings for the key. The two fields I used in my configuration for keys, Customer Account & Project ID are both unique on the Dynamics side.

I am not looking to push data back into Finance and Operations and simply looking to syncrhonize a few fields from the Project and Customer entites for consumption in various solutions.

Here are some screens of the Key Fields, The last screenshot shows the Execution History, first one failing is Projects, worked first Sync and now every field is a duplicate so all fail, last one that is working is Customer however it creates a duplicate every Sync. Any guidance on this is appreciated.