Logic condition always returns FALSE!

(0) Share

Report

Posted on by WebPortal

2,295

This is my Excel table:

This is the Flow:

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

WHY????

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @WebPortal

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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

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

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

Like (1)

Report

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

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

@tom_riha

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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (3)

Report
Because it gets converted to json. Use
string(1)
in the right side of the comparison

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

Like (1)

Report

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

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report

@Paulie78
You're kidding me 😁😂!
This is crazy... anyway, it worked!

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (0)

Report
🙂

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!

Was this reply helpful? Yes No