Skip to main content

Notifications

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.
  • 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.
     
  • Suggested answer
    abc 123 Profile Picture
    784 Super User 2025 Season 1 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.
      

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

Featured topics

Restore a deleted flow