A record with matching key values already exists.

(0) Share

Report

Posted on by Nithisha

Can anyone please help with this error, As this error occured in a power automate flow while updating a row in entity step.

"error": {

"code": "0x80040237",

"message": "A record with matching key values already exists.",

"@Microsoft.PowerApps.CDS.ErrorDetails.SqlExceptionMessage": "Violation of PRIMARY KEY constraint 'cndx_PrimaryKey_Opportunity'. Cannot insert duplicate key in object 'dbo.OpportunityBase'. The duplicate key value is <redacted>.",

"@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80040237&client=platform",

"@Microsoft.PowerApps.CDS.InnerError.Message": "Cannot insert duplicate key."

I have the same question (0)

All responses (3)

Answers (0)

Parag Chapre 12,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Can you please give more details? For example, what steps are you following and when you are getting an error?

Was this reply helpful? Yes No
Shabbir 240 on at

Like (0)

Report
Copy link

Link copied!

Please check this "cndx_PrimaryKey_Opportunity" key on the opportunity table what columns are including. And then filter the table on this columns with the values you inserting from Power Automate.

Based on the error, the record should already exists. And then make sure the record you are trying to insert through power automate are using those exact values or not.

Was this reply helpful? Yes No
NathanBetters 37 on at

Like (0)

Report
Copy link

Link copied!

I have the same issue when trying to update the "Business Unites" default table for CRM, when my flow inserts a new record into the table it works just fine, but when I am trying to update a record it throws this error, which makes no sense because we are trying to UPDATE an existing record, so obviously the primary key should already exist..

Was this reply helpful? Yes No