'Condition' at line '1' and column '15188'

(0) Share

Report

Posted on by Jonathan-101

230

Hello,

I have a flow that I am trying to capture data from a column date. I have the flow already set up for another date column that works fine. I have tried to duplicate the flow and change the relevant column to capture the data and receive the following error.

'Condition' at line '1' and column '15188': 'The template language function 'lessOrEquals' expects two parameter of matching types.

I am using Condition - colum date + is less or equal to + addDays(utcNow(), 30, 'yyyy-MM-dd')

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Jonathan-101

I suggest that you add a compose data operation and pass the column to it and then run the flow and observe the value may be you can get an idea of what is happening.

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report

Hello,

I am fairly new to Power Automate - how do I do this?

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report

I receive the following:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '15179': '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.'

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Jonathan-101

Click on Add Action and Type Compose and then pass the column value to the Compose, Rerun your flow and open the flow run from History.

Please as well paste a screen shot of your flow

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report

Please see attached

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
It is telling you that you are trying to compare "null" to a string. I guess the null is on the left side of your condition "Appraisa..." and the right side is your date. You have a record that has nothing in the "Appraisa..." column and that is causing the condition to crash. You need to either:

Use a condition to check if the record is null and skip the checking completely.

Use an expression on the left side of the condition to output a date string if the column value is null so that the condition will still operate.

Does that make sense?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Jonathan-101

IInside ur Apply_to_each and before ur condition please add the compose data operation, most probable this column will be empty

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report

Hello,

thank you - yes I understand but how do I add the condition in your point 2 above? there are items in the column that are blank

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report

I have tried to add a ne null within the get properties - but a fault occurs

Was this reply helpful? Yes No