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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending an email to ad...
Power Automate
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

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    Hello,

     

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

     

    Thanks,

    Anna Jhaveri

  • henanson Profile Picture
    2 on at

    Hi,

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

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    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

  • srose Profile Picture
    94 on at

    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

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard