Scheduled summary approval flows with variables concurrency and updates

[HuwSy]

Hi

More a possible how to than a query here after spending a while pondering and a few search attempts on here with no resolution so i though i would post my results here in case it is of use to anyone else here.

The requirement was seemingly simple daily approval task/email grouped by user (so each user only gets 1 email with all the relevant apps grouped within the 1 approval task) and approving that would update all of their related apps for the day.

Solution was as follows;

Query the (SP list) data in this instance and loop through to find the distinct users (possibly could have been done cleaner)

Loop within each user (concurrency set to 1 so i can use variables safely) build up the required task body and related item ids into variables, create (but not wait) the approval tasks, store the approval IDs, item ids and a few other parts into a variable and append to an array

Loop through the new approvals array (concurency of 50) waiting for the outcomes then on approve or reject use the other parts of the approvals object such as the stored IDs to update the list items.

Hopefully this is of use to someone else out there.

[v-litu-msft · Accepted solution]

Hi @HuwSy,

Thanks for your sharing about the summary approval response solution. Your solution is very helpful to the construction of the PowerAutomate community.

You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu