cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
skylitedave
Level 10

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
DanielaH
Level 8

Re: BUG - YESNO SharePoint Filtering

In addition, while not ideal

Filter(FormText, Yes_x002f_NO <> false)

seems to work.

View solution in original post

7 REPLIES 7
Community Support Team
Community Support Team

Re: BUG - YESNO SharePoint Filtering

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.
DanielaH
Level 8

Re: BUG - YESNO SharePoint Filtering

In addition, while not ideal

Filter(FormText, Yes_x002f_NO <> false)

seems to work.

View solution in original post

skylitedave
Level 10

Re: BUG - YESNO SharePoint Filtering

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

Community Support Team
Community Support Team

Re: BUG - YESNO SharePoint Filtering

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.
skylitedave
Level 10

Re: BUG - YESNO SharePoint Filtering

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!

DanielaH
Level 8

Re: BUG - YESNO SharePoint Filtering

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.

skylitedave
Level 10

Re: BUG - YESNO SharePoint Filtering

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

 

Thx

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,756)