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.
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.
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
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?
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
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!