web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / issue with Distinct bu...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by

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

 

Categories:
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard