cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akhan12
New Member

issue with Distinct bulk email with excel data to email with HTML table

Hi I am new to power automate and I have created a flow to capture data from excel table and applied union to send unique email with HTML table but some how it is send same email multiple time like if I have 13 row with ABC email then it is sending 13 emails with the same content but I want it should send only one email.

 

Please suggest on the same

 

akhan12_0-1660328233617.pngakhan12_1-1660328275618.png

akhan12_2-1660328328237.pngakhan12_3-1660328366981.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @akhan12 ,

 

It is due to the "Apply to each 3" as it was looping on all the items of the Excel table. It is not necessary. All you need to do is adding a Compose operator with following expression

join(outputs('Unique Emails'),';')

 use output of this operation for the To input parameter of the Send an Email action.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

1 REPLY 1
v-jefferni
Community Support
Community Support

Hi @akhan12 ,

 

It is due to the "Apply to each 3" as it was looping on all the items of the Excel table. It is not necessary. All you need to do is adding a Compose operator with following expression

join(outputs('Unique Emails'),';')

 use output of this operation for the To input parameter of the Send an Email action.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,000)