cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fatih1 Helper III
Helper III

Re: Gallery Item based on dropdown

So I make everything step by step.

 

Make an Dropdown to Filter your Module.

Items -> Distinct(Mapping.Module);

 

Make an Gallery which only shows the selected modules.

Items of Gallery -> Filter(Mapping; Module = Dropdown.selected.Module).Items

Make an textinput in your Gallery -> Text: ThisItem.Items

 

Try this. 

Kathryn_Marie Helper III
Helper III

Re: Gallery Item based on dropdown

Almost perfect!

 

I had to add a listbox for the items in a module but I have the correct data coming up now. So it is:

 

Dropdown: Distinct(Mapping, crb20_package)

Gallery: Filter(Mapping, crb20_package = Dropdown2.SelectedText.Value)

Title: ThisItem.crb20_module

Listbox: Filter(Mapping, crb20_module = Label1.Text)

 

Only last issue is that the modules are coming up duplicated. So looking at the original table how it is mapped the module is listed for each item. I tried the distinct method on ThisItem.crb20_module, but got an error that it was expecting 2 arguments. 

 

I have attached a screenshot. 

 

Powerapps screenshot.png

Fatih1 Helper III
Helper III

Re: Gallery Item based on dropdown

I never tried this before, but try this: Distinct(Mapping, ThisItem.crb20_module)

Kathryn_Marie Helper III
Helper III

Re: Gallery Item based on dropdown

That didn't work unfortunately Smiley Sad

 

Trying evertthing I can think of 😕 I have a new screenshot because I have also added a formula to size the box based on the amount of values listed. I feel so close yet so far!

Powerapps screenshot.png

Powerapps screenshot.png

Kathryn_Marie Helper III
Helper III

Re: Gallery Item based on dropdown

For anyone with the same issue. I solved it. I changed the gallery text from:

 

Filter(Mapping, crb20_package = Dropdown2.SelectedText.Value)

 

To:

 

GroupBy(
Filter(Mapping, crb20_package = Dropdown2.SelectedText.Value),
"crb20_package",
"crb20_module",
"crb20_item"
)

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (8,849)