cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmistry Post Prodigy
Post Prodigy

How to send email to distinct emails to notify about overtime request approval

Hi,

 

I have a flow that runs once every two weeks on Friday on a recurrence schedule. Below is the screenshot of same.

Capture.JPG

As you see above, it gets overtime items from last two weeks from sp list and then creates a table, lastly using send email with options action, I am sending one email showing tabular view of items like below.

Capture.JPG

This email basically goes to the office manager and once reviewed, Approve is clicked from the email body, so on Approve, flow then performs last action, updating status column from 'Pending' to Approved for all these items. Now once this is approved, I would like to send employee an email that your pending overtime requests have been approved for the last two weeks.

 

Now if I do add 'send an email' and send to 'Empployee Name Email' from get items, SharePoint user is going to get 4 separate emails so somehow I want to grab distinct emails, store them in variable and use that to send emails out, that way only one email is sent out post approval to the user. Can someone please help me achieve this, thanks in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: How to send email to distinct emails to notify about overtime request approval

Hi @dmistry ,

 

Please format the Unique names variable with string and join by ; refer to my screenshot below:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: How to send email to distinct emails to notify about overtime request approval

@dmistry 

Here is a link to a blog post that details one techique of accomplishing your goal.

 

 

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

Scott
dmistry Post Prodigy
Post Prodigy

Re: How to send email to distinct emails to notify about overtime request approval

@ScottShearer  Thanks for sharing that article, was very helpful. 

 

I am testing and looks like I am able to fetch the unique emails for respective users, however my send an email action seems to be failing like below.

Capture.JPG

Capture.JPG234.JPG

 

Both the emails are valid, no issue with that but in my thinking may be its not liking the way emails are passed into the  'To' box for send an email action. Please see my testing flow screenshots below:

Flow1.pngFlow2.JPG

Thoughts, can you please let me know what is worng here, many thanks in advance.

Community Support
Community Support

Re: How to send email to distinct emails to notify about overtime request approval

Hi @dmistry ,

 

Please format the Unique names variable with string and join by ; refer to my screenshot below:

1.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
dmistry Post Prodigy
Post Prodigy

Re: How to send email to distinct emails to notify about overtime request approval

@v-alzhan-msft  Excellent, thank you so much, that worked. 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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
Users online (8,784)