Microsoft Flow sends multiple email notifications

[McElroy15]

Hello,

I have a flow which sends an email whenever a new item is added to my SharePoint list.

As you can see, I want the Creator of the new item to receive an email and the so called "Érintettek", which I can translate as "people who are concerned". It is always the Creator who adds the "Érintettek", when creating an item. It can be multiple people.

Now what happens and what the problem is that if I add 4 people there as "Érintettek", then the Flow sends 4 separate emails to these people and the Creator is on copy on each of the emails.

I guess I understand why, most probably because the same rule is applied 4 times due to the Apply to each section, and the Flow runs the rule 4 times. Is there a solution for that?

Thanks

Peter

[Expiscornovus · Accepted solution]

Hi @McElroy15,

You could use a string variable and append the individual email addresses into that variable with a semi-colon character. When you use this approach you can move the send an email (V2) action outside of the apply to each action. Which will prevent sending 4 e-mails.

Below is an example configuration

1. Add a Initialize a string variable action

2. Add an Append to string variable action. In this we will add the Created by Email value from the trigger action with a trailing semi-colon character.

3. Add an Append to string variable action in the apply to each. In this we will use the Erintettek Email value with again a trailing semi-colon character

4. Add the string variable to the To field of your Send an email (V2) action.

The end result should look something similar like this.

Hope this helps a bit?