Forum Discussion
Cross Subsite lookup list
James Burch , what is the information (results) you are trying to aggregate from subsites? Is the information contains in SharePoint lists? Are you working in classic or modern UI.
Not having the details, if using modern UI normally you could:
1) Use Power Automate to sync the results at the Root site in a list.
2) Use search to aggregate information from multiple sites (or subsites). This would requires to create managed properties in the search engine. To display results and have refiners (filters) you would be better of using the PnP modern search web parts: https://microsoft-search.github.io/pnp-modern-search/
Thanks for responding. The site is done in classic UI and the results are in the class list. So a class list could be Maths with all the student names in one column and their test results in the subsequent columns. Each student could have many results depending on how many tests they took.
So the same options would be valid. For option #2 using search, you would need to use the classic search and refiners web part
However, this requires some knowledge using the search engine and also display templates for the search results.
https://docs.microsoft.com/en-us/sharepoint/use-result-types-and-display-templates
Thanks Martin, I'll investigate the search functions and see if can offer what I require.
