You’re offline. This is a read only version of the page.
Hi,
I am trying to compare my date with todays date. but I am getting the error :
Share
ReportUnable 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?
HI @wonka1234,
Do you have null value in this date field?
If so, you need to modify your expression as below:
All responses (
Answers ( 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.
@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.'.
Hi @wonka1234,
There is no need to format ConclusionDate.
I think you should configure your condition as below:
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.'.
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.
#1
WarrenBelz
146,731
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,075
Most Valuable Professional
