I am new to Microsoft Flow and using the following template referenced in my subject line "When an existing list item is modified, update a SQL row ".
I'm able to connect to my SharePoint List as well as to my SQL Table on the server, I'm testing the sync and trying to update the record in the table but keep getting the below error. I have two primary keys on my sql table which are "LoanNumber" and "Underwriter". I've looked online and cannot find how to solve for this, I am using "LoanNumber" as my ROWID required column on the SQL Update Row action.
"message": "2 keys were specified, but 1 values were provided.\r\n inner exception: 2 keys were specified, but 1 values were provided.\r\nclientRequestId: c5ed77df-1d1a-47c0-a0e9-cbfabe970bb4",
Any help in the right direction is greatly appreciated.
I messed around with this some more and if I dropped the "Underwriter" primary key from my SQL table and just had the "LoanNumber" primary key then my flow worked correctly. The problem however is that the user could enter the same loannumber twice into the SP List so I can use LoanNumber only as primary key. There is an ID column which appears to be an identity column and is unique. My question now is should I change the primary key to be this ID column and map that or is there a way for me to have two or more identity columns and get the flow to recongize both in the singular ROW ID column in my flow?
I have the same issue here.....I have a table with two keys but I am only able to provide one of the keys in flow via the "Row id" field.....any chance the update sql action can accept multiple key fields?
My solution was to create a stored procedure that executes a sql statement. Then I just pass the update statement from the app to the stored procedure which will run it. Takes a little bit to get it set up and isn't perfect but it works well once it's up and running. Hope this helps.
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!