cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Newb filtering issue

I'm picking back up with PA after not using it for a year.  Now I'm struggling with even the most basic functions.

 

All I want to do is filter the gallery to only show Active clients.  The SharePoint list name is Clients & the boolean field name is AndyTestYN.  Simple enough. 

 

I used Filter(Clients, AndyTestYN=true)

 

In my list, I have 3 records marked yes, 2 marked no and over a dozen that are blank.  No matter what I try, the results only show  the 2 false records.  There are no spaces in the list or column names.  I verified the field was boolean.  I've tried using [@Clients], 'Clients', 'AndyTestYN' and a bunch of other ideas, but nothing works.  Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Since you just want the Yes back try this: Filter(Clients, AndyTestYN)

If you are looking false you could use Filter(Clients, !AndyTestYN) but you'll get a delegation warning.


The SharePoint Yes/No column type doesn't always play well in Power Apps, particularly comparison formulas. If this is a new app I would recommend that you use a Yes/No choice column in SharePoint. It will make you life easier for you in Power Apps.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Super User
Super User

Since you just want the Yes back try this: Filter(Clients, AndyTestYN)

If you are looking false you could use Filter(Clients, !AndyTestYN) but you'll get a delegation warning.


The SharePoint Yes/No column type doesn't always play well in Power Apps, particularly comparison formulas. If this is a new app I would recommend that you use a Yes/No choice column in SharePoint. It will make you life easier for you in Power Apps.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (37,400)