IF function not recognizing value

[calter]

I am trying to create an if function in power automate where it will send an e-mail notification if the value in a certain column is equal to or lesser than a specific value. But it is currently sending the e-mail notification even if the value is larger than the set value...how do I make it read this correctly? 

[abm]

Hi @calter 

You need to change the below using the expression

See below

[calter]

yeah...did that and the flow still sends the e-mail even if the entry was a 4 or 5 (not 3 or less)....

[abm]

Hi @calter 

Since you are dealing with numeric comparison better to convert the IF condition left and right side values to int() expression instead of string(). Try and let me know.

Thanks

[calter]

changed that too...unfortunately it is still sending all e-mails, even though the answers are above the numbers in the condition... 

[v-xiaochen-msft]

Hi @calter ,

Please share the whole run history screenshots.

Best Regards,

Wearsky

[calter]

Run history:

The entry for crew competency in this particular spot (double checked in the list) was 4, yet the expression came back as true! 

[okeks]

Can you show the raw input?

[calter]

This is shown when I click on "show raw inputs" in the run history

[abm · Accepted solution]

Hi @calter 

Thanks for the share. So the reason was you set the int() expression under the expression. It was set as plain text earlier hence it was not working.

Thanks

[calter]

Thank you so very much for your help! This is what we changed the IF function in the flow to look like: