cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mahoney
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
abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

View solution in original post

12 REPLIES 12
abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

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.

abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

hello @abm 

 

That is what I have so far.

 

Flow3.png

abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

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.

 

 

abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

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

abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

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.

abm
Super User III
Super User III

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 blogPower Automate Video Tutorials
abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,061)