Hi,
i'm struggling real hard, dunno why, to make a flow work.
The flow shoots as soon there's a new item in a sharepoint list. I have 3 number columns from which i set a condition in an automated flow.
| Price | Discount | Percentage |
| 10000 | 500 | 5 |
The flow has to go on yes or no from a condition that is :
If Percentage is less or equal than 10 => go to Yes.
if Percentage is not => go to No.
I tried with the column percentage being a calculated values column, or a simple number column.
Power Automate doesnt like any configuration :
When the Percentage column is a number, the error says :
"The template language function "lessOrEquals" requires all of its parameters to be integers or decimal numbers. Invalid parameter types were found: 'Null'."
When it's a calculated value column, it says :
"The template language function "lessOrEquals" requires two parameters of matching types. The function was called with values of types "String" and "Float" that do not match."
What the heck ?
If there's a solution i'd rather use the calculated value Percentage column rather the "number" one, because it's automatic, that calculated one is made of the formula =[Discount]/[Price]
