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

How to send email to approve flow basis condition

Hi Team,

I am working one of the flow, where i have to send the email to approver to approve the request,  basically there are different departments  so once user select a department in MS Flow then request should go to correct department email id, so there are 6 department.

i wish if user select Department 1 then email should go to respective email id abc@gmail.com , 

if Department 2 then zyx@gmail.com like wise.

second if original approver of  Department 1 (abc@gmail.com) is out of office then i want to send this to another person like OPQ@gmail.com, as a backup to approve the request, and all 6 department will have another 6 email ids as backup to approve the request.

1 REPLY 1
DamoBird365
Microsoft
Microsoft

Hi @AmolMane 

 

You should consider a sharepoint list containing the details of your departments and emails, and maybe a third column for second approver depending on how you want this to work.

 

Assuming it is a list, you can use get item action with a filter

 

department eq 'department dynamic value from form'

 

This will then allow you to access the email addresses from the get item action.

 

Supply this to your approval action. 

 

In terms of having a second approval when a user is out of the office, you could use the example here

Check if the first email retrieved from get items is showing an out of office, if yes use the 2nd email, if no, use the main email.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,727)