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
