24
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!
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!
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.
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!
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
#1
WarrenBelz
146,708
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,030
Most Valuable Professional
Share
Report
All responses (
Answers (
