web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / update multiple rows i...
Power Automate
Answered

update multiple rows in Sql table

(0) ShareShare
ReportReport
Posted on by

How can I update multiple rows in SQL which meets certain filter in my flow?

 

For now, my flow is updating only first row which meets filter criteria.

 

Attached is my flow and database.Capture3.JPGCapture2.JPGCapture1.JPG

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    on at

    Hi @Anonymous,

     

    Could you please share more details about the Ask in PowerApps dynamic content filled within Filter Query field of the "Get rows" action?

    Could you please show more details about the parameters of TestLates.Run() function within your PowerApps app?

    How many records does the "Get rows" action return?

    Further, do you pass the Row id data from PowerApps app to the Row id field of the "Update row" action of your flow?

     

    I think there is something wrong with your "Update row" action, if you fill the data from your PowerApps app within Row id field of the "Update row" action, the flow would only update the only record whose Row id is equal to the data you passed from your PowerApps app.

     

    I have made a test on my side and don't have the issue that you mentioned. My SQL table's data structure as below:21.JPG

     

     

    Please take a try with the following workaround:18.JPG

    Within "Get rows" action, Filter Query field set to Ask in PowerApps dynamic content of the PowerApps trigger. Within "Update row" action, Row id field set to id dynamic content of the "Get rows" action.

     

    The flow works successfully as below:19.JPG

    22.JPG

    My PowerApps app's configuration as below:

    20.JPG

    The OnSelect property of the Button control set to following formula:

     

    '20180412_case12'.Run("UserID eq '"&Dropdown1.Selected.Value&"'")

     

     

     

     

    Best regards,

    Kris

     

     

  • Community Power Platform Member Profile Picture
    on at

    Hi Kris,

     

    First of all thank you so much for your help!

     

    Get rows is working fine for me. It is returning 3 rows which are correct but in update row, it is not showing me any ID field even though in my sql table I have given ID. 

     

    Capture2.JPGCapture1.JPG

  • Verified answer
    v-xida-msft Profile Picture
    on at

    Hi @Gopi,

     

    Do you click the "See more" button of "Get rows" action within right Dynamic content panel?

     

    Please consider take a try to click the "See more" button of "Get rows" action within right Dynamic content panel to check if the id dynamic content would be shown up.

     

    Best regards,

    Kris

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard