Hello everyone,
I'm trying to build out an approval that only takes the "Approved" path if more than half of the approvers submit "Approved" responses. Off the top of my head I can think of some complicated ways to make this work, but is there an easier or more straightforward way to do this? Lets assume we have 10 approvers, if 5 or more submit approved responses the flow should take the approved path.
Thanks
Solved! Go to Solution.
The responses come in as part of a collection of response objects. You can use an Apply to each and one or more variables to count the number of Approve and Reject.
The one problem with the way its setup now is that unless you turn on Parallelism in the settings of the apply to each it will only send each approval after the one before it has completed. I don't think that is what you intend. Other than that it should work.
The problem trying to do this is that the flow won't advance until all the approvers have submitted responses. So you can definitely have it advance if 5 of 10 say approve and the other 5 say reject. But there is no easy way to advance when using a single approval until all have responded one way or another.
Thanks for a quick response, I think having responses submitted in our case won't be an issue (I could of probably worded this better). Mostly just trying to figure out the "If Approved equal to or greater than 5, take approval path". If someone won't respond we will address that separately since that is a person thing at that point.
@Pstork1 I suppose my question now is, how would I count the number of approvals vs rejects? If I can figure that out it can be compared in a condition to perform
The responses come in as part of a collection of response objects. You can use an Apply to each and one or more variables to count the number of Approve and Reject.
I appreciate the info @Pstork1 ! I don't think I did things the way you intended, but this does seem to work:
Do you foresee any disadvantage to doing things this way?
To clarify the "Apply to each" is just to send an approval to each email listed on the Approvers SharePoint list.
The one problem with the way its setup now is that unless you turn on Parallelism in the settings of the apply to each it will only send each approval after the one before it has completed. I don't think that is what you intend. Other than that it should work.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
50 | |
41 | |
39 | |
35 | |
34 |
User | Count |
---|---|
68 | |
65 | |
65 | |
54 | |
49 |