Unanswered

Condition not working correctly

(1) Share

Report

Posted on by pakalolo13

I have a condition that is sending out an email notification well, even though the flow is failing each time. This flow has worked for what is needed but now that one of the conditions has changed, I expected it to no longer be sending the email for an overdue list item. I get the error below:

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

My condition is as follows:

I have three list items that are now "Complete"(this condition is not working), the due date is past (this condition is working).

I just recently added the third condition line to try and avoid it failing for list items that have an empty due date column.

The run screen shows that the flow evaluates all 48 lines in the list but fails and says no further actions succeeded although the emails do get sent for the three items with due dates before todays date. Those three list items are now marked as complete and I was expecting the condition to not be met so therefore no email sent out.

Any help on what I am missing here.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

Based on the error message, you need to change null in the third condition to true. When you use an empty expression on a value, it returns true or false. Be sure to use the expression builder to enter true.

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I think there is something wrong in the dynamic content which you have selected, if the status field is a choice type field in sharepoint list, then dynamic content should have name as Status Value , while Status would be having complete json structure of choice value from which value is needed where Status Value would have the value.

Coming to due date validation, order matter in condition checking, you should have put the condition whether due date is empty first and then have used due date<utcnow() condition, by which if due date is not empty- it should have proceeded to 3rd condition.

Also the expression for checking whether the due date is empty or not is like below

equals(items('Apply_to_each')?['DueDate'],null) (Leftside of condition) = false (Right side of condition)

Hope it helps !

Mark it as solution if it resolves your query !

Thanks & Regards,

Nived N

Was this reply helpful? Yes No
pakalolo13 66 on at

Like (0)

Report

Thanks Nived! This work perfectly. I was not aware that the conditions were being evaluated in order and also the status value was all that was missing for that condition!

Thanks again!

Was this reply helpful? Yes No