How to apply a All filter with many dropdowns

[davismarist1198]

Hi,

I am currently trying to add "all" too many different drop-downs on my gallery's. Currently, I have multiple galleries, each linked to the other via a collection. Here is a examplel formula with 2 of my drop downs

Filter(Tsp,(Certsdd.Selected.Result= "All" And Rankdd.Selected.Result= "All") Or ('What is your current rank'=Rankdd.Selected.Result And Certsdd.Selected.Result= "All" ) Or ('certifications?' = Certsdd.Selected.Result And Rankdd.Selected.Result= "All") Or ('What is your current rank'=Rankdd.Selected.Result And 'certifications?' = Certsdd.Selected.Result))

This works as designed, the current issue is some pages that are linked to gallerys have more than two drop downs. Some have up to 10 drop downs for filters. Is there a way to stream line this filtering process. As it stands now I would need to write 49 lines of code for a page that has 7 drop downs to account for every combination. This is a very tedious process, do you have any process improvements or is there any way to loop through these drop downs? Below is a picture of my dropdown / app.

[iAm_ManCat · Accepted solution]

Heya,

Yes, you can simplify it in that you only want to filter in each case when something is selected, so add the 'all' as the alternate option as below here:

Filter(
   Tsp,
   // Either rank is all, or filter by rank
   (Rankdd.Selected.Result= "All" Or 'What is your current rank'=Rankdd.Selected.Result)
   ,
   // Either certs is all, or filter by cert
   (Certsdd.Selected.Result = "All" Or 'certifications?' = Certsdd.Selected.Result)
)

Cheers,

Sancho

[Adam1986 · Accepted solution]

Hi,

in my opinion best practice is to filter gallery by approach described below. If any of your dropdowns will be empty it will be omitted.

Filter(Tsp,
        ('What is your current rank' = Ranked.Selected.Result || IsBlank(Ranked.Selected.Result))
    &&  ('certifications?' = Certsdd.Selected.Result || IsBlank(Certsdd.Selected.Result)) && ...)

WIth this approach you can filter your gallery by any number of dropdowns. Just allow dropdown to have blank selection (AllowEmptySelection = true).