Unanswered

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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

DeepakS 2,301 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @RobJ2 ,

Please try to refer to the following configuration:

Best Regards,

Was this reply helpful? Yes No
RobJ2 7 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

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,

Was this reply helpful? Yes No