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

(0) Share

Report

Posted on by surbhibhandari1

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:

General Questions

All responses (5)

Answers (0)

takolota1 4,894 Super User 2025 Season 1 on at

Like (0)

Report

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

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
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report

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

@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.
surbhibhandari1 13 on at

Like (0)

Report

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

Do you want me to share flow screen shot with you?
surbhibhandari1 13 on at

Like (0)

Report

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

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
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report

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

@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?