Answered

Send email using SharePoint list (unique emails only)

(0) Share

Report

Posted on by fkim

Hi all,

I am new to Power Automate, and am looking to create the following: Send an email every two weeks to contacts listed in one column of a SharePoint list. BUT: Some contacts are listed multiple times in the SharePoint column, and I don't want this flow to trigger multiple emails being sent to the same contact.

I am able to create a simple flow, but it sends multiple emails to the same contact (aka same contact email in SharePoint column 6 times? Then the user gets 6 email notifications).

Any help with screenshots, instructions, and describing the why behind each step would be appreciated. As a new user to this space, its been a lot to take in. I appreciate the help--thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@fkim I recently uploaded a YT tutorial that covers a similar scenario. Please take a look and LMK if you have any questions.

I cover how to collect all emails in a column and return an array of unique email addresses which can be looped through using an Apply to Each action.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @fkim ,
I did a test for your reference.
In my scenario:

union(body('Select'),body('Select'))

items('Apply_to_each')['Email']

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No