Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Update a row in SQL Server fails, because the ID for update is sent with update fields request

First, it is some imcompreensible that Flow doens't have an update component allows to update a row with another fields beyond the id field. When we do complex logics with data, this is necessary.

Second, I am trying to update a row, after be obligated to go field by field, to check some condition, and when the condition is reached, and I call the update step, an error occurs because the request to update is sending the ID in the group fields that I want to update.

I think it is a component error, and nothing that could be fixed with alternate paths.

Screenshot from 2017-07-13 18-28-51.pngScreenshot from 2017-07-13 18-29-57.png

Community Support
Community Support

Hi rodrigosaraiva,


What’s the trigger of your flow? How is the id field for action “SQL – Update row” configured?


To test this issue, I create a simple flow. The flow is triggered by “SharePoint – when a new item is created”, followed by the action “SQL – Update row”.

Then create a new item to trigger the flow, if the id is already existing in SQL table, it will run succeed.

Screenshots for the flow configuration and run details:




Please show me more details to reproduce this issue on my side.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank for your repply.


but the problem is: I have a different structure from Sharepoint List and my database model, and this thing I can't change, because the database is receiving data from other diferent systems.

My trigger is an existing item is modified, then I get the item, I compose an external_id (it is how I need to control the integration between the list and database table, because the ID of a list cannot be the ID of table, and this is the reason that I complain because I cannot get a table row by another field different from table ID), then I get all the rows from table, and trying to identify the table row by a condition, to do an update. Everything is right, but when the update is sent to database server an error occurs because the ID field is sent to be updated to with the modified fields, and SQL Server don't allow update the ID field. I think the error is in this point.


Screenshot from 2017-07-14 10-42-21.pngScreenshot from 2017-07-14 10-52-28.png

Hi rodrigosaraiva,


Thanks for clarification with more details.


As you mentioned, SQL Server don't allow update the ID field, so you will not be able to update the row with the modified ID field.

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I think you do not understand the problem yet. I am not sending the Id field for update. I don't want modify the id field.

The component is doing that. That is the problem.

This update row component is sending the id for update, when is suposed to use the id only to identify the row.




I am having this same issue.  I'm attempting to update a row where the ID is an Identity Specification (numeric id auto incremented by the sql server).  The flow 'Update Row' action attempts to update this ID as well, which seems to be a bug as the selected row identity should never be updated.  As it stands, it seems impossible to update rows that have sql generated row identities as the primary key.

Not applicable


Hi - I have also faced the same problem - trying to document how I compensated for that

Not applicable

Hi, I'm also hitting the same problem. The identity column should not be passed along to the update or it should include set identity on during update.


Anyone has the solution? Without the fix, the SQL update row totally cannot be used.

Is there a solution for this?

Advocate II
Advocate II

Ugh - no fun to find a problem with no solution...

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,183)