Return All Gallery Items Where Dropdown Filter Is Blank

Like (0) Share

Report

Posted on 20 Jun 2019 17:22:59 by hnguy71

347

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!

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (1)

FacundoGorla 293 on 02 Jul 2020 at 13:40:59

Like (3)

Report

Re: Return All Gallery Items Where Dropdown Filter Is Blank

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

Was this reply helpful? Yes No
hnguy71 347 on 20 Jun 2019 at 18:55:50

Like (1)

Report

Re: Return All Gallery Items Where Dropdown Filter Is Blank

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

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 20 Jun 2019 at 17:43:38

Like (5)

Report
Re: Return All Gallery Items Where Dropdown Filter Is Blank

@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.

Was this reply helpful? Yes No