If you try and Filter on a YesNo field in SharePoint, you can filter using false but trying to filter using true does nothing and no error is thrown
Example - Suppose you have a YesNo field called "TestYesNo" in SharePoint
Filter(List, YesNoField = false)
This does nothing
Filter (List, YesNoField = true)
This bug was first reported 11/7/2016... Please fix.....See here
For some reason the post referenced below is Solved .. It is not... This is a wicked bug
Solved! Go to Solution.
Thanks for rise this one up.
I will send the feedback and update you with the response I received.
For a workaround, please try to use 0/1 to filter with the YES/NO field temporarily.
You are right... that works...
The downside is delegation is NOT supported on yes/no fields so storing the "Yes" or "No" in a seperate text field in SharePoint and throwing an index on that new field. Filtering on this text field will let the powerapp scale though delegation...
Supporting delegation on yes no fields in SharePoint is needed .... they are pretty common in forms ...
Please try the following command when working with the Yes/No Field true value:
Which works without delegation problems. But it will remind you a type mismatch warning.
And there is an instance opened internally for tracking this issue.
It works but as you said throws the blue "i".
We cant have that since all users will email us daily about the blue "i" on all the screens.
We will have to store Yes or No in a text field and use that to filter until this gets fixed in PowerApps
Thx ... looking forward to the fix!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.