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?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
DTreg85 111 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
michaelshparber 111 on at

Like (0)

Report

@DTreg1
Just beware of SQL injection...

Was this reply helpful? Yes No