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

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Bulk insert and update...
Power Apps
Unanswered

Bulk insert and update from power apps to Sql server using flow

(0) ShareShare
ReportReport
Posted on by surbhibhandari1 13

Hi,

 

I want to bulk to bulk insert and update to sql server using flow. 

As of now 30 records, insert and update is taking around 19 second time when the table is empty. 

If I run insert and update statement from sql server it takes around 2 second to perform the operation for 30 records.

 

As of now I am passing collection which needs to be inserted or updated as parameter to flow and then running for each statement in flow to insert and update records in sql. 

Is there any better way to improve the performance?

Thanks in advance

 

Categories:
Building Power Apps
I have the same question (0)
  • RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @surbhibhandari1 

    You will not get the same performance that you get in SQL server.  That is a direct action on the datasource.  PowerApps and PowerAutomate must perform through a different method that takes time to complete.

     

    Is there any reason you chose to do these updates through a flow and not directly from your app?

  • surbhibhandari1 Profile Picture
    surbhibhandari1 13 on at

    When I used patch function for insert and update , the performance was even worse . So I thought flow will drastically improve the performance but it did not 

  • surbhibhandari1 Profile Picture
    surbhibhandari1 13 on at

    Do you want me to share flow screen shot with you?

  • RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @surbhibhandari1 

    What was your formula in PowerApps for doing it?  That is most likely where your slowdown was.  It will be faster in PowerApps than in Flow.

  • takolota1 Profile Picture
    takolota1 4,980 Moderator on at

    Anyone facing similar issues can try this batch SQL CRUD template

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338

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

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 494

#2
WarrenBelz Profile Picture

WarrenBelz 352 Most Valuable Professional

#3
11manish Profile Picture

11manish 323

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans