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

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 II
Resolver II

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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,696)