Share
ReportHello, I'm trying to build an app to search our part catalog. There are 10 different categories of part, and each part category is kept in a different table because they each have different attributes that I need to search by. Rather than building separate browse gallery and detail screens for each type of part, I'd like to have a single gallery that dynamically changes what table it's looking at depending on the part type that the user selects on the landing screen.
My solution so far:
To do this, I have a separate single column table called "part types" that is simply a list of all the part categories that populates the gallery on the landing screen. Then I use the following formula in the OnSelect property:
Navigate(DynamicBrowseScreen_Example,ScreenTransition.None,{SelectedPartType: Switch(PartSelectGallery1_Example.Selected.'PartTypes (PartTypes)',"PartType1", Table1,"PartType2",Table2,"PartType3",Table3)})
Where I create a context variable SelectedPartType and set it equal to the data source table that matches the chosen part type. Then on the DynamicBrowseScreen, I have a Gallery that calls SelectedPartType in the Items property. Everything works fine up to this point. Clicking a part type on the first screen populates the gallery on the 2nd screen with data from the correct table.
The problem:
When I try to customize the gallery control for what info to show in the gallery view, it only seems to recognize the table columns that all the part tables have in common.
For example, all the parts have a name and part number but some may have a diameter spec where others have a length spec. When I try to enter ThisItem.(ColumnName) in the Text property on the gallery control, it only recognizes Part Number and Name, and will not recognize any of the columns that are unique to a single table. This limits the type of information I can display and filter by for each part type.
Is there a solution that allows me to display different information and filter by different columns depending on the part selection?
All responses (
Answers (
505
