Hello,
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.
{
"status": 400,
"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",
"source": "sql-wus.azconn-wus.p.azurewebsites.net"
}
Any help in the right direction is greatly appreciated.
Thank you