Announcements
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?
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/
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 TuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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!
@DTreg1
Just beware of SQL injection...
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 463
11manish 264
