Answered

Filtering a gallery using a dropdown

(1) Share

Report

Posted on by hotdogman

Good Monday,

I want to add a filter this gallery based upon the floor levels using a dropdown as I have another filter in the gallery that only displays rooms from "RS_KS11100" on the roomsgallery items

The floors are labeled in the room names by the number at the end of "RS_11100_X"

for example,

RS_KS11100_1 is on the first floor

RS_KS11100_2 is on the second floor

then it goes up to the fifth floor

Screenshot 2024-07-15 083339.png

this is what it looks like right now

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

fhamm on at

Like (1)

Report
Copy link

Link copied!
Perhaps you could try to set a variable OnChange of the dropdown that you can refer to in your filter code.

First, you'll either want to set the default of the dropdown to something that isn't a floor number (like "select floor" or something) OR set your floor variable to the initially shown value (in this case, 1) on App Start.

OnChange of dropdown:
Set(varFloor, "RS_KS11100_"&Text(Dropdown1.Selected.Value))

Then in your filter code, refer to the varFloor variable in the StartsWith expression where you want to filter for the floor:
StartsWith(Name, varFloor)

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report
Copy link

Link copied!

im kinda dumb, could you show me how I can incorporate the last part in my filter

Was this reply helpful? Yes No
Verified answer

fhamm on at

Like (1)

Report
Copy link

Link copied!
If I'm understanding how you're using the filter currently, I'd change it to this:
Filter(AvailableRoomEmailName, StartsWith(Name, varFloor) && Name <> "RS_KS11100_1 - Theater" && Name <> "RS_KS11100_1 - Auditorium")
If you set up the varFloor variable right, it should change to RS_KS11100_X with X being the floor selected in the dropdown box. Does that make sense/work with what you're trying to do?

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report
Copy link

Link copied!

Yes that makes sense, I'll get it a try right now

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report
Copy link

Link copied!

it works @fhamm ily, have a good day this monday

Was this reply helpful? Yes No
fhamm on at

Like (2)

Report
Copy link

Link copied!

Awesome! Glad it worked 🙂

Was this reply helpful? Yes No