web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get distinct emails fr...
Power Automate
Answered

Get distinct emails from sharepoint list and send email

(1) ShareShare
ReportReport
Posted on by 83

Hello All...
I have a sharepoint list that contains emails.  
Emails field is a text field.

Simply.... I want to get a distinct list of emails and then send an email to them.
The list name is COMPENSATION, and the email field is called EMAIL.

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @12strikes ,

     

    I've made a test for your reference:

    1\My SP list

    vbofengmsft_0-1719881524533.png

    2\My flow

    vbofengmsft_1-1719881732542.png

     

    Best Regards,

    Bof

     

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @12strikes Could you send a screenshot of the list? Does your list have all the emails in a single column?

     

  • 12strikes Profile Picture
    83 on at

    @v-bofeng-msft 
    Thanks.... That works.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard