Forum Discussion
How to aggregate multiple lists into one list?
How would you go about creating a centralised company-wide "risk register" list that aggregates list items (pulls or pushes?) from multiple "risk registers" in various business departments (in other ...
spucelik
Microsoft
MicrosoftI use Magnus's approach all the time and it works great. Honors security trimming and easy to aggregate results. Here is a great display template to make it look like a list. https://github.com/SPCSR/DisplayTemplates/tree/master/Search%20Display%20Templates/Table%20Layout%20with%20Sorting%20Templates%20(CSWP)
The link above gave me a 404, this should work.