cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Resolver II
Resolver II

How to only advance an approval if half or more approvers submit approved responses?

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

7 REPLIES 7
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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 

Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

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?

 

Screenshot 2021-02-22 154213.png

Screenshot 2021-02-22 154245.png

Screenshot 2021-02-22 154302.png

To clarify the "Apply to each" is just to send an approval to each email listed on the Approvers SharePoint list.

Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (59,620)