Unanswered

Avoid duplicate email addresses while automating email send outs

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I am trying to set up a flow that will send a reminder email to all 'site owners' (see first image below) on a sharepoint list. However, before sending out the email I want the flow to check if there are duplicate email addresses in the column 'site owners'. If yes, then they must be skipped such that each site owner only receives one email.

This is what I have so far.

Does any one have any suggestions for how I can set up a duplicate check with a condition that checks for email addresses that appear more than once and eventually sends out out ONLY one email to each site owner.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous The SendMail will send only one email even if the emails are repeated in the To, Cc or Bcc. I've tried this from PowerApps and it works.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT ! I tried that and it did not work, it sends out the email to an address as many times it appears in the list. Image below is an example of how it was set up. Under "Contacts" email addresses are listed.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous OK I know the issue, you are not sending one email but one email for each item. So you have to filter your Items before you hit the Apply to Each or if it is just a generic message, you could build a string with all the email addresses and then send them as one email.
I did a test as seen below, sending the email to the same address 3 time, but received it only once.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for checking. I tried to run it in a similar way and received an error.

"Contact" is the email address value fetched from the sharepoint list. This has to be included such that apply to each function can work

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous The way you are doing, surely there will be multiple emails b'coz your are looping thorough your entire "Contact" and sending an email to each contact. You will have to get the distinct records. Please look at this article that explain how to do it, https://www.c-sharpcorner.com/article/get-distinct-count-from-sharepoint-list-item-using-power-automate/

Was this reply helpful? Yes No