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

[dmistry]

Hi,

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

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.

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. 

[ScottShearer]

@dmistry 

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

[dmistry]

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

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:

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

[v-alzhan-msft · Accepted solution]

Hi @dmistry ,

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

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.

[dmistry]

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