cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Send approver mail to multiple user from SP list based on chosen value

Hello Guys

 

Im try to implement a advanced flow approval function.

 

We had two SharePoint list. (Approver List & Order list)

The order list is for adding new items and the Approver list is to manage the approval mail based on choosen security value. If a user creates a new item he has to enter the values like name, country and so on. Also he has to choose the security level A or B in the edit from. (Security level is a calculated field based on Order list). 

 

Now if he choose A the Approval mail should go to the Managers from entry A. If he choos B, then the mail should go to the managers from entry B.

 

Flow2.png

 

Is there a easy way to do this? 🙂

 

Cheers M.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Hi @Mahoney

 

For multiple people picker see this

 

https://powerusers.microsoft.com/t5/Building-Flows/Multiple-people-picker-values-in-FLOW/td-p/257018

 

Let me know how it goes.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

12 REPLIES 12
Highlighted
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Hi @Mahoney ,

 

You could try querying Approval List using flow action SharePoint 'Get Items / HTTP Get' to retreive the approval list filtered by security level.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Helper I
Helper I

Re: Send approver mail to multiple user from SP list based on chosen value

Thanks @abm 

 

I already playing around with get item (current item id) and get items (Approval List).

But I dont know how i have to look for the security entry from the current item and map the field id from the value of security entry and the managers there.

Highlighted
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Hi @Mahoney 

 

Thanks for your quick reply. Could you post your flow screenshot?

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Helper I
Helper I

Re: Send approver mail to multiple user from SP list based on chosen value

hello @abm 

 

That is what I have so far.

 

Flow3.png

Highlighted
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Hi @Mahoney 

 

Thanks for the screenshot. This is what I am thinking:

 

First your trigger is when an item is created in Order list
Next flow action is Get the Security Level Text value from Order list. Store in this in a variable.
Next flow action is Get Items fom SharPoint list Approver list matching the Title 'A' using the above variable.

 

Is that the correct logic?

 

Also let me know what's the field type for security level in Order list? Is this an option set?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Helper I
Helper I

Re: Send approver mail to multiple user from SP list based on chosen value

thanks @abm 

 

Yes, the logic is right.

 

The security level is a normal text field. So i guess we have to look for the ID's or something like that.

 

The security level is now stored in a variable calles "SecurityLevelValue", I made a quick test and the variable is filled with the right value.

 

So now I have to care about this step: "Next flow action is Get Items fom SharPoint list Approver list matching the Title 'A' using the above variable."

 

Cheers M.

 

 

Highlighted
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Thanks for the prompt reply.

 

The next step is Get items for list Approvers, set the filter query as below

Title eq 'your variablname'.

 

If you need any help please let me know.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Helper I
Helper I

Re: Send approver mail to multiple user from SP list based on chosen value

thanks @abm 🙂

 

Yes I did that already. Now it looks like this:

How can I now set the approvers from the approval list?

 

Flow4.png

Highlighted
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Hi @Mahoney ,

 

We are using Get items so that means if there is a match it could return atleast one or more records.

Next you can check whether any match is found or not. This is optional. If you think the record is always there the you can skip the if condition.

Next we need to add a for each loop then extract the emails into a variable. Is that emails are stored under comma sepearated?  Then extract the values and create approvals.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Helper I
Helper I

Re: Send approver mail to multiple user from SP list based on chosen value

thanks @abm 

 

The approver field is a people picker field. So the emails are stored there in a normal way.

 

I try to add the for each but it dont work 😞

 

 

Cheers M.

Highlighted
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

See this post and let me know how it goes.

 

https://powerusers.microsoft.com/t5/Building-Flows/start-approval-based-on-people-picker/td-p/156151

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Super User III
Super User III

Re: Send approver mail to multiple user from SP list based on chosen value

Hi @Mahoney

 

For multiple people picker see this

 

https://powerusers.microsoft.com/t5/Building-Flows/Multiple-people-picker-values-in-FLOW/td-p/257018

 

Let me know how it goes.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,031)