Flow sending multiple emails

(0) Share

Report

Posted on by KA-28052103-0

I have a Microsoft list that has multiple columns it generates an email based on the date and a field that lists the particular email for the person needing the alert. In the email it will have certain items from other columns and a click on link to take you to that item. Unfortunately every item I have listed in body of email from Individual columns will create a separate email that contains the same information for each email so if I have 2 items listed it sends 2 emails, if I have 3 items listed it sends 3 emails etc. Of the exact same information

I did research and it is suggested making a initialize variable string Or an initialize array variable

I was able to get in initialize variable string setting to work with various modifications but the multiple emails still persisted I was not able to get in the right a variable to work at all

The problem I ran into was making sure that I was putting them in the appropriate spots ( initial initialize variable and the append to string variable) I tried various locations with different degrees of outcomes but essentially I was still getting multiple emails based on how many column I chose in the body of the email

I used string for append to string variable of
concat(item()?['Status/Value'], item()?['{Link}'])
if I used this alone I would get one email, but nothing in body of email with a link to item

I added the body of the email

concat('<a href="', items('For_each_1')?['{Link}'], '">', items('For_each_1')?['Status/Value'], '</a>')

so i would get the link, once I did this I got multiple emails again, as I did before I added initialize variable string and append To String variable making them useless as I am able to get this result without adding those two actions.

I did try to do an array variable instead unfortunately I cannot get that to work, kept saying that I needed a string variable.

 
Any suggestions on how to not get multiple emails thank so much  I am pretty much teach myself with not extensive knowledge as an FYI LOL

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @KA-28052103-0,

Whom to send the email?

You have added multiple apply to each loop due to this you are receiving the multiple emails.

Please follow below steps:

#1. After get items action add the "Compose" action.

#2. Prepare your dynamic email body in Compose action. - >Once you select the dynamic content value it will automatically wrap with "Apply to each" loop.

#3. Add the "Send an email" action.

]]]

Assuming we need to send the email to "Created By" user so select the appropriate user or pass the static user as per your requirement in "To".

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,565 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You have the Send email inside multiple For each loops. Those have arrays as input and they will loop through each item in the given array. So if you have array that has 5 items in it then that loop will Send email 5 times.

And in this case you have loop inside a loop. So that might be the reason for duplicate emails getting send.

Or if you want just one email to be sent in one flow run then move the "Send an email (V2)" after the For each loop. Also remove unnecessary For each loops from your flow (For each 2, and For each 1)

Was this reply helpful? Yes No
KA-28052103-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you for the replys I will try the above, I actually did not create the multiple for each loops after the get items I stated I wanted to send an email and the for each items self generated. I will try solution 1. for solution 2 I have tried to move the send email outside the loop and it broke the flow. while there are multiple for each it only shows the one send email, I never could figure out to move it out of the loop and work.

Appreciate all the guidance thanks

Was this reply helpful? Yes No
Suggested answer

Srini007 3,483 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KA-28052103-0,

If you are getting for each loops automatically that means you passing a array variable directly into your send email action, you should find the variable which is having a multiple values, also can you share a screenshot expanded mode and show clearly which values you are passing and also the value of that values?

Hope this helps in finding the error

Thanks,

Srini

Was this reply helpful? Yes No
KA-28052103-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I think the easiest is to start over I will show you what I started with, I start with a Microsoft list as below

it is set up to send an email to whoever the Case manger is who puts in the entry on the review date example below

my bare bones flow is below

after get items is when I create the email, which autocreates the for each control

the body/value autopopulates

which autocreates the 2 for each controls

the CM autopopulates

I assume autocreation for the for each controls

autopopulates is d/t what I put in email below

thank you Krys

Was this reply helpful? Yes No