Forum Discussion

Copper Contributor

Nov 03, 2020

Cross Subsite lookup list

Hi We have an O365 SharePoint Online site collection with multiple sub sites of student data. Each sub site represents results of a set of students in a particular class from a particular year. I'd...

LOOKUP FUNCTION

SharePoint Online Office 365

James Burch

Copper Contributor

Nov 03, 2020

Martin-Coupal

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.

Martin-Coupal

Iron Contributor

Nov 03, 2020

James Burch

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://support.microsoft.com/en-us/office/configure-a-content-search-web-part-in-sharepoint-0dc16de1-dbe4-462b-babb-bf8338c36c9a

https://docs.microsoft.com/en-us/sharepoint/use-result-types-and-display-templates

James Burch
Copper Contributor
Nov 03, 2020
Martin-Coupal
Thanks Martin, I'll investigate the search functions and see if can offer what I require.
- Martin-Coupal
  Iron Contributor
  Nov 04, 2020
  James Burch There could be an easier solution using a commercial web part like this : https://www.infowisesolutions.com/product/SmartRollupPro
  https://www.infowisesolutions.com/blog/comments.aspx?id=243
  
  I've been working with these web parts some time ago and they work pretty well. Don't know if you can buy only this web part or need to get the bundle.