cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teaful
Helper I
Helper I

Filter gallery by checkboxes and search bar

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. 

1 ACCEPTED SOLUTION

Accepted Solutions

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,

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

View solution in original post

6 REPLIES 6
VDS_Mantra
Resolver I
Resolver I

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. 

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
Community Support
Community Support

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,

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

 

 

 

 

 

Thank you for your expertise.

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,

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

View solution in original post

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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