Power Automate send duplicate Email after excel filer query

[MohamedMohamed]

Hello,

Please, I need support from you where I have an Excel table with actions. I used Power Automate to send an automatic email for late actions. I used list rows present in a table, then a filter query. Then I used HTML and sent email V2.

It works successfully for filtering actions but not sending actions in one email. It sends several emails for late actions. If there are two late actions, it sends two emails for all the late actions together.

I want all late actions in one email.

Below screenshots: 

1: the data source table:

2- list rows present in table with filter query:

2: create HTML:

3- for each

4: send email V2

5: my email:

[berilevliyaoglu]

It is because "send an email" action is inside of a for each loop which executes the mail action for each excel row in the output.

To prevent this, you can delete the loop and use "send an email" action alone by itself. You must edit "to" and "subject" parameters since they are forcing you to have a loop. If the late actions in the table have same email address, you can use first() function to get the email address from the first late action row. However if they could be different email addresses for the late actions, your solution makes more sense.  Similarly for the subject parameter, if you use first() function, the email subject will be the SN of the first late action. However, you can create a variable and concatenate the SN's of the late actions and use the variable for subject parameter. 

Let me know if you require further explanation.

If it helps, please mark as solution 😊

[MohamedMohamed]

Thanks, @berilevliyaoglu , appreciate your support.

I'm a beginner in Power Automate and  I do not know details.

By removing apply to each, I received the following error:

"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'For_each' referenced by 'inputs' in action 'Send_an_email_(V2)' are not defined in the template."

Also I applied First() in 'To' and 'Subject' but I'm not sure am I right or not?

[berilevliyaoglu]

You need to use first() function to get the first element of the array, which the excel list row action gave you as output. In the function area, please write first(), then in between the parentheses, please click dynamic content and click EMAILS. Do the same for the SN in the subject parameter. 

Welcome to Power Automate by the way. I tried my best to explain but if it is still unclear, you can check some tutorials which uses excel list row action. But simply; when you use list rows action, the output which you see in the dynamic content as excel column names, are arrays. For instance, EMAILS variable is an array and its elements are the corresponding values from the excel rows that you have as output (late actions). 

In my opinion, you can have a condition checking whether the late actions belong the same email addresses or not. Because if they are different, you may want to send the same email to each recipient. However if they are same, you can send one email by using the first() function. 

[MohamedMohamed]

Thank you for your help @berilevliyaoglu