cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

Logic condition always returns FALSE!

This is my Excel table:

 

WebPortal_0-1603825392154.png

 

This is the Flow:

WebPortal_1-1603825414897.png

 

When I test it, the logic test of the condition always returns "FALSE":

 

WebPortal_2-1603825473603.png

 

WHY????

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Because it gets converted to json. Use

string(1)

in the right side of the comparison

StringNumber.PNG 

View solution in original post

11 REPLIES 11
Highlighted
Super User III
Super User III

Hi @WebPortal 

 

Try to convert the excel value to integer using int() expression.

 

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
Highlighted

@abm 

Sure, what you're proposing is exactly the same what I'm doing.

Highlighted

Hi @WebPortal 

 

I couldn't see that in the screenshot you provided? You are not converting to integer. Are you saying that you tried to convert to integer and its 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
Highlighted
Solution Sage
Solution Sage

Or try to convert the 1 into string, instead of 1 put there '1'.

Highlighted

@tom_riha 

 

I did (although I have no clue why), but I still get always false.

Highlighted

@abm 

 

The column "Numero" is an integer in Excel.

 

In Power Automate I'm getting that column for the 1st part of the condition, how (and why) am I supposed to FORCE IT AGAIN an integer?

 

Thanks

Highlighted

Because it gets converted to json. Use

string(1)

in the right side of the comparison

StringNumber.PNG 

View solution in original post

Highlighted
Super User III
Super User III

Hi 

 

I have tested this now. If you convert to int() it should work as expected. Below the expression I used is

 

int(items('Apply_to_each')?['Taken Days'])
 
Here Taken Days is my excel numeric column.

 

image.png

 

 

My test result

 

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
Highlighted

@Paulie78 

You're kidding me 😁😂!

This is crazy... anyway, it worked!

Highlighted

🙂

 

Thanks, this is too bizarre to me..

 

SELECT * FROM 

WHERE this == that

 

Has been invented some 40 years ago, and it always worked!

 

Anyway, I'm trying the zen mode and to learn something new, thank you so much!

Highlighted

@abm your solution also works, athough is more complicated.

Thank you for your help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (13,420)