cancel
Showing results for 
Search instead for 
Did you mean: 

Properly filter SharePoint Yes/No column.

There is a well known "bug" when working with SharePoint list Yes/No column :

The Yes/No value can not be compare to boolean type true/false. 

 

Filter(SPList,YesNoColumn = true) will not return all the items with a Yes value .

 

The workaround is to use 1 or 0:

Filter(SPList,YesNoColumn = 1)

This will return all items with a true value, but the designer shows an error because we are comparing a boolean to a number. 

 

It would be great to fixe that, as a Yes/No column is indeed a boolean value, we need to be able to compare that to a boolean value in PowerApps. 

 

Théo

Status: New

Apologies resetting this status. Adding @GregLi and @Emma to update with accurate status. Both TopShelf ad Audrie-MSFT are not longer able to provide an update for Power Apps ideas. @GregLi & @Emma please provide inputs and/or comments. Thank you.

Comments
Frequent Visitor

@TopShelf-MSFT and @Audrie-MSFT, can you really please address this issue? I cannot believe after 2 years you just send this to eachother and do not react on this one anymore...

Power Automate
Status changed to: New

Apologies resetting this status. Adding @GregLi and @Emma to update with accurate status. Both TopShelf ad Audrie-MSFT are not longer able to provide an update for Power Apps ideas. @GregLi & @Emma please provide inputs and/or comments. Thank you.

Power Apps

Adding @LanceDelano too.

Regular Visitor

Just got caught by the "YesNo <> false" non-delegatable issue. Two years after this item was first created 😞

Frequent Visitor

@GregLi  & @Emma any updates on this one?

Regular Visitor

I'm developing an important app for a government department (who pay large license fees).
To find that such basic functionality simply does NOT work and has been broken for over a year is unbelievable.
I have been in this profession for over 20 years and appreciate that issues such as this can be very complex to solve. However this completely unacceptable.
The Power Apps team need to get their act together!

Frequent Visitor

@GregLi  & @Emma any updates on this one?

 

Just to remind you, we are 1.5 year away from the original bug, people are paying their licenses, so please address this issue...

Regular Visitor

I also ran into this bug today where my filter using SharePoint yes/no column as a boolean property does not work. And now I find out that this has been a known bug for years. Lost for words 😤

Frequent Visitor

@GregLi  & @Emma ,@LanceDelano any updates on this one?

Resolver I

Hi!

 

I need this solution as well.

 

Could you please give us an update over this issue.

 

Thanks.