cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swathirajan
Frequent Visitor

Flow using multiple approvers from SharePoint List

Hi all,

 

Here is my requirement.

 

  1. The user creates a item in SharePoint list with department and pick multiple approvers.
  2. The email is triggered to me administrator to check the details.
  3. The approval will go to all the approvers
  4. As soon as we receive one approval, the flow is considered complete.

 

The issues I faced are:

  1. When I select multiple people using 'Person/ Group' column, the email is triggered to me multiple times based on the number of approvers.
  2. Can you please tell me how to remove "Apply to each" getting added automatically?
  3. When I manually enter approvers email addresses, the email addresses are separated by comma. So the approval task is not getting triggered as it is not distinguishing the comma as separate email addresses.
  4. How to create cascading dropdowns WITHOUT powerapps?

 

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User III
Super User III

@swathirajan 

Please see my example below.

I believe your issue is that a separate approval is being created for each approver.  Flow automatically adds a for each loop when you operate on an array, collection, etc..  Since there can be more than 1 approver, Flow automatically adds the loop.

In my example, I loop through the approvers and add each one to a string variable followed by a semicolon (;). I reference the variable in the approval action.

Please let me know if you have any questions.

image.pngimage.png

Also, if you want to edit/change SharePoint list forms, PowerApps is the answer - sorry...

 

 

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

Scott

View solution in original post

4 REPLIES 4
ScottShearer
Super User III
Super User III

@swathirajan 

Please see my example below.

I believe your issue is that a separate approval is being created for each approver.  Flow automatically adds a for each loop when you operate on an array, collection, etc..  Since there can be more than 1 approver, Flow automatically adds the loop.

In my example, I loop through the approvers and add each one to a string variable followed by a semicolon (;). I reference the variable in the approval action.

Please let me know if you have any questions.

image.pngimage.png

Also, if you want to edit/change SharePoint list forms, PowerApps is the answer - sorry...

 

 

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

Scott

View solution in original post

swathirajan
Frequent Visitor

Thank you very much for your quick response!!!

 

I initialized the variable and appended it.

Then I added an approval task where the details of list item is assigned to our team for validation.

 

2Teamcheckstask.jpg

 

Once approved, the task is assigned to Manager for approval.

 

3ManagerApproval.jpg

 

When I triggered the task, I got only one email as a admin (which is good sign).

But the flow skipped the Manager approval and completed the workflow.

There is no failure notification in the flow for me to check whats the issue.

 

Can you please shed some light as what am I missing?

@swathirajan 

If your goal is to have a second approval if the the first request has been approved, you need to have a condition that checks the Outcome of the first approval.  If the Outcome is "Approve" then proceed to the second approval. 

image.png

If, in th second approval you have a list of approvers to which a single approval is to be assigned, then you need to do the same thing that you did on the first approval - build a semicolon delimited string of approver emails in a variable and reference that variable when selecting approvers in the second approval.  The Flow in your screen shot will assign a separate approval to each secondary approver.  

 

 

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

Scott
swathirajan
Frequent Visitor

Thank you for your response.

I am able to send email to multiple users by initializing and appending variables.

Helpful resources

Announcements
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

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (43,490)