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?

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

abc 123 784 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
CU19121539-0 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No