Dataflow not upserting correctly

(0) Share

Report

Posted on by KoJaPD

595

I have a dataflow that upserts data into an existing table.

I have set a unique key, which should be used to detect if a record already exists, and if so, it should be updated.

However, the flow does not run succesfully, because it complains the key already exists...

the (Dutch) error message translates to: A record with the attribute values xxxxxxx already exists. The entity key xxxxxxxxx requires this set of attributes to contain unique values. Please select unique values and try again.

So, it does detect that the key already exists, but it somehow does not update this record...

Any idea why this update is not working?

Categories:

Dataflows

All responses (1)

Answers (0)

AhmedSalih

6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Dataflow not upserting correctly

Hello, @KoenJanssensPD , Your unique key should be the alternate key in the table. And you should map it to primary key of your source. Note, alternate keys can't have duplicates.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com