Approval Flow

(0) Share

Report

Posted on by mel_

143

Hi, I have the below flow,

Screenshot 2024-02-20 162632.png

I have an Excel, where the main column consisting with

username | user email | supervisor name | supervisor email

user 1 ........ super A ...........

user 1 ........ super B ..........

user 1 ........ super C ..........

user 2 ........ super B .........

user 2 ........ super D ........

. . . .

Now, how my flow working is, the approval is sent to all supervisors and all of them need to respond in order for the flow to continue.

But, my goal is to have the flow to work like this, where only one supervisor need to respond, and the flow will continue.

How to set this for each user? Can someone show me how to modify the flow?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @mel_

If you are looking for stopping an approval when any of the approvers approve/reject and flow continue from there then refer the below sample flow:

After "List rows present in a table", add "Select" action to create a list or array of supervisor email. Pass the value object from List rows action in "From" parameter:

Click "Switch Map to text mode":

Add and expression to add the supervisor email in the array. Expression needs to be added in the expression box as shown below:

item()?['supervisor email']

Pls replace the column name with actual one in the above expression.

Next, add compose action to create colon separated email addresses of all supervisors. You need to write an expression in the value parameter:

join(body('Select'),';')

Finally, add approval action and set the 'Approval type' parameter as 'Approve/Reject - First to respond'. Pass the output of compose action in the 'Assigned to' parameter:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
mel_ 143 on at

Like (0)

Report
Copy link

Link copied!

hi @ManishSolanki , thanks for the reply. May i know, is this flow, especially for the join expression, is it apply to each user? Meaning that when this particular user submit their ticket, the flow will work within their particular supervisors?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @mel_

For that, you need to enter filter query in "List rows present in table" action to get all the supervisors of a user. I mean you need to filter the records in excel sheet based on a user and then add the actions which I have mentioned in my previous reply.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mel_ ,

I did a test for your reference.

My Table:

Add a condition in the 'List rows present in a table' control to filter out the information of the specific user entered, and then use the 'select' control to obtain the user's specific supervisor email. This ensures that a specific user submits a work order and the flow works within a specific supervisor.

My Flow:

username eq '@{triggerBody()['text']}' @items('Apply_to_each')?['approverResponse']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No