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