web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display filtered data ...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by
  • 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)

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    SAMUELAL_0-1611868467090.png

     

  • Verified answer
    v-albai-msft Profile Picture
    on at

    Hi @Anonymous ,

    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

  • Community Power Platform Member Profile Picture
    on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard