update multiple rows in Sql table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

Please take a try with the following workaround:

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:

My PowerApps app's configuration as below:

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

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

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No