How to aggregate multiple lists into one list?

%3CLINGO-SUB%20id%3D%22lingo-sub-203635%22%20slang%3D%22en-US%22%3EHow%20to%20aggregate%20multiple%20lists%20into%20one%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203635%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20would%20you%20go%20about%20creating%20a%20centralised%20company-wide%20%22risk%20register%22%20list%20that%20aggregates%20list%20items%20(pulls%20or%20pushes%3F)%20from%20multiple%20%22risk%20registers%22%20in%20various%20business%20departments%20(in%20other%20subsites%20in%20same%20site%20collection)%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-203635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205073%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20aggregate%20multiple%20lists%20into%20one%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205073%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20link%20above%20gave%20me%20a%20404%2C%20this%20%3CA%20title%3D%22Table%20Layout%20with%20Sorting%20Templates%20(CSWP)%22%20href%3D%22https%3A%2F%2Fgithub.com%2FSPCSR%2FDisplayTemplates%2Ftree%2Fmaster%2FSearch%2520Display%2520Templates%2FTable%2520Layout%2520with%2520Sorting%2520Templates%2520(CSWP)%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eshould%20work%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203846%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20aggregate%20multiple%20lists%20into%20one%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203846%22%20slang%3D%22en-US%22%3Ethanks%20for%20this%2C%20I'll%20give%20it%20a%20whirl%20and%20see%20how%20it%20goes%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203835%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20aggregate%20multiple%20lists%20into%20one%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203835%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20Magnus's%20approach%20all%20the%20time%20and%20it%20works%20great.%26nbsp%3B%20Honors%20security%20trimming%20and%20easy%20to%20aggregate%20results.%26nbsp%3B%20Here%20is%20a%20great%20display%20template%20to%20make%20it%20look%20like%20a%20list.%20%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSPCSR%2FDisplayTemplates%2Ftree%2Fmaster%2FSearch%2520Display%2520Templates%2FTable%2520Layout%2520with%2520Sorting%2520Templates%2520(CSWP)%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSPCSR%2FDisplayTemplates%2Ftree%2Fmaster%2FSearch%2520Display%2520Templates%2FTable%2520Layout%2520with%2520Sorting%2520Templates%2520(CSWP)%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203684%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20aggregate%20multiple%20lists%20into%20one%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203684%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Baronne!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20to%26nbsp%3Bavoid%20redundancy%20items%20i%20think%20the%20easiest%20way%20to%20view%20items%20from%20all%20underlying%20risk-lists%20is%20to%20do%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EOne%20common%20Content%20Type%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3ECreate%20a%20Common%20Content%20Type%20and%20add%20it%20to%20all%20risk-lists%20(in%20the%20subsites).%3C%2FLI%3E%3CLI%3ESet%20the%20Content%20type%20to%20the%20default%20content%20type%20in%20all%20the%20lists%20in%20order%20to%20make%20sure%20all%20risk%20items%20are%20created%20based%20on%20the%20same%20Content%20Type.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3ECreate%20a%20overview%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIn%20order%20to%20create%20an%20overview%20of%20the%20risk-items%20from%20all%20subsites%20you%20can%20choose%20one%20of%20this%20options%3A%3C%2FP%3E%3CUL%3E%3CLI%3EOption%201%3CUL%3E%3CLI%3ECreate%20a%20page%20and%20add%20a%20Content%20Search%20Webpart.%3C%2FLI%3E%3CLI%3EConfigure%20the%20webpart%20so%20it%20only%20shows%20list%20items%20based%20on%20your%20Content%20type%2C%20sorting%20and%20the%20amount%20of%20elements%20you%20want%20to%20show.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EOption%202%3CUL%3E%3CLI%3ECreate%20a%20page%20and%20add%20a%20Search%20Result%20Webpart.%3C%2FLI%3E%3CLI%3EConfigure%20the%20webpart%20so%20it%20only%20shows%20list%20items%20based%20on%20your%20Content%20type.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EPersonally%20I%20think%20Option%202%20is%20the%20preferred%20solution%20because%20it%20will%20not%20limit%20the%20amount%20of%20list%20items%20that%20is%20displayed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870685%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20aggregate%20multiple%20lists%20into%20one%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870685%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI%E2%80%98m%20late%20to%20the%20party%20but%20you%20might%20want%20to%20try%20the%20List%20Aggregator%20Add-In%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fappsource.microsoft.com%2Fde-de%2Fproduct%2Foffice%2FWA104380549%3Ftab%3DOverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fappsource.microsoft.com%2Fde-de%2Fproduct%2Foffice%2FWA104380549%3Ftab%3DOverview%3C%2FA%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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 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.

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%20...

thanks for this, I'll give it a whirl and see how it goes

The link above gave me a 404, this should work.

 

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