How i can get all the users' responses before updating the list item inside my MS Flow

Question

I have the following MS Flow:-

and i have a SharePoint list with an Approvers field as follow:-

Currently i got this scenario:-

let say i create a new item >> set the Approvers fields to UserA & UserB.

then both users will get an approval request.

but when the first user Accept the request >>  the status for the item will be changed to Resolved..

While what i am trying to achieve it to wrap all the users' responses and then update the status, as follow:-

if all users Approve then the status will be set to Resolved

if all users Reject then the status will be set to Closed

if some users approve while the other reject, then the status will be set to "Partially Approved"..

so i do not want to update the status until all users provide their responses...
so can you help on how i need to modify my flow to implement the above?
Thanks

Matiur Rahman · Answer

I think you can accomplish this with the following steps:

Declare an Array variable to collect [Outcome] from all approvers
Within the [Apply to each] loop, use [Append to array variable] action to append the [Outcome] to the variable
Outside the [Apply to each] loop, apply the business logic to the values in the array to come up with the Final Status, and then update the list with [Update Item] action

Screenshot showing my test case

Outcomes from all Approvers

The expression to determine the Final Status
if(and(contains(variables('varApprovalStatus'), 'Approve'),contains(variables('varApprovalStatus'), 'Reject')), 'Partially Approved',if(and(contains(variables('varApprovalStatus'), 'Approve'),not(contains(variables('varApprovalStatus'), 'Reject'))), 'Approved','Closed'))

You can test the logic separately as shown in the screenshot below

The Final Status for this example

How i can get all the users' responses before updating the list item inside my MS Flow

One Answer

Screenshot showing my test case

Outcomes from all Approvers

The expression to determine the Final Status

Add your own answers!

Ask a Question