cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drax_2106
Regular Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @drax_2106 

 

Here is the 2 parts (PowerApps and Power Automate)

Call Power Automate from PowerApps

StalinPonnusamy_1-1634177874690.png

 

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

StalinPonnusamy_0-1634177514315.png

 

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

StalinPonnusamy_2-1634178046469.png

 

 

View solution in original post

4 REPLIES 4
StalinPonnusamy
Super User
Super User

Hi @drax_2106 

 

Here is the 2 parts (PowerApps and Power Automate)

Call Power Automate from PowerApps

StalinPonnusamy_1-1634177874690.png

 

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

StalinPonnusamy_0-1634177514315.png

 

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

StalinPonnusamy_2-1634178046469.png

 

 

drax_2106
Regular Visitor

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

StalinPonnusamy
Super User
Super User

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
Super User
Super User

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.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,461)