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
beebul
Advocate III

@LanceDelano  WooHoo good news! 🚂=========

objectivelyLost
Helper I

@LanceDelano 

 

Is this going to break any apps using the former 1/0 in place of true/false workaround?

 

 

eliotcole
Power Participant

This still appears to be an issue.

 

eq 1 isn't working, should we be using TRUE, now?

max81
Kudo Kingpin

Finally! Last week it was still not working, now it seems to be fixed for our tenant:

'Yes No' is the name of my SharePoint column.

I tested these expressions in my formula:

 

  • 'Yes No' = 0 --> delegable! With warning, that Boolean and Numbers can't be compared
  • 'Yes No' <> 0 --> not delegable! With warning, that Boolean and Numbers can't be compared
  • 'Yes No' = 1 --> delegable! With warning, that Boolean and Numbers can't be compared
  • 'Yes No' <> 1 --> not delegable! With warning, that Boolean and Numbers can't be compared
  • 'Yes No' = true --> delegable!
  • 'Yes No' <> true --> not delegable and wrong results!
  • 'Yes No' = false --> delegable!
  • 'Yes No' <> false --> not delegable
JR-BejeweledOne
Super User

@max81 Try filtering it with a second filter option.

 

I can filter my list by = true/false but as soon as I add a second filter criteria it doesn't return anything at all even though the second filter option works by itself and in conjunction with other filter criteria