"InvalidTemplate" error on "LessOrEqual" Condition

[Anonymous]

A stage of one of my flows is a "LessOrEqual" Condition which compares the value in a field on a D365 record with a fixed value (.30). The flow runs properly, but fails at the Condition, with the following feedback:

• Code
  InvalidTemplate
• Message
  Unable to process template language expressions for action 'Condition' at line '1' and column '1976': 'The template language function 'lessOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Float' and 'String' that do not match.'.

 I have tried using both decimal and floating point fields as the source field on CRM, but the same error occurs.

Has anyone else seen/experienced this? Is it possible that the LessOrEqual Condition doesn't accept using decimals? Thank you for your time.

Kind Regards,

Matthew

[v-micsh-msft]

Hi MGibson,

The error message shows that the data type of the two values used by "LessOrEqual" do not match.

Coud you please share more information regarding those two values? 

If sharing a screenshot is convenient, then I could do some tests from my side and offer a more suitable suggestion.

We could use some function to convert the data type, for example:

If we would like to convert "10.23" from string to float, we could input the following:

"@float("10.23")"

For more function reference, please check:

Workflow Definition Language

Hope the information above is helpful.

Regards

[Anonymous]

Thank you for your reply - the following values have been compared to ".3" and failed: 0, 0.01, 0.08, 0.24, 1.00

Could I combine the float conversion definiton and the current definition in the advanced editor? So:

@lessOrEquals(body('Update_a_record')?['new_sentimentdecimal'], '.3')

and

"@float("10.23")"

Would this work, for example?

"@lessOrEquals(body('Update_a_record')?"float(['new_sentimentdecimal'])", '.3')

[v-micsh-msft]

Hi MGibson,

What is your current situation?

Well this is hard for me to say whether it would work, as I don't know the actual data type of your data input.

Would you please share a screeshot here, better with description of the input values under the lessOrEquals condition?

Regards

[Anonymous]

I have done some more testing, and I believe the source data is not the cause of the issue (these being either decimal or floating point number fields from Dynamics 365).

If I set the condition in Flow as "If (source data) is less than 1", the flow will actually run as expected. This problem only occurs if a value between 0 and 1 is used to compare the source data to. For example:

This flow will run:

This one will not:

I hope this clarifies the issue. Thank you again for your support on this.

[v-micsh-msft]

Hi @Anonymous,

Thanks for the detailed update.

I just tested the ".5" value with SharePoint source, and it works.

 In addition, try to change he formula under advanced editor with the format below:

@lessOrEquals(float( body('Update_a_record')?['new_sentimentdecimal'] ), '.3')

Regards