Answered

Bulk update

(0) Share

Report

Posted on by PPEnthusiast

Hi,

I am calling power pages cloud flow to do multiple record updates, the flow runs are executing sequentially which is resulting in poor performance on power pages.

The flow also involves calling child flows with multiple apply to each and multile record updates.

The flow is taking around more than 30 secs to complete which is resulting in visible deal in powrr pages leading to poor performance.

Can we enable concurrency while having all the flow runs to execute parallely, along with improving performance on power pages and having the flow running synchronously to have real time update on power pages based on flow output?

Or is there any way to do bulk updates in power pages?

Categories:

Power Apps portals

Design & build

Customize & extend

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Fubar 8,441 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Whatever logic you have in your flow you would need to be able to do client side in JavaScript/JQuery (any looping etc would be quicker than in flow). With the Power Pages Web API you can read/create/edit/delete/associate records but the API itself doesn't have logic.

Depending on what you are doing you may also need to consider security e.g. inside the Power Pages Flow the objects it is working with aren't exposed back to the portal only what you return from the flow.

1 people found this reply helpful.

Was this reply helpful? Yes No
PPEnthusiast 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply @Fubar

I am using global variables so the apply to each and also using nested apply to eaches which is slowing down the performance.

Please can you let me know if we can use power pages web api for the updates, will it be quicker then?

Was this reply helpful? Yes No
Suggested answer

Fubar 8,441 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

There is not enough information to provide an accurate answer. But, there is no standard out of the box way to do bulk updates.

If you were wanting to update items in a List or subgrid, then use JQuery/JavaScript to add a new column and put a html checkbox in it that allows you to tag the items and add a new button using JavaScript/JQuery that will get the id's of the tagged rows and pass those values to the Power Pages Flow.

From experience Flow itself runs very slowly where there are Apply To Each. Flow without Apply To Each generally runs reasonably quickly. Depending on what you are doing (e.g. if you can avoid setting variables inside the Apply to Each as they have global scope) under the settings of the Apply To Each node you can set it to run parallel/concurrent (sometimes instead of named variables you can add an item onto a array),

similarly sometimes you can have branches that could run in parallel in which case when you add the node choose to branch parallel.

Depending on what you are doing sometimes you can use an Array Filter instead (these run extremely quickly) of Apply To Each e.g. if the outcome is to get a subset of data/records.

Was this reply helpful? Yes No