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')
Solved! Go to Solution.
Its okay, ive located that the Appraisal page was not correct - Thank you! all working yipeeee
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.
Hello,
I am fairly new to Power Automate - how do I do this?
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.'
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
Please see attached
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:
Does that make sense?
IInside ur Apply_to_each and before ur condition please add the compose data operation, most probable this column will be empty
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
I have tried to add a ne null within the get properties - but a fault occurs
Try:
Apraisaldate ne ''
Its okay, ive located that the Appraisal page was not correct - Thank you! all working yipeeee
User | Count |
---|---|
95 | |
46 | |
21 | |
18 | |
17 |
User | Count |
---|---|
141 | |
50 | |
43 | |
40 | |
29 |