Logic condition always returns FALSE!

[WebPortal]

This is my Excel table:

This is the Flow:

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

WHY????

[abm]

Hi @WebPortal 

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

[WebPortal]

@abm 

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

[abm]

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

[tom_riha]

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

[WebPortal]

@tom_riha 

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

[WebPortal]

@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

[Paulie78 · Accepted solution]

Because it gets converted to json. Use

string(1)

in the right side of the comparison

 

[abm]

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.

My test result

[WebPortal]

@Paulie78 

You're kidding me 😁😂!

This is crazy... anyway, it worked!

[WebPortal]

🙂

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!

[WebPortal]

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

Thank you for your help!

[marckcit]

I came across this trying to find answers. One of my logic apps returns false no matter what I've tried. I was so desperate I set the condition to AND 1 is equal to 1 and the condition still returned false. I deleted the entire block it was in and recreated it and the condition still returns false no matter what I try. The conditions on my other logic apps seem to be fine.

The main problem I'm having is that a function returns a boolean, so I'm checking if the body is equal to true. Sometimes the body is a json result (random, but appears to be dependent on time it takes the function to run), so I parse that and read the "output" of the json result and check if that is 'true'. Nothing works. The conditions are always false. Conversely, if I check "is not equal to" it's always true.

I have tried using string() on both sides of the expression, I've tried equating the result to 'true' using string() and not. As I said, I tried 1 is equal to 1, which returned false.

The original expression is below: