Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Bulk update over 200 rows

(0) ShareShare
ReportReport
Posted on by 12
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?
  • Nandit Profile Picture
    Nandit 1,545 on at
    Bulk update over 200 rows
    Hi,

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

    Kind regards,
    Nandit
  • Suggested answer
    Nandit Profile Picture
    Nandit 1,545 on at
    Bulk update over 200 rows
     
    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!
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard