cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skylitedave
Kudo Kingpin
Kudo Kingpin

BUG - YESNO SharePoint Filtering

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

 

   This works

        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

 

https://powerusers.microsoft.com/t5/Connecting-to-Data/Possible-bug-filtering-SharePoint-list-by-yes...

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

In addition, while not ideal

Filter(FormText, Yes_x002f_NO <> false)

seems to work.

View solution in original post

7 REPLIES 7
v-micsh-msft
Community Support
Community Support

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.

Filter(FormText, Yes_x002f_NO=1)

Or:

Filter(FormText, Yes_x002f_NO="1")

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

In addition, while not ideal

Filter(FormText, Yes_x002f_NO <> false)

seems to work.

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 ...

Hi,

 

An update: 

 

Please try the following command when working with the Yes/No Field true value:

Filter(FormText, Yes_x002f_NO=1)

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.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

Anonymous
Not applicable

skylitedave

The blue "i" will not be visible to users using the app - it only shows for the developers while building the app to highlight that the syntax is not ideal.

If I take your suggestion, will I have to update my filter when the fix is made?

 

Thx

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,460)