I am currently working on a Flow that runs on a list in SharePoint. The Flow is triggered manually and when it is triggered sends an approval task to every person in a multi-person field. The number of people in the field is variable (usually between 4 and 20). It is sending the approval to everyone at once, not one after another.
Currently, this works great except for when one person doesn't respond and there is no way of knowing who still has an outstanding approval task since the Flow pauses until every individual has responded.
Has anyone found a good way to overcome this? Or to at least gain some insight into who has not responded to the Flow approval?
@danmitchell36 The Flow approval action option "Everyone must approve" will send approval at once and wait for all approvers to respond. So there is no direct way in Flow to know the response
Option 1 - would be to create a parallel branch and periodically check the status of each approval by querying CDS(Flow approval info is held here)
Option 2 - to call approval action in sequence in a loop (not assign all at once) - based on first user response - move to next user and assign the next approval)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @danmitchell36 ,
You can deposit your Approvers in SharePoint list according to your need, and add a Yes/No type column named Response to record the status of approver response.
If you build your approval process as follows, it might check who has no Response the approval.
Step1: Get items of the Approver List.
Step2: Create action Start and wait for an approval (V2), and append the ApproverEmail.
-If the approver response the approval request, update the item set the Response as Yes.
Step3: Since the number of Approvers are between 4 and 20, and they're approved at the same time. you could set the action of Apply to each by clicking the Settings and set the Concurrency Control as On, and turn up the Degree of Parallelism to 20. So, the 20 approve requests could send at the same time, not one after another.
I hope it can help you. If you still have questions, please contact us.