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

(0) Share

Report

Posted on by CU19121539-0

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?