Unanswered

Dataflow - Alternative Keys

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have 2 x Alternative keys setup in the Account Table (2 x separate systems that create their own keys), the one alternative key works as intended with the dataflows and does upserts, however, something has happened and the second one seems to be not working correctly.

When refreshing the dataflow I get the below message. (It looks like it is trying to insert but my intention is an upsert)

{"error":{"code":"0x80060892","message":"A record that has the attribute values [Column Name] already exists. The entity key [Column Name] requires that this set of attributes contains unique values. Select unique values and try again."}}

I have tried removing the key and using different naming convention but still end up with the same error.

Any ideas would be appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

KBilakanti1 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Anonymous ,

There might be two chances:
1. You can export the data and check if there are any duplicated data exists in the table.
2. Check the Alternate Key status, From make.powerapps.com we can't check the alternate key status (Status has to be "Active"), hence you need to navigate through legacy UI, and navigate to the entity key and there you can see the Key status, as below.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It looks like I have done something with my environment, I have had to reset the environment to scratch. I think my issue arose because I had 2 separate solutions that had created dependences on one another.

This guide helped me better understand solutions if anyone is interested.

https://www.microsoft.com/en-us/download/details.aspx?id=57777

Was this reply helpful? Yes No