Unanswered

How to check if excel cell is empty and accordingly search user and send an email.

(0) Share

Report

Posted on by sarah27

Hi all,

I would appreciate any help with creating this flow.

I want to list an excel file and if the column "TotalHours" is empty then an email should be sent to the "Name" to remind to fill timesheet. I built it like that but I always get "False" expression result in condition.

Any help please??

many thanks in advance!!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @sarah27

Pls leave the right hand side operand empty (no value) to compare with blank value as shown below in an example:

The optimized way for large data set is to filter the blank rows using the filter query parameter:

Here, From is the column name in the excel sheet but in your case the filter query will be:

TotalHours eq ''

After adding filter query, you need to have condition in the loop to check for empty values in TotalHours column.

EDIT:

After adding filter query, you don't need to have condition in the loop to check for empty values in TotalHours column.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

1 people found this reply helpful.

Was this reply helpful? Yes No
sarah27 8 on at

Like (0)

Report

Hi @ManishSolanki

Thank you so much for your help. It worked a bit (at least I'm not getting an error). But I receive an email for every row (though I have a condition to only send an email if cell is empty). Do you have an idea why is this happening?

Another question: Could you please explain more this part how to do it? "After adding filter query, you need to have condition in the loop to check for empty values in TotalHours column."

many thanks in advance!!

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @sarah27

Apologies, it is a typo. I was mentioning that after applying filter query you don't need condition action inside loop to check for non-empty values.

Here is the full sample flow:

Excel input:

Power Automate flow:

Filter query:

TotalHours eq ''

Next, add "Apply to each" action pass the output value object to it as input. Inside "Apply to each" block, add "Search user" action & pass the name from the dynamic content:

Now, add another "Apply to each" action & pass the value object from the output of Search user action. Inside second apply to each block, add send an email action & pass the email address from the dynamic content.:

Pls note that 'apply to each 2' should be added inside the block of first "apply to each" action.

Output of the flow:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

1 people found this reply helpful.

Was this reply helpful? Yes No
sarah27 8 on at

Like (0)

Report

@ManishSolanki It worked!! MILLION THANKS!!!

Was this reply helpful? Yes No