Flow send email for every Excel row instead of the filter

Like (1) Share

Report

Posted on 30 Apr 2022 14:47:07 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 16 May 2022 at 17:33:04

Like (0)

Report

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

Thank you!😎
Verified answer

v-yujincui-msft on 16 May 2022 at 02:31:17

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 15 May 2022 at 08:35:40

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 13 May 2022 at 02:00:21

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 12 May 2022 at 18:38:12

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 06 May 2022 at 01:46:27

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 05 May 2022 at 18:18:10

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 02 May 2022 at 06:00:29

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