Update a specific column value in SQL Server db of Selected Multiple Items of Gallery with checkbox by using Power Automate Flow.

[drax_2106]

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 ??

[StalinPonnusamy · Accepted solution]

Hi @drax_2106 

Here is the 2 parts (PowerApps and Power Automate)

Call Power Automate from PowerApps

To Call Power Automate from PowerApps

• Select the button
• Click Action on the menu bar
• Click Power Automate
• You should see your existing Power Automate to select 
• Select the Power Automate
• Assign the parameter

Your Power Automate will look like this

For SQL, You can use either Execute SQL query or Execute Stored procedure

[drax_2106]

Thanks a ton! @StalinPonnusamy. This helped but I did it by passing JSON in the Automate Flow.

[StalinPonnusamy]

Hi @drax_2106 

In general, an Individual parameter is sufficient if you have 1 or 2 parameters. JSON is good if we have more than few items.

[StalinPonnusamy]

Hi @drax_2106 

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.