Bulk update over 200 rows

(0) Share

Report

Posted on by CU30082123-0

Hi all!

I have an app connected to a PostgreSQL table where we update rows in bulk of 200. Currently, it takes about 8 minutes to update 150 rows. Is there any way to speed up the write-back process?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi CU30082123-0,

I would suggest using Power Automate instead. You can pass the IDs of all the items to update as a Variable in the flow upon a click of the Save button, use "Update Row (V2)" action within a For Each loop and update the rows one by one. You can use some ideas from this video but replace the SharePoint action with Update Row (V2) - https://www.youtube.com/watch?v=OnhljoOc2Hs

Here is MS documentation for this action - https://learn.microsoft.com/en-us/connectors/sql/#update-row-(v2)

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Following up to check if you were able to solve this issue using my suggestion?

Kind regards,
Nandit

Was this reply helpful? Yes No