Date Field Condition Error

[Sam12]

I am current building a scheduled Flow which archives items from a SharePoint list based on some logic that I have been sent across 7 different content types.

The logic is very similar across each of the content types so I will use this one as an example:

Content Type = CA-MandatoryEvent

If "Event Completed" = Yes AND "Client Account Updated" is more than one year old

OR

If "Cancelled" = Yes AND "Modified" is more than one year old

I have built this, and whilst in theory it work, I am getting the below error message on some items:

InvalidTemplate. Unable to process template language expressions for action 'Condition_3' at line '1' and column '2805': 'The template language function 'lessOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

Upon further invesigation, it appears some of the items are blank for the Client Account Updated field. Where this is the case, we just want to ignore them. My only suggestion is to add a step in the Flow to populate the Client Account Updated field with a date unrealistcially in the future so that this condition won't be met, which obviously isn't the ideal solution. Does anyone have any other suggestions please?

The below is what I have so far:

[v-bacao-msft · Accepted solution]

Hi @Sam12 ,

If the Client Account update is null, the condition control will fail.

Please try to add a condition above CA-MandatoryEvent and check if Client Account Update field is null.

Image reference:

Hope this helps.

Best Regards,

[Sam12]

Thanks @v-bacao-msft - does the below look correct to you based on this logic assuming we have a lot of items where Client Account Updated is null?

If "Event Completed" = Yes AND "Client Account Updated" is more than one year old

OR

If "Cancelled" = Yes AND "Modified" is more than one year old

[v-bacao-msft]

Hi @Sam12 ,

You are right!

Best Regards,