cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

Hi @Anonymous ,

 

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

@Anonymous 

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
Anonymous
Not applicable

@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.

Hi @Anonymous ,

 

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.

Anonymous
Not applicable

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

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,370)