how to check if the date column in Excel is blank

[jeanwang]

Hi,

I have createda project plan and a Flow to send a reminder if a certain step is overdue.

My project plan is an Excel saved on sharepoint, if the column "First Draft Completion Date" is blank, that means the step is not completed. I want to create a condition which says

condition1" "First Draft Completion Date" is blank, then go to condition 2

    condition 2" if "First Date Completion Deadline" is less than utcnow(), then send a email reminder

However, despite the column "First Draft Completion Date" is blank, the first condition output is always false . Can someone help?

Thanks!

[abm]

Hi @jeanwang 

For checking Condition1" "First Draft Completion Date" is blank  you need to use the expression function null. Remove the zero and add the null from the expression function.

[v-bacao-msft · Accepted solution]

Hi @jeanwang ,

You could remove 0 and set the parameter to the right of the condition to blank.

Please take a try.

Best Regards,

[jeanwang]

Thank you, abm!

However, I had tried changing zero into null. That didn't work either. I think it's because I have done conditional formatting with that column.

[abm]

Hi @jeanwang 

Try to use the expression length and check zero. If not try @v-bacao-msft  suggestion.

[Jan357]

Except data put function 

empty(items('Apply_to_each')?['Date'])

then 'is equal' leave without change

to last cell put 'true'