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

Community site session details

Session Id :
Power Automate - Using Flows
Suggested answer

Send emails to all addresses, even if recipients are in different SharePoint list columns.

(0) ShareShare
ReportReport
Posted on by 2
Hi All,
 
I am quite new with Power Automate and I cannot find out the solution for my problem.
 
I have a SharePoint list with several different column. When the Request Status changed, I would like to send notification to all recipients that added to columns highlighted with red on my screenshot.
 
 
With some reason my flow doesnt work, because instead of sending the email for example 4 different email addresses, sends the email just to the first column email address and in the "to" section 4 times appears the same email address. What do I do wrong? I even tried to add the other 3 column reference to CC section aswell, but still no luck.
 
Please note, to the email columns can be added multiple addresses as can see in row 3. Can someone please help me how should I setup the flow that it would send email to all email addresses that appears in the same row?
 
 
 
Thank you.
I have the same question (0)
  • Suggested answer
    abc 123 Profile Picture
    784 Moderator on at
    Send emails to all addresses, even if recipients are in different SharePoint list columns.
    What do the column names matter if every email in every column gets an email when anything happens? Simply make a single text column populated with a comma-separated value with all the emails.  Otherwise, you'll need to create a variable, and populate it on the fly.
      
  • CU19121539-0 Profile Picture
    2 on at
    Send emails to all addresses, even if recipients are in different SharePoint list columns.
    Not every email in every column gets notification. If the status for example "rejected" only the requester and approver gets notification, not everybody. 
     
    So I assume I will need to create this "variable" as you mentioned, but Im unsure how as does not matter what I tried, did not work.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 682 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 549 Moderator

#3
chiaraalina Profile Picture

chiaraalina 330

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow