Return All Gallery Items Where Dropdown Filter Is Blank

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (5)

Report
Copy link

Link copied!
@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
hnguy71 347 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
FacundoGorla 293 on at

Like (3)

Report
Copy link

Link copied!

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