Answered

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

Like (0) Share

Report

Posted on 11 Dec 2023 10:41:18 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!!

All responses (4)

Answers (1)

sarah27 8 on 11 Dec 2023 at 12:49:48

Like (0)

Report

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

@ManishSolanki It worked!! MILLION THANKS!!!
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 11 Dec 2023 at 12:35:57

Like (1)

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

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
sarah27 8 on 11 Dec 2023 at 12:14:19

Like (0)

Report

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

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!!
ManishSolanki 15,085 Super User 2025 Season 1 on 11 Dec 2023 at 11:12:16

Like (0)

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

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