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

[Jonathan-101]

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

[Mira_Ghaly]

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

[Jonathan-101]

Hello,

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

[Jonathan-101]

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

[Mira_Ghaly]

@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

[Jonathan-101]

Please see attached

[Paulie78]

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:

1. Use a condition to check if the record is null and skip the checking completely.
2. 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?

[Mira_Ghaly]

@Jonathan-101

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

[Jonathan-101]

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

[Jonathan-101]

[Jonathan-101]

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

[Paulie78]

Try: 

Apraisaldate ne ''

[Jonathan-101 · Accepted solution]

Its okay, ive located that the Appraisal page was not correct - Thank you! all working yipeeee