Unanswered

Flow with a checking condition a true/false value which always returns false

(5) Share

Report

Posted on by Preetish

I have a requirement on Microsoft Flow. Depending upon my requirement, I have a SharePoint List and in that list, I have one Yes/No field column.

When I am trying to put this Yes/No field Column in flow Condition is equal to true/false or 0/1, Always the condition returns as "no" even if it is true. How can I resolve this issue?

Below is the flow screenshot:

flow error.png

Categories:

General topics

I have the same question (2)

All responses (21)

Answers (0)

BlueCar 52 on at

Like (1)

Report
Copy link

Link copied!

I don't know if it's related, but I have a flow I'm working on, and last week, my conditions where working perfectly, but now they seem to return false (no) and I can't figure out why. At this moment I'm still trying to figure out what's wrong.
This should return true, if the three fields are cleared, but it always returns false, even if they are cleared.

I can get it to return true (yes), if I change "is equal to" to "is not equal to".
As I said, this was working last week.

1 people found this reply helpful.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @Preetish ,

Could you provide more details about the field you mentioned?

Do you have any special treatment for it?

Basically the return value of Yes/No field is true and false.

I did a test on my side. If Yes is selected in the field, the result of Condition judgment will be true.

Image reference:

You could try adding a Compose action on Condition to output the return value of the current field to see if this field selects Yes or No.

Please take a try and see if issue still exists.

If the problem persists, please provide Flow run history, including the results of Compose output so that we can analyze the problem.

Best Regards,

Was this reply helpful? Yes No
Ruokiri 11 on at

Like (1)

Report
Copy link

Link copied!

I got the same problem. Adding "compose" fixed it 🙂

Was this reply helpful? Yes No
myrful 5 on at

Like (1)

Report
Copy link

Link copied!

I have the same issue. I tried adding compose to the condition, which returns the Yes/True as it should, but it still prompts false.
@v-bacao-msft

Was this reply helpful? Yes No
acewmu 8 on at

Like (2)

Report
Copy link

Link copied!

This blog helped me. https://www.c-sharpcorner.com/blogs/how-to-check-condition-yesno-column-value-in-flow

Was this reply helpful? Yes No
acewmu 8 on at

Like (0)

Report
Copy link

Link copied!

/

Was this reply helpful? Yes No
webbrewer 338 on at

Like (12)

Report
Copy link

Link copied!

The op's screenshot shows the word "true" being manually added which won't work. Has to be an expression you can look up. Not very intuitive and poorly documented as usual.

2 people found this reply helpful.

Was this reply helpful? Yes No
Joe_Fox 67 on at

Like (7)

Report
Copy link

Link copied!

As the blog post that @acewmu points to, and the screenshot that @webbrewer shows, you have to add the 'true' part via an expression:

One thing to add is that (for me at least) when you type true in the expression input box and click the autocompleted 'true' (in blue text with the little icon next to it on the left as shown in the image above), then click OK, you might get an error saying "The expression is invalid". IGNORE THAT! It's an annoying little bug. Simply click OK to close the error dialog box and then click OK underneath the expression input box and, this time, the "error" will not appear and true will appear in the condition box in a pink box with the 'fx' icon next to it on the left (as shown in the image above)

Was this reply helpful? Yes No
Alphie 48 on at

Like (1)

Report
Copy link

Link copied!

Thought I would add that if you are using "experimental features" I am showing a bug where the true/false/null functions show up as undefined.
Experimental Features enabled:
Experimental Features disabled:

Was this reply helpful? Yes No
LW2016 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this - I could not figure out why I kept getting undefined!

Was this reply helpful? Yes No