Issue with sending one email to multiple recipients with the same email address from excel sheet

(0) Share

Report

Posted on by Figen

Hi,

I have a flow that works in the following way:

- It gets the list from excel

- Looks for the email addresses and groups the group clients column against the same email addresses and puts them in the email body

- Sends one email to the recipient that appears more than once on the list.

Everything works fine but if I edit the email body to pick up the name column, highlighted in green in the below screenshots- currently not picking up the name field, but if I add it, it modifies my flow and ends up sending multiple emails.

How can I sort this out please? I have the Table & Email as variable array

Any help is greatly appreciated.

Thanks

Figen

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Figen are you looking to send one email with multiple recipients in To?

Was this reply helpful? Yes No
Figen on at

Like (0)

Report

@annajhaveri no, separate emails to each individual, but trying to avoid sending multiple emails to the same person.
Thank you

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
@Figen After you append all your email addresses into your Email variable you can add a Compose with the following expression to remove duplicate emails.

join(variables('Email'),variables('Email'))

Then use the Compose instead of the Email variable since the Compose will only include unique email addresses.

Was this reply helpful? Yes No
Figen on at

Like (0)

Report

@grantjenkins thank you but I already have this to remove duplicate emails. It only sends multiple emails when I include the name column to bring in the recipients' names in to the email body.
I need to add a similar function to remove the multiples for Names but no matter what I tried it is just not working.

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (0)

Report

Hi @Figen ,
You could define a Name variable first, and then use [Set variable] to define the variable in Condition.
Finally, set the Name variable to null at the end of the mailbox array loop.
Here is a test for your reference:
Here is excel :

Here is flow:

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
@Figen This is how I would go about achieving what you are after.

I've got the same Excel Table/Data as you.

Below is the full flow. I'll go into each of the actions.

List rows present in a table retrieves all the data from the Excel Table.

Select gets an array of objects consisting of just the Name and the Email address.

Compose removes any duplicate objects from our Select so we have a unique set of Names/Emails to loop over. The expression is:
union(body('Select'), body('Select'))

Our Apply to each iterates over each of the unique objects.

The Filter array will filter our items where the Name is equal to the current Name in our object we are iterating over. The expression used in the condition is:
items('Apply_to_each')?['Name']

We can then use Create HTML table retrieving the Group clients from the Filter array. The expression to get the Group clients is:
item()?['Group clients']

Finally, we can use Send an email with the Email and Name from the object we are currently iterating over and including the Output from the Create HTML table which will display the Group clients. The expressions used to get the Name and Email are:
items('Apply_to_each')?['Email'] items('Apply_to_each')?['Name']

The final output/email would look like the following:

Hopefully that all makes sense and is what you're after.

Was this reply helpful? Yes No