cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
calter
Regular Visitor

IF function not recognizing value

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? 

 

calter_0-1649360063170.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

10 REPLIES 10
abm
Super User
Super User

Hi @calter 

 

You need to change the below using the expression

image.png

 

See below

 

image.png

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
calter
Regular Visitor

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

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
calter
Regular Visitor

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
Community Support
Community Support

Hi @calter ,

 

Please share the whole run history screenshots.

 

Best Regards,

Wearsky

Run history:

calter_0-1649769739796.png

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

Can you show the raw input?

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

 

calter_0-1649771756529.png

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
calter
Regular Visitor

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

 

calter_0-1649778392341.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,710)