Announcements
I want to update the column "status" in my sql server db table for multiple items in my gallery having a checkbox next to it, on click of a button. The button should run a power automate flow that will update the status of the selected items in a gallery in the sql server db. I don't want to use 'patch' function. Can you please suggest me how to implement this use case with the help of automate ??
Hi @drax_2106
Here is the 2 parts (PowerApps and Power Automate)
Call Power Automate from PowerApps
To Call Power Automate from PowerApps
Your Power Automate will look like this
For SQL, You can use either Execute SQL query or Execute Stored procedure
Thanks a ton! @StalinPonnusamy. This helped but I did it by passing JSON in the Automate Flow.
In general, an Individual parameter is sufficient if you have 1 or 2 parameters. JSON is good if we have more than few items.
Please let us know if anything needs on your post. We can help with this.Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232
