cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SAMUELAL
Resolver I
Resolver I

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

  • 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)

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

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:

v-albai-msft_0-1611905658177.png

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"):

v-albai-msft_1-1611905658180.png

Best Regards,

Allen

View solution in original post

3 REPLIES 3
SAMUELAL
Resolver I
Resolver I

SAMUELAL_0-1611868467090.png

 

v-albai-msft
Community Support
Community Support

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:

v-albai-msft_0-1611905658177.png

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"):

v-albai-msft_1-1611905658180.png

Best Regards,

Allen

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

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,761)