Flow send email for every Excel row instead of the filter

(1) Share

Report

Posted on by Ponzaro

Hi everyone,

I'm totally new to Power Automate and I'm trying to create one simple flow for starting.

I have an Excel table similar to this one

Task1	Task Description 1	Date 1
Task2	Task Description 2	Date 2
Task3	Task Description 2	Date 3

I have created a flows that checks if the date of the table is equal to today a date and send an email with the entire rows. So, basically:

if Date 1= today it sends an email with Task1, Task Description 1 and Date 1.

The flow is working except for the fact that sends a number of email equal to the total of the rows. So, taking the example above, it is sending 3 copy of the same email with the same information about the first row, instead of sending just one.

This is the flow:

Can you kindly help me in understanding why?

Thanks

All responses (8)

Answers (3)

Ponzaro 15 on at

Like (0)

Report

Re: Flow send email for every Excel row instead of the filter

Thank you!😎
Verified answer

v-yujincui-msft on at

Like (1)

Report
Re: Flow send email for every Excel row instead of the filter

Hi @Ponzaro ,

Try to use the length() function.
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#length
length(body('Filter_array'))

Best Regards,
Charlie Choi
Ponzaro 15 on at

Like (0)

Report

Re: Flow send email for every Excel row instead of the filter

Hi @v-yujincui-msft ,

thank you for all the support! I can confirm that the flow is working fine and I have been also able to add an action to send a Teams message along the email.

One last request, if possible: I have seen that the email (and Teams message) are being sent also if there is no data, and so they are empty.

I have tried to add a condition that checks if the array is empty, and if yes, not send anything but I am not able to make it working. I've tried this:

It returns "false" anyway, even if there are no results. I have also tried using the expression empty without success. Do you have any suggestion on this?

Thanks
v-yujincui-msft on at

Like (0)

Report
Re: Flow send email for every Excel row instead of the filter

Hi @Ponzaro ,

You could use multiple conditions in the Filter array Action by using the expression.
I have made a test for your reference.
toUpper(item()?['ColumnName'])
Result Screenshots:

Best Regards,
Charlie Choi
Ponzaro 15 on at

Like (0)

Report

Re: Flow send email for every Excel row instead of the filter

Hi @v-yujincui-msft

thank you very much! I can confirm that everything is working fine 😀. If possible, I have another optimization in mind, if this can be configured.
I would like to add a new column where a person can write "yes" (no case sensitive) if the task has been completed, so the email will continue to arrive until that column is filled.

Task1 Task Description 1 Date 1 yes
Task2 Task Description 2 Date 2 yes
Task3 Task Description 2 Date 3

Taking the example above, only the first two rows should be selected and sent through the email.

I have tried to insert another "filter array" with this new condition but it is being ignored...

Do you think that is it possible?

Thank you very much

Andrea
Verified answer

v-yujincui-msft on at

Like (0)

Report

Re: Flow send email for every Excel row instead of the filter

Hi @Ponzaro ,

Do you want to send an email with all eligible records?
Maybe you could try as below:
Result Screenshot:

Best Regards,
Charlie Choi
Ponzaro 15 on at

Like (0)

Report

Re: Flow send email for every Excel row instead of the filter

Hi @v-yujincui-msft ,

thank you very much for the answer! I tried it and it works flawlessly 😀

Just one thing... would it be possible to send a single email with the entire list of all the rows selected instead of one email with a row each?

Thank you

Andrea
Verified answer

v-yujincui-msft on at

Like (0)

Report
Re: Flow send email for every Excel row instead of the filter

Hi @Ponzaro ,

Maybe you need to use Body as the input of Apply to each Action.
I have made a test for your reference.
1. Here is my excel.
2. Here is my Flow.
item()?['columnname']
[ { "Task Name":"", "Take Description":"", "Date":"" } ]
Result Screenshot:

Best Regards,
Charlie Choi