Display filtered data with the same title, but different subtitle.

[SAMUELAL]

• I have a Gallery that I filter using the barcode scanner.
• The Gallery is filtered by an 'Alias', and each 'Alias' has multiple 'Part Numbers' attached.
• Is there a way to utilize the space within the red box on the attached image to display all of the 'Part Numbers' for a given 'Alias' that is filtered by the barcode?

Scanner:

OnScan = Set(V1,BarcodeScanner1.Value)

Gallery:

Items = Filter(Table2,'Alias Item Number'=V1)

[SAMUELAL]

[v-albai-msft · Accepted solution]

Hi @SAMUELAL ,

Do you want to display all of the related 'Part Numbers' beside your gallery based on the scanned value?

Is your datasource a SharePoint list? From your attached image, seems that "C73X000023" is the "Alias", and numbers like "0990263674", "0990344874" below ""C73X000023" are the "Part Number". If I misunderstand, please correct me.

If yes, you can add a DataTable to display all of the 'Part Numbers'. You can refer to my steps:

1. Assuming your datasource is a SharePoint list, I create a simple list:

2. Create a new app based on this list, Set the Items property of the default gallery to:

Filter(list1,Alias=V1)

3. Add a “barcode scanner” control and set its OnScan property to:

Set(V1,BarcodeScanner1.Value)

4. Add a DataTable besides the default gallery and set its Text property to:

Filter(list1,Alias=V1).PartNumbers

For you, just add a DataTable and use this: 

Items = Filter(Table2,'Alias Item Number'=V1).'Part Numbers'

See results below(in my country, barcode is the format like "6933036312967"):

Best Regards,

Allen

[SAMUELAL]

This works exactly how I need it to. Thank you!!!