Having an issue with a Null function

[dbrueggen]

I'm building a workflow that would check a date to help forecast expirations and email the user, however, the data fields may not be populated as not every user has to have every credential. I created an AND/OR tree in the condition to check each column of data, where if any of the conditions are true it emails a user.

However, I'm consistently getting the following error:

I'm including a Null function specifically to avoid this type of error and so the flow wouldn't think that a blank was less than today's date plus a certain number of days. I'm really stumped here.

[v-qiaqi-msft]

Hi @dbrueggen,

What is your data source?

I think you could directly convert the null value into a string or you could replace the null value with another value:

if(equals(<VALUE TO TEST>,null),'Value if null','value if not null')