Unanswered

Approval flow with a variable/dynamic number of approvers

(0) Share

Report

Posted on by Quinzio

In sharepoint I want to create an approval flow (all must approve) with a variable/dynamic number of approvers.

My idea is to create a custom column called "Approvers" where I manually write the emails of all the approvers I want, separated by ";". Eg "name1.surname1@example.com; name2.surname2@example.com; ..." as shown in picture 1.

Picture 1

Then, according to picture 2, the approval task sends the email to all the emails written in the "Approvers" column.

Picture 2

Picture 3

The approval flow works. However, by now I have to enter manually the string "Approve" as many times as the number of approvers in condition step, as shown in picture 3. I want my flow to automatically set the string "Approve" in the condition step according to the quantity of approvers involved in the flow, since the number of approvers may vary.

Could you help me to implement a dynamic condition step?

I'm also open to other new solutions if my solution is not efficient. The only aim is to manage an approval flow with a variable number of approvals in which all of them must approve.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Quinzio I don't know if I understand you well but you need to do something like this.
Every output with an approve?
If is yes, I'm sorry to tell you that you can't do this.

Maeby to could try with a loop.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @Quinzio

You can use ‘Responses’ instead of ‘Outcome’ as your dynamic content.

Responses is an array of all the outcomes.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
NadegeG 29 on at

Like (0)

Report
First of all, thank you for sharing this flow.
This is exactly what I was looking for.

In my library, I have a PM (project manager) field that will be filled in manually with one or more project managers names. There is no way to automate this part as there is no rule: one invoice may involve several validators from different teams..
I'd like each of them to validate the invoice.
I've tried to adapt the flow but I encounter two problems :

first, I can not find "Get file property 3". My only choices are "Get file (properties only)" or "Get file properties". Is that a problem? which one should I choose?

whenever I try to use "Compose" (=message in French), Power Automates places it in a loop. And I can not get rid of it.
Can someone help me?

Thanks in advance and have a very merry Christmas.

Was this reply helpful? Yes No