Return All Gallery Items Where Dropdown Filter Is Blank

[hnguy71]

Good morning, everyone!

I have a dropdown that filters my gallery item when selected. For when there's something selected it works, but when it's blank, I'd like for it to return all the values. I think my formula is solid but the records returning are all empty.

I have a collection called DetailList and within my dropdown Items Property I am searching for distinct AcctUnit:

Sort(Distinct(Filter(DetailList, GM = _FindGM), AcctUnit), Ascending)

which gives me the right results:

In my gallery in the Items Property I have this to filter and return the records:

Filter(DetailList, GM = _FindGM, If(!IsBlank(Dropdown1_1.SelectedText.Value), AcctUnit = Dropdown1_1.SelectedText.Value))

If I choose let's say 1413900 I return the all the filtered items:

but when I don't choose anything I get a blank gallery:

Any help would be greatly appreciated!

[RandyHayes · Accepted solution]

@hnguy71 

Try to adjust your Formula as follows:

Filter(DetailList, 
       GM = _FindGM &&
       If(!IsBlank(Dropdown1_1.SelectedText.Value), AcctUnit = Dropdown1_1.SelectedText.Value, true)
      )

You want the result of your If statement to return a true if the dropdown is blank so that the other records are matched.

I hope this is helpful for you.

[hnguy71]

Omg thank you so much! Much appreciated! @RandyHayes I keep on learning new things everyday thanks to you!

[FacundoGorla]

I used the same logic but it has a delegation problem on SP lists. Any idea on how to solve it?