Answered

Using dropdown to show different columns in gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a page with a browse gallery and I want to show one column all the time and switch between other columns in a list. My list name is 'Isles' and my column names are "Row", "Zone 1","Zone 2","Zone 3","Zone 4","Zone 5"

I want to display Row all the time and use a dropdown to select the different zones. I linked my list and chose "Row" as the first title and put this in the subtitle label:

If(Dropdown1.Selected.Value = "Zone 1" || Dropdown1.Selected.Value = ShowColumns('Isles',"Zone 1"))

I have tried a few other things but nothing worked. Do I need to make a collection to accomplish this? My dropdown is just me defining the choices like ["Zone 1", etc].

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I found a way to accomplish what I need.

I tried to do something like this on the label text:

If(Dropdown1.Selected.Value="Zone 1",ThisItem.Zone 1)

I ended up making 4 overlapping labels and setting the visible property to:

If(Dropdown1.Selected.Value = "Zone 1",true,false)

Seems kind of dirty but it work well.

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Glad to see you solved the problem.
You could mark your answer as a 'solution' to close the case.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No