Gallery items limited to one value - Help needed

[CurtisH42]

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:

Missing expected values:

Best regards,

CurtisH.

[VauBee]

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]

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.

[VauBee]

Hi @CurtisH42 I like your mindset!