When an existing list item is modified, update a SQL row

[Anonymous]

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

[Anonymous]

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?

[crisby]

Hi guys,

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?

Thanks

[rox159357]

same here can some one help point the way to use combined primary key as Row ID?

[kigenst]

Same issue. Has anyone found a solution?

[DTreg1]

Hello @kigenst 

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.

[zdenko_zahorec]

Hi there,
Try to separate primary key values by comma.

 I have table with three keys and it works fine when tested. 

 
Hope it help.
ZZ

[DTreg1]

@zdenko_zahorec ,

Wow that's cool, I'll definitely give that a try!

Thank you!

[victoraguiar]

I had the same issue and it worked for me. Thank you!