Send annual reminder to review list item

[RobJ2]

Hi all, I'm new to flow and I'm trying to set-up one that will email a named owner of a list item to review the item based on the date they entered as last signed off "date completed/last updated" column.

So far I have the following - where the condition is:

formatDateTime(addDays(utcnow(),-365),'dd-MM-yyyy')

The email goes but I get the error "Unable to process template language expressions for action 'Condition' at line '1' and column '2842': '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"

Help please?

[DeepakS]

Hi @RobJ2 

The error that you getting is because of date column may be empty, so you should check if is is empty before comparing it .

Also i would prefer following format:

formatDateTime(addDays(utcnow(),-365),'yyyy-MM-dd')

Regards,

DS

[v-bacao-msft · Accepted solution]

Hi @RobJ2 ,

Please try to refer to the following configuration:

Best Regards,

[RobJ2]

Thanks Barry - the flow now runs successfully and sends the email for those requiring review 🙂

However, if I drill in to the flow checker there is still an error (?)

[v-bacao-msft]

Hi @RobJ2 ,

This is the expected result, indicating that the current item does not meet the conditions set in this condition, so the result is false. Then the action in the If yes branch will not be executed.

Best Regards,