Answered

Send annual reminder to review list item

(0) Share

Report

Posted on by 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?

All responses (4)

Answers (1)

v-bacao-msft on at

Like (1)

Report

Re: Send annual reminder to review list item

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,
RobJ2 7 on at

Like (0)

Report

Re: Send annual reminder to review list item

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 (?)
Verified answer

v-bacao-msft on at

Like (1)

Report

Re: Send annual reminder to review list item

Hi @RobJ2 ,

Please try to refer to the following configuration:

Best Regards,
DeepakS 2,301 Most Valuable Professional on at

Like (1)

Report

Re: Send annual reminder to review list item

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