Numerical entry from Form causes condition to be ignored

[maquinn1978]

We have a form, one question on it. After taking a self-assessment on another website, user comes to form, enters a score between 0-100.

The goal is to send one of three emails to the user depending on the score. I have a flow that has three ranges set up:

- Less than or equal to 37

- Greater than or equal to 38 AND Less than or equal to 59

- Greater than or equal to 60 AND Less than or equal to 100

Under each condition, the Yes is to send an email, the No is the move on to check the next condition, until the end where the No is empty. Do nothing if it doesn't fit in any of these ranges.

It all works great, until I enter a three digit number. Then, the first condition of less than or equal to 37 comes back as true. I enter 200, the first condition comes in as true. Does any one have any idea why this would happen? I'm ready to throw my laptop. 😄

[VJR]

Hi @maquinn1978 

Could you check if the datatype of the entered number and the one in the condition i;e 37 are of the same type.

Also check if converting both to int() works out in this case.

-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

[maquinn1978]

I'm making sure to put " " around the numbers to change them from string to int. If I don't do that, the flow fails right away before even running. So I am fairly confident that it's look at the number properly. Especially since if I keep the form number under 100 it works fine.

[VJR]

Hi @maquinn1978 

I'm making sure to put " " around the numbers to change them from string to int.

Adding a " " will make it a string and NOT change them from string to int.

You might want to do a numerical comparison instead of a string comparison.

If you could share some screenshots of what the datatypes are, how is the comparison made, etc that would quickly help to resolve the problem.

-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

[maquinn1978]

@VJR here it is before I make any changes.

[VJR · Accepted solution]

Hello @maquinn1978 

In the "Condition" check by converting the input coming from the Forms to int()

This is the expression

Replace the bold part with your input coming from the Forms.

int(triggerBody()['text'])

[maquinn1978]

Hey @VJR , I'm getting an error. 

First, this is my expression. I'm clicking on int() from the expression list and then the field I want from the dynamic value list to build it.

int(outputs('Get_response_details')?['body/r84482f06e1ad4edebcaa7adbb394a1ec'])

 

Then I'm getting this error:

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

[VJR]

Hi @maquinn1978 

It is saying that a comparison is made between an integer and a string.

This -> int(outputs('Get_response_details')?['body/r84482f06e1ad4edebcaa7adbb394a1ec'])  is an integer which is correct.

Are you using " " around the 37. 

If so please remove them and just write 37 without any spaces or anything else.

If still facing issues please do share some detailed level screenshots.

Thanks.

[maquinn1978]

@VJR thank you so much. That fixed it. I really appreciate your help on this.