How to send one email to multiple recipients in the same email using Powerautomate

Like (0) Share

Report

Posted on 28 Feb 2022 15:37:16 by n1cky488

HI, I'm a newbie in Power automate.

I have been trying to set-up a flow where you send out one email to multiple recipients in one go.

I can't seem to be able to set this up.

I have been able to set-up one flow that 1 email is sent to 1 recipient only but that's not what we want.

Grateful if someone can share how to build up the flow best as have been trying for past days.

Many Thanks for your help!

All responses (6)

Answers (2)

Verified answer

n1cky488 24 on 24 Mar 2022 at 03:36:57

Like (0)

Report

Re: How to send one email to multiple recipients in the same email using Powerautomate

for clarity sake: this is the right solution
Verified answer

n1cky488 24 on 24 Mar 2022 at 03:34:24

Like (1)

Report

Re: How to send one email to multiple recipients in the same email using Powerautomate

Hi, I managed to figure out the flow. For everyone's benefit, herewith the flow how to set it up
n1cky488 24 on 23 Mar 2022 at 15:37:41

Like (0)

Report

Re: How to send one email to multiple recipients in the same email using Powerautomate

Hi Jdoss, thanks for your reply and finally got some time to look at this again.
I tried to follow your instructions but my flow doesnt seem to work, and have been also watching video's etc but to no avail. This is how the flow looks like now. The flow stops at the Step "append string"
Hope you can help. Thanks for your advise in advance!
jdoss 458 on 01 Mar 2022 at 14:29:31

Like (0)

Report

Re: How to send one email to multiple recipients in the same email using Powerautomate

So, before the apply to each, use "initialize a variable" and create a string, then in the apply to each call "append to string variable" and add the email address to it followed by ";". Then take the send email out of the apply to each and put it under it. You'll have to something else for the subject. Then use your variable in the TO field. Before the email, add a "Compose" and put the string variable as the input, then for troubleshooting you will be able to see exactly what you have.

The apply to each is going through every row of data you have and doing something, in this case sending an email based upon the current row it is going through. If you need to get data from the rows you will have to do so then send one email at the end. It depends on what all you are getting from the spreadsheet, if you need more data from it then you can filter the data and create an html table to send in the email.
n1cky488 24 on 01 Mar 2022 at 01:43:06

Like (0)

Report

Re: How to send one email to multiple recipients in the same email using Powerautomate

Hi jdoss, many thanks for your reply.
i forgot to tell: i wanted to use that the email addresses are listed in an excel sheet.
so the flow i've been trying to build is that it reads the excel sheet and combines the email addresses in the TO field.
Now the flow puts only 1 email address in TO field.
see print screen of my flow

do you know how to do this?
Thanks for your help!
jdoss 458 on 28 Feb 2022 at 17:02:22

Like (0)

Report

Re: How to send one email to multiple recipients in the same email using Powerautomate

You can just enter the email recipients separated by semi colons.

Ex.
In the to field of the email
email1@place.com; email2@place2.com; email3@place2.com; email4@place.com