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 (1)

All responses (20)

Answers (0)

BlueCar 52 on at

Like (1)

Report

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 on at

Like (2)

Report

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

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

Was this reply helpful? Yes No
myrful 5 on at

Like (1)

Report

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

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

/

Was this reply helpful? Yes No
webbrewer 338 on at

Like (12)

Report

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

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

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

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

Was this reply helpful? Yes No