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
Kudo Kingpin

Annoying that this bug still persists! I'm switching to a numeric column where applicable!

@Emma @GregLi @LanceDelano 

Frequent Visitor

Today, filtering a gallery with true/false on a yes/no column still does not work.

 

If you want to get rid of the delegation warning, replace yes/no with number columns.

 

I did what was suggested before and use number columns instead. 1 for true, 0 for false. It's delegatable too. Takes a little work to redo all my yes/no columns, but i don't see this being fixed any time soon.

Advocate I

Has something changed?  I took the filter out and returned all values.  In PowerApps some of them display as, "false", some as, "true", even though in SharePoint they display as, "Yes", or, "No".  So they are being treated as quasi Boolean.  But I still can't filter them by comparing them to the value of a Yes/No toggle on the App screen so maybe no different

New Member

Any updates on this? Been a couple years now! FYI just using the value works too. (ie) You have a boolean Yes/No SP field called Active in an Employee llist. You can Filter like: Filter(Employee, Active). That has been working for me and no delegation issues.

Regular Visitor

Yes, great some workarounds work but please just fix!

New Member

I tested Yes/No = false, not work.

Yes/No <> true, worked, and worked for both empty and false value.