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 subsites in same site collection)?
5 Replies
- Hi,
I‘m late to the party but you might want to try the List Aggregator Add-In:
https://appsource.microsoft.com/de-de/product/office/WA104380549?tab=Overview Hi Baronne!
In order to avoid redundancy items i think the easiest way to view items from all underlying risk-lists is to do the following:
One common Content Type
- Create a Common Content Type and add it to all risk-lists (in the subsites).
- Set the Content type to the default content type in all the lists in order to make sure all risk items are created based on the same Content Type.
Create a overview
In order to create an overview of the risk-items from all subsites you can choose one of this options:
- Option 1
- Create a page and add a Content Search Webpart.
- Configure the webpart so it only shows list items based on your Content type, sorting and the amount of elements you want to show.
- Option 2
- Create a page and add a Search Result Webpart.
- Configure the webpart so it only shows list items based on your Content type.
Personally I think Option 2 is the preferred solution because it will not limit the amount of list items that is displayed.
- spucelik
Microsoft
I 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.
