Warning when date approaches, skipping empty cells

[Anonymous]

Hi,

I have a flow working based on sharepoint list that warns me when a date approuches. It works fine but it fails when a cell is empty. Any idea how I can skip the empty cells? 

@lessOrEquals(items('Apply_to_each')?['Contract_x0020_end_x0020_date'], adddays(utcnow(), 30))

[AlanPs1]

I would tend to use something like this: 

@not(empty(  ** Nest in here **  ))

You'll need to use it relevant to your Flow but I have have succeeded with this as it basically means, Return true if not empty.

[v-bacao-msft · Accepted solution]

Hi @Anonymous,

Do you mean skipping the item with a null value in the date field?

You could try to use Filter array to filter the date field containing the value of the item, and then use Filter array- output value to configure the following steps, which is to replace the output of the original Get items with the output of the Filter array.

Image reference:

Take a try.

Best Regards,

Barry