Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

multiple emails for first loop

I have a flow which uses an excel sheet with a set of rows for each email. 
My flow first gets all the emails using a "Get Rows from Excel",
a "Select" to get only the emails, a "Compose" to get a unique set.
Next I have an "Apply to each" which has a "list rows",
"Select" (bringing the details for each email - multiple rows),
"Create HTML" and "Compose" to create the HTML format and
a final "Do until" which has a "Send Email" for each email with its set of rows
and a "Increment variable" to check if the count of unique emails is done. 
I have 37unique emails.  The first email, the "Do until" shows a count of
the same 37 and sends the email with the set of rows for the first email 37 times. 
The second through the rest are all fine and the email only goes out once.  Thanks in advance

Frequent Visitor


Frequent Visitor

Never mind.  I figured out another way.  thanks

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (2,048)