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.
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.
@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...
Adding @LanceDelano too.
Just got caught by the "YesNo <> false" non-delegatable issue. Two years after this item was first created 😞
@GregLi & @Emma any updates on this one?
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!
Just to remind you, we are 1.5 year away from the original bug, people are paying their licenses, so please address this issue...
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 😤
@GregLi & @Emma ,@LanceDelano any updates on this one?
I need this solution as well.
Could you please give us an update over this issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.