web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter gallery by chec...
Power Apps
Answered

Filter gallery by checkboxes and search bar

(0) ShareShare
ReportReport
Posted on by teaful 33

I'm new to Power Apps. We are a Non-profit Assistance Dog training facility going paperless. (from 1980's to 2020 at warp speed)

 

I have a gallery with a Sharepoint data source that I want to filter down by checkboxes and by name via search box (in any order the user chooses). Really struggling and can't seem to find any data on the subject, but from what I've read thus far, I will need to create a collection, and then each box checked or search item would re-write the collection?

 

I have checkboxes for Hearing Dog (HD), Home Hearing Dog (HHD), Autism Assistance Dog (AAD) and Facility Dog (FD) and State.

 

I have three separate screens. One for our clients, one for our dogs, and one for our Teams (a dog that's been placed with a client after training has been completed.)

 

Each screen will need a similar filter.  In working with Clients first, I have a gallery (the selected record shows in a form), the checkboxes (not working yet) and the search field (works). I just can't figure out how to make the checkboxes and search field work together. Any help would be appreciated. 

 

Example need: staff can filter by checkboxes HD & HHD in Oregon. The gallery returns a list of results of only HD or HHD clients in only Oregon, of which they can then do a name search by any criteria in the record. Of course clicking on any one result shows the data in the associated form. 

Categories:
Building Power Apps
I have the same question (0)
  • VDS_Mantra Profile Picture
    VDS_Mantra 175 on at

    Hi, 

     

    Use the below one it will help you.

    For checkbox value, you need to pass selected value text in one variable and then use into the filter

    if(Checkbox1.value = true, set(VCheckboxtext,Checkbox1.text),if(Checkbox2.value = true,set(VCheckboxtext,Checkbox1.text),set(VCheckboxtext,""))

     

    Filter(Source Name, VCheckboxtext in DogCategory && inpSearchbox.Text in SentBy)

     

    I would suggest use the Radio button instead of checkbox. 

     

    Kindly change the parameter name as per your data set. 

     

    I hope it will help you. 

  • teaful Profile Picture
    teaful 33 on at

    VDS_Mantra, thank you for providing a solution. I'm afraid I do not know where to put those formulas though. Can you provide more detail?

     

    With radio buttons, you can only choose one. I have the need to choose multiple sometimes. 

  • v-yutliu-msft Profile Picture
    v-yutliu-msft Microsoft Employee on at

    Hi @teaful ,

    Do you want to filter based on 5 check boxes and one textinput?

    Could you tell me:
    1)which column do you want to filter based on by these check boxes? column name and data type?

    2)which column do you want to filter based on by the textinput? column name and data type?

    I assume that you want to filter fieldname1(single choice type) by using these checkboxes,

    filter fieldname1(text type) by using the textinput.

     

    Then please set like this:
    1)checkboxes' Text:

    "Hearing Dog (HD)"
    "Home Hearing Dog (HHD)"
    "Autism Assistance Dog (AAD)"
    "Facility Dog (FD)"
    "State"

    2)the gallery's Items:

    Filter(listname,
If(Checkbox1.Value,"Hearing Dog (HD)"=fieldname1.Value,false)||
If(Checkbox2.Value,"Home Hearing Dog (HHD)"=fieldname1.Value,false)||
If(Checkbox3.Value,"Autism Assistance Dog (AAD)"=fieldname1.Value,false)||
If(Checkbox4.Value,"Facility Dog (FD)"=fieldname1.Value,false)||
If(Checkbox5.Value,"State"=fieldname1.Value,false),
If(IsBlank(TextInput1.Text),true,
 TextInput1.Text in fieldname2)
)

     

     

    Best regards,

  • teaful Profile Picture
    teaful 33 on at

     

     

     

     

     

    Thank you for your expertise.

    clientz.JPG
  • Verified answer
    v-yutliu-msft Profile Picture
    v-yutliu-msft Microsoft Employee on at

    Hi @teaful ,

    Do you want to filter based on some checkboxes and a searchbox?

    Could you tell me  what does "Johnson 97586" represent?  'FirstName'+'Client Number'? I assume that yes.

    Do you mean that all your fields are text type? include 'Client Number' and 'Phone' field? I assume that yes.

    If so, I've made a similar test for your reference:

    //test831 is my listname, please replace that

    1/checkbox1-Checkbox1_6: 

    for these three columns:'Client Type' containing HD, HHD, AAD or FD  (if you do not choose any related checkboxes, you will not filter based on 'Client Type' column)

                                            'Successor' containing yes,no(if you choose related checkbox, you will filter  'Successor' based on "yes" value. if you not choose related checkbox, you will filter  'Successor' based on "no" value.)

                                            'Staff or Ambassador' containing staff,Ambassador (if you do not choose any related checkboxes, you will not filter based on 'Staff or Ambassador' column)

    2/gallery1 for filtered State column(based on checkboxes) with no-repeated value

    set gallery1's Items:

    Distinct(
 If(
 !Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&
 !Checkbox1_5.Value&&!Checkbox1_6.Value,
//not choose checkboxes for 'Client Type' and 'Staff or Ambassador'
 Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no")),
//filter on based on Successor
 !Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&& 
 (Checkbox1_5.Value||Checkbox1_6.Value),
//not choose checkboxes for 'Client Type', choose check box for 'Staff or Ambassador'
 Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no"),
 If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")),
//filter based on 'Staff or Ambassador' and Successor
 (Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)
 &&!Checkbox1_5.Value&&!Checkbox1_6.Value,
//choose checkboxes for 'Client Type', not choose check box for 'Staff or Ambassador'
 Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),
If(Checkbox1_4.Value,Successor="yes",Successor="no")),
filter based on 'Client Type' and Successor
 (Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&& 
 (Checkbox1_5.Value||Checkbox1_6.Value),
//choose checkboxes for 'Client Type' and 'Staff or Ambassador'
 Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),
If(Checkbox1_4.Value,Successor="yes",Successor="no"),
If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")
 )
//filter based on 'Client Type' ,'Staff or Ambassador', Successor
 ),
 State)

    insert checkbox named Checkbox2 in this gallery

    3)gallery2 for filtered 'Waitlisted in Months' column (based on checkboxes) with no-repeated value

    set gallery2's Items:

    Distinct(
 If(
 !Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&
 !Checkbox1_5.Value&&!Checkbox1_6.Value,
//not choose checkboxes for 'Client Type' and 'Staff or Ambassador'
 Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no")),
//filter on based on Successor
 !Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&& 
 (Checkbox1_5.Value||Checkbox1_6.Value),
//not choose checkboxes for 'Client Type', choose check box for 'Staff or Ambassador'
 Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no"),
 If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")),
//filter based on 'Staff or Ambassador' and Successor
 (Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)
 &&!Checkbox1_5.Value&&!Checkbox1_6.Value,
//choose checkboxes for 'Client Type', not choose check box for 'Staff or Ambassador'
 Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),
If(Checkbox1_4.Value,Successor="yes",Successor="no")),
filter based on 'Client Type' and Successor
 (Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&& 
 (Checkbox1_5.Value||Checkbox1_6.Value),
//choose checkboxes for 'Client Type' and 'Staff or Ambassador'
 Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),
If(Checkbox1_4.Value,Successor="yes",Successor="no"),
If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")
 )
//filter based on 'Client Type' ,'Staff or Ambassador', Successor
 ),
 'Waitlisted in Months')

    insert checkbox named Checkbox3 in this gallery

    4)gallery3 to display filter items:

    Filter(
If(!Checkbox2.Value&&!Checkbox3.Value,
If(!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no")),!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador"))),
//not choose gallery1 and gallery2
Checkbox2.Value&&!Checkbox3.Value,
Filter(
If(!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no")),!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador"))),
State in Filter(Gallery1.AllItems,Checkbox2.Value).Result),
//add a filter rule for State
!Checkbox2.Value&&Checkbox3.Value,
Filter(
If(!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no")),!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador"))),
'Waitlisted in Months' in Filter(Gallery2.AllItems,Checkbox3.Value).Result),
//add a filter rule for 'Waitlisted in Months'
Checkbox2.Value&&Checkbox3.Value,
Filter(
If(!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no")),!Checkbox1.Value&&!Checkbox1_1.Value&&!Checkbox1_2.Value&&!Checkbox1_3.Value&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&!Checkbox1_5.Value&&!Checkbox1_6.Value,Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no")),(Checkbox1.Value||Checkbox1_1.Value||Checkbox1_2.Value||Checkbox1_3.Value)&&(Checkbox1_5.Value||Checkbox1_6.Value),Filter(test831,If(Checkbox1.Value,'Client Type'="CHD")||If(Checkbox1_1.Value,'Client Type'="HAD")||If(Checkbox1_2.Value,'Client Type'="FD")||If(Checkbox1_3.Value,'Client Type'="AAD"),If(Checkbox1_4.Value,Successor="yes",Successor="no"),If(Checkbox1_5.Value,'Staff or Ambassador'="Staff")||If(Checkbox1_6.Value,'Staff or Ambassador'="Ambassador"))),
State in Filter(Gallery1.AllItems,Checkbox2.Value).Result
'Waitlisted in Months' in Filter(Gallery2.AllItems,Checkbox3.Value).Result)
//add two filter rules for State and 'Waitlisted in Months'
),
If(IsBlank(TextInput1.Text),true,
'FirstName' in TextInput1.Text||
'LastName' in TextInput1.Text||
'Client Number' in TextInput1.Text||
'Zip' in TextInput1.Text||
'email' in TextInput1.Text||
'Phone' in TextInput1.Text
)
)

     Then you will filter based on 7 checkboxes and 2 galleries.

    8311.PNG

     

    Actually, using checkboxes to filter based on so many fields will be very complex. You need to justify whether it is checked one by one.

    If you use combo boxes , issue will be much simpler.

     

     

     

    Best regards,

  • teaful Profile Picture
    teaful 33 on at

    Phoebe Liu,

     

    Wow, this is complex. Thank you, I will work on understanding this and implementing.

     

    I'm not familiar with combo boxes yet. How would you envision them working in my situation? A combo box for each of the column choices?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans