Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Sending an email to addresses in a SharePoint List column

(0) ShareShare
ReportReport
Posted on by 2

Power Automate newbie here. I'm attempting to send an email to addresses contained within a SharePoint List column. The List contains a column containing one email address per row (each row is a personnel record). I need to send an email to all entries in the email column.

 

I've found similar scenarios in the forums, but not one that specifically matches mine. I've read that creating a loop may be part of the solution, but I haven't found information on how to create a loop for the cloud version, which I'm using. So far, I've attempted what's shown in the screenshot below, but I receive an error stating the values are in an array even after specifying a semicolon in the join function.

 

Any help is greatly appreciated!

 

CleanShot 2020-12-12 at 01.37.05.png

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Sending an email to addresses in a SharePoint List column

    Hello @srose, so are you looking to get items from SharePoint list, and join the email address stored in SharePoint list? 

  • srose Profile Picture
    94 on at
    Re: Sending an email to addresses in a SharePoint List column

    I have similar question/issue. In prior posts I saw where someone used Select control and then Join control. Can you provide more details on your solution?

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Sending an email to addresses in a SharePoint List column

    Then i think you need to just join the email address in string in the apply to each loop and put the send email action outsite the apply to each loop and use that string variable in the "To" property of send email action

  • henanson Profile Picture
    2 on at
    Re: Sending an email to addresses in a SharePoint List column

    Hi,

    I need to send one single email to all email addresses. Thanks!

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Sending an email to addresses in a SharePoint List column

    Hello,

     

    So you need to send one single email to all email addresses, or one email to each email address?

     

    Thanks,

    Anna Jhaveri

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1