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 / Gallery items limited ...
Power Apps
Unanswered

Gallery items limited to one value - Help needed

(0) ShareShare
ReportReport
Posted on by 5

Hello users. I'm new to the MS Platform game running on self-taught information and heavy dependance on Copilot information.

 

Design requirement: I need a gallery that displays all of the training topics an individual needs to take (or have taken already). The data for the gallery is found across multiple SharePoint lists. The below collection equation is providing accurate results BUT, the gallery is only showing one of (expected) multiple values. Screen grabs added for reference. Your help is greatly appreciated.

 

ClearCollect(colCombinedData,AddColumns(Training_Matrix_People_Departments,"TrainingTopic",LookUp(Training_Matrix_Topic_by_Dept, Title = Training_Matrix_People_Departments[@Function] , Topic),"TrainingExpiry",LookUp(Training_Matrix_Training_Dates, Title = Training_Matrix_People_Departments[@Title], Training_Expiration)));
 
Sort(Filter(colCombinedData,Location = ComboBox1.Selected.Location) ,Title,SortOrder.Ascending)
 
Currently displayed:
CurtisH42_0-1708442748250.png

 

Missing expected values:

CurtisH42_1-1708442855104.png

 

Best regards,

CurtisH.

Categories:
I have the same question (0)
  • vaubeee Profile Picture
    533 on at

    Hi @CurtisH42 ! LookUp returns only the first record that satisfies a condition and therefore not useful if you want to source multiple databases & records. Here's a conceptual approach to how you might start restructuring your collection logic:

     

    Clear(colCombinedData);
    ForAll(Training_Matrix_People_Departments As _Person,
     Collect(colCombinedData, 
     AddColumns({_Person}, 
     "TrainingTopics", 
     Filter(Training_Matrix_Topic_by_Dept, Title = _Person.Function), 
     "TrainingExpiryDates", 
     Filter(Training_Matrix_Training_Dates, Title = _Person.Title)
     )
     )
    );

     

    This approach assumes that you can modify the structure to include collections of topics and expiry dates within each record for a person. You'll need to adjust the logic based on the actual structure of your SharePoint lists and the specific requirements of how you wish to display the data.

     

    Display in Gallery: Once you have a collection that correctly represents the data structure you need (with potentially nested collections for training topics and expiry dates), you can use a gallery (or nested galleries) to display this information. Ensure that your gallery's Items property is set to the collection (colCombinedData) and adjust the internal controls to display the nested information as required.

     

    This approach is quite high-level and needs adjustment based on your specific data structure. The key is moving away from LookUp for single records to a method that correctly aggregates all necessary records into your collection for display in the gallery.

     

    Have fun! 😉

     

    ------------------------------------------------------------------------------------------------------------------------------
    If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

  • CurtisH42 Profile Picture
    5 on at

    Dear @VauBee ,

     

    Thank you for the response. Your solution did teach me more about the design as well as build options in the app. Admittedly, it's above my head for now but I'll keep working down the path you've shared until I get it right. Your help is appreciated.

     

    Best regards,

    CurtisH.

  • vaubeee Profile Picture
    533 on at

    Hi @CurtisH42 I like your mindset!

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 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard