Hi there π I am working on building an approval flow with my team and was just wondering if this is something that is possible to do or if we are wasting our time.
We have a flow that runs when a new item is created in a SharePoint list. This then sends it out for approvals to 20 different departments, whose contact details are listed in a Stakeholders SP List. It loops through the list and sends out the approvals that way. Then it waits for all the approvals.
We want to be able to output the status of these approvals live back into the SP List where the item was created, so we would have a column for each department. Easiest way to achieve this would be to have 20 approvals flowing in parallel, and then update the item before waiting with the responses, however we found that once we have 5+ parallel items the Power Automate stops being responsive.
The workaround we came up with was to build up a JSON object that would be updated in between sending out approvals and receiving responses, however we have so far been unable to build a JSON object through the flow. Manually inputting data works, but as soon as the JSON variable is set using an Output from another action the flow breaks. We tried using the JSON variable itself, array, string, just does't like it.
Is this a viable solution or is there any other way to achieve this functionality?
TL;DR: Output approval status for multiple approvals back into the SP item that is being approved in real time
Thanks for your help,
Egor
Hi @Anonymous ,
Please create a new post for your final question details.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Alice,
Thanks for all your help, but perhaps I'm not phrasing the question correctly. Here are the lists from which the flow works:
Approvers List
Items to Review List
The flow is initiated when a new item is added into the Review List. The flow then gets the correct approvers from the Approvers List by filtering them by region. It then loops through each one of them and sends them an approval email. We want to be able to output their responses in real time back into the Review List like in the table above. It would be ideal if we could update a specific column based on a variable(i.e. we'd save the Department field as a variable then would update the "Department + Status" column), but that functionality doesn't seem to be available.
We also tried using a JSON object to collect these, but this didn't appear to work.
Thanks,
Egor
Hi @Anonymous ,
The screenshot as below:
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How can I get the approval status of each approver from that?
Hi @Anonymous ,
You could create the array with all the email address and create the flow as screenshot below:
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1