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!