The function was invoked with values of type 'Null' and 'String' that do not match.'.

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I am trying to compare my date with todays date. but I am getting the error :

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.'.

update item if successful -

how can i fix this?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

David_MA 14,312 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Conditions require the date to be formatted in ISO 8601 format. You can use this expression to convert the current UTC time to this format:

formatDateTime(utcNow(), 'yyyy-MM-dd')

The error also indicates your date field is null, so you may need to add an additional condition where the field is not empty.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@David_MA

im trying both

formatDateTime(utcNow(), 'yyyy-MM-dd') formatDateTime('ConclusionDate', 'yyyy-MM-dd')
and my list format is this -

my error is -

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string 'ConclusionDate' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @wonka1234,

There is no need to format ConclusionDate.

I think you should configure your condition as below:

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft getting error on a true result -

InvalidTemplate. 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.'.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @wonka1234,

Do you have null value in this date field?

If so, you need to modify your expression as below:

if(equals(item()?['ConclusionDate'],null),'N/A',item()?['ConclusionDate'])

Note that this expression should be on the left part of the condition to replace with the previous ConclusionDate dynamic content.

Was this reply helpful? Yes No