SQL Update Row with more than 1 Row ID

(0) Share

Report

Posted on by DTreg85

111

Hello,

I know that right now, if I want to update a SQL row, it's looking for a "Row Id" of one value. I'm just wondering if there is any future or progress on looking at an option to be able to update a table with more than one Primary Key column?

All responses (5)

Answers (1)

michaelshparber 111 on at

Like (0)

Report

Re: SQL Update Row with more than 1 Row ID

@DTreg1
Just beware of SQL injection...
DTreg85 111 on at

Like (0)

Report

Re: SQL Update Row with more than 1 Row ID

Hi @v-litu-msft ,

Thank you for the reply, I'm not positive if this will work for on-prem servers like in my case. I was actually able to do another work around though that it actually a little more universally useful. I've created a stored procedure to "EXEC (@SQLSTATEMENT)". I then pass that parameter to anything I need and build the update/insert/delete statement inside the app.

So far so good!
Verified answer

v-litu-msft on at

Like (0)

Report

Re: SQL Update Row with more than 1 Row ID

Hi @DTreg1,

If you want to update a table with more than one Primary Key column, you could Get rows And Filter Query to get these rows you want, then update Rows by using the ID.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: SQL Update Row with more than 1 Row ID

Hello @DTreg1
consider submitting your idea:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
ChristianAbata 8,947 Most Valuable Professional on at

Like (0)

Report

Re: SQL Update Row with more than 1 Row ID

hi @DTreg1 there is no update into SQL server conector.
https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=&searchterms=power%2Cautomate
here more updates
https://flow.microsoft.com/en-us/blog/