cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mahoney
Level: Powered On

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
Super User

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!



View solution in original post

12 REPLIES 12
Highlighted
Super User
Super User

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!



Mahoney
Level: Powered On

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.

Super User
Super User

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!



Mahoney
Level: Powered On

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

Super User
Super User

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!



Mahoney
Level: Powered On

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.

 

 

Super User
Super User

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!



Mahoney
Level: Powered On

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

Super User
Super User

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!



Mahoney
Level: Powered On

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.

Super User
Super User

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!



Super User
Super User

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!



View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,177)