Unanswered

IF function not recognizing value

(1) Share

Report

Posted on by 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?

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @calter

You need to change the below using the expression

See below

Was this reply helpful? Yes No
calter 21 on at

Like (1)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
calter 21 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @calter ,

Please share the whole run history screenshots.

Best Regards,

Wearsky

Was this reply helpful? Yes No
calter 21 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

Can you show the raw input?

Was this reply helpful? Yes No
calter 21 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
calter 21 on at

Like (1)

Report

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

Was this reply helpful? Yes No