Unanswered

"InvalidTemplate" error on "LessOrEqual" Condition

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No