Answered

Flow fails on Yes/No column (Big Flow)

(3) Share

Report

Posted on by Community Power Pla...

So I have a big logic flow with a lot of conditions. However it seems that it always fails on Yes/No (boolean) column check. And even if the condition is true it returns No.

Here is the flow:

It should ahve went to Yes under the Is Approved by Supervisor.

At first I thought maybe it was set not correctly so I check at the Output of the SharePoint list and it apears to be checked correctly.

Here is the row from the output:

So it should go to yes but it does not.

Here is how the condition is programmed:

Basic View:

Advanced View:

have you guys run into similar problems with Yes/No columns? Any way to make it work? Really appreciate any help, thanks!

All responses (16)

Answers (1)

toraritte 50 on at

Like (0)

Report

Re: Flow fails on Yes/No column (Big Flow)

Had the same issue with boolean columns in the tables and no found solution worked. What did the trick was simply switching from boolean values to strings with similar meanings (e.g., yes/no) and fields could now be simply matched as strings.
bnerd 110 on at

Like (3)

Report

Re: Flow fails on Yes/No column (Big Flow)

I had a smilar situation in my flow where I was checking the value on a Yes/No list column. Tried with 'Yes', and 'true' values but could not get it to work as intended.

I solved it by simply clicking on Expression and typing true. This way the flow compares it to the actual value, rather than string 'true'.
MMCROB 8 on at

Like (2)

Report

Re: Flow fails on Yes/No column (Big Flow)

Had same issue with a flow I was making, as I was entering [Is Equal to - Yes] and it was failing whether the list item had been set to Yes or No - but came across your post and adjusted my test to true and now works fine.
gunjan 82 on at

Like (0)

Report

Re: Flow fails on Yes/No column (Big Flow)

Can you try bool(body('Create_item')?['Discarded']), true [boolean value], as the output from body('Create_item')?['Discarded'] might be resulting into whole answer coming to be False.
lavint 51 on at

Like (0)

Report

Re: Flow fails on Yes/No column (Big Flow)

Found my solution. Thanks
wackawacka 23 on at

Like (1)

Report

Re: Flow fails on Yes/No column (Big Flow)

@Anonymous you are typing correctly but need to click on Expression first before typing "equals" becuase "equals" is an expression and not a dynamic varible 😉

expression tab you click first that is the outside, inside the expression you put in the varibles so you click on the "dynamic content"

a simple view would be:

expression ( dynamic varible , dynamic varible or expression)
Community Power Pla... on at

Like (0)

Report

Re: Flow fails on Yes/No column (Big Flow)

Conceptually, this is making sense now. Thank you for that. Where I'm stuck is that in the left side, I can't select the SharePoint column 'Notify'. Once I do the open bracket, I only have 2 choices for the SharePoint list and neither is a column.
wackawacka 23 on at

Like (0)

Report

Re: Flow fails on Yes/No column (Big Flow)

to get around this. In the left side of the condition click on it. It would popup the dynamic content tab. click on expression and type "equals". now in the example i gave you need to split it into two:
@equals(equals(body('Create_item')?['Discarded'], 'true'),true)
=
equals(body('Create_item')?['Discarded'], 'true')

so when you type equals with the open and close bracket click inside it and select dynamic content and then select the object, mine is create item, then go back to expression and then type: , 'true'

so in the expression you would see

equals(body('Create_Item'),true)

click the ok button, now you would have the first half (inner half of the condition), for the right side click on the box
and select expression again, this time type true and click ok. This would be the outside bool condition.
so to recap, left side is inner condition, using expression equals we get a bool result and then we compare that result to the right side if its true(outer expression).
Community Power Pla... on at

Like (1)

Report

Re: Flow fails on Yes/No column (Big Flow)

Microsoft removed the "Edit in Advanced Mode". How would you do this with Expressions in the basic editor? The basic editor requires two fields to be populated.
wackawacka 23 on at

Like (0)

Report

Re: Flow fails on Yes/No column (Big Flow)

you need to do the comparison on the left hand side first and then compare if its a true value:

this worked for me:
@equals(equals(body('Get_response_details')?['rbe8bb91d66fb4e03bbad0998c12e9e24'], 'false'), true)

so in your case:

@equals(equals(body('Create_item')?['Discarded'], 'true'),true)

inner equals is checking your create item discarded if its equal to true to get a bool value, then compare that to the outer equals if its true or not.