Having issues with updating a record from Dataverse Table to SQL Server "Primary key is compound by 0 elements but 1 were provided"

Like (0) Share

Report

Posted on 23 May 2024 14:02:12 by Cwilliams12

I'm receiving an error when updating a record within my PowerApps application. I'm using a flow when a row is added, modified or deleted to update the SQL table with those changes. When updating a record, I'm receiving the following message.

"Primary key is compound by 0 elements but 1 were provided"

I've already confirmed that my primary key/column in SQL is "ID" as I have my Row ID for for the SQL update is set to the following function

"first(outputs('Get_rows_(V2)')?['body/value'])?['ID']"

I don't have any problems with adding a new record but when I'm updating a record I receive the error above. Can anyone help with updating my flow and or the function I'm using? I'm not sure what I'm needing to do to bypass this error so I can update the record.

Categories:

Connectors

General Questions

I have the same question (0)

All responses (1)

Answers (0)

developermct 35 on 29 Jun 2024 at 01:28:04

Like (0)

Report
Re: Having issues with updating a record from Dataverse Table to SQL Server "Primary key is compound by 0 elements but 1 were provided"

Based on the error message "Primary key is compound by 0 elements but 1 were provided", it seems there is a mismatch between the primary key definition in the table and the data being inserted or updated. Here are a few possible causes and solutions:

The table definition may have an empty or incorrectly defined primary key. Check the table schema to ensure the primary key is properly defined with the intended columns.
The INSERT or UPDATE statement may be trying to provide a value for a primary key column that is actually an IDENTITY column or is automatically generated. In this case, you should omit that column from the INSERT statement or remove it from the UPDATE statement's SET clause.
There could be a trigger or constraint that is interfering with the operation. Review any triggers or constraints on the table.

I hope that helps! 😊👍
Darren Neese, Power Apps MVP ➡️ Get access to my free Power Apps crash course here: https://go.superpowerlabs.co/superlanding
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up. 😊👍👍

Was this reply helpful? Yes No