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
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)
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.
That didn't work unfortunately
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!
For anyone with the same issue. I solved it. I changed the gallery text from:
Filter(Mapping, crb20_package = Dropdown2.SelectedText.Value)
Filter(Mapping, crb20_package = Dropdown2.SelectedText.Value),
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020