SharePoint Rollup Announcements

Announcements in SharePoint are a great way to let your team members know what’s going on. But are all announcements appropriate for everyone in your organization? Or would you like to make everyone aware of some announcements which are buried in a Team Site? Both of those scenarios are where SharePoint rollup Announcements would make sense.

SharePoint Rollup Announcements using the Content Query Web Part

Using SharePoint’s Content Query Web Part, you could roll up Announcements from anywhere within the current Site Collection, and display them in a basic format. Using the default settings (except for removing the default entry in the Link field, which will otherwise error):

SharePoint Rollup Announcements - Content Query web part settings

Content Query web part default settings

Here’s what you’ll see:

Content Query Announcements Rollup

Of course, you can jazz that display up quite a bit with custom XSL styling… if you know how to do that.

SharePoint Announcements rollup using the Content Search Web Part

If you wish to roll up SharePoint Announcements from multiple Site Collections, you could use SharePoint’s Content Search Web Part. This assumes you have the Enterprise version of SharePoint. I’ve chosen some very basic out-of-the-box settings in the Search Query and in the Web Part’s properties, as shown below:

Content Search Web Part query settings

Content Search Web Part properties

Here’s the result of the above settings:

SharePoint rollup announcements - Content Search Web Part results

Again, you can make this look much nicer by applying a custom Display Template. That is, you can edit HTML for the Control Template and the Item Template. See Search-driven Web Parts and Display Templates for information about how this works. Note also that while the results can be aggregated from a larger scope than the current Site Collection, items are only available if SharePoint Search has crawled them.

Lightning Conductor – the Lightning Tools SharePoint content rollup web part

Or… you could use the Lightning Conductor, the flexible, easy-to-use content rollup web part from Lightning Tools! To do a SharePoint Online Announcements rollup from within the current Site Collection, you can use the default Object Model rollup provider, as shown below.

You can easily select the scope of the rollup via a treeview of your Site Collection. Below, I’ve highlighted the Customer Demonstration Site Collection, to display items from the root site. I’ve also ticked the checkbox to the left, which will automatically roll up items from all subsites (including sites created in the future). I’ve selected the Announcements List Type, so only items from Announcements lists will be aggregated. I could also select a specific Content Type if I wished. But as I’ve already selected the Announcements List Type, and my items are of the default Announcements Content Type, there’s no need to select a specific Content Type.

Lightning Conductor Add-in Data Source tab - SharePoint Announcements rollup

On the Columns tab of the Lightning Conductor Add-in configuration, you can easily select any out-of-the-box SharePoint Announcements columns, or any custom columns you’ve created. You do this by simply by ticking the checkbox, and dragging the columns into the order in which you wish them to be displayed. Compare this to the Content Query Web Part, which allows only a few columns in the default view, and requires you to choose the correct column from a list of every single SharePoint column. Below, I’ve also selected to sort by the Modified date, with the newest item at the top. In addition, I’ve set a filter on the Modified date column, such that only Announcements modified within the past 30 days are displayed.

Lightning Conductor Add-in SharePoint Announcements rollup - columns

Lightning Conductor Add-in SharePoint Announcements rollup - filter by Modified date

Using the Lightning Conductor, you can also easily format the display without needing to write XSL or HTML code. Below, I’ve selected a US “Short Date” format for the Modified date; other formats can also be entered. I changed the column heading of the Parent Web Title to “Site” (to show the subsites from which the Announcements are being rolled up). I’ve also specified to display HTML in the Announcement Body so fonts and images will be displayed.

Lightning Conductor Add-in SharePoint Announcements rollup - Display tab

And here are the results of just those few moments’ work with the Lightning Conductor:

SharePoint rollup announcements - Lightning Conductor Add-in SharePoint Announcements rollup

You can also enhance the display further by using custom XSL. But as you can see, there’s a lot you can do without needing to write custom code.

The Lightning Conductor also allows you to do SharePoint rollup Announcements across Site Collections. With the Lightning Conductor Add-in for SharePoint Online, you would use the Lightning Conductor’s Search rollup provider. With the Lightning Conductor Web Part for SharePoint on-premises (2007, 2010, 2013, or 2016), it’s simply a matter of selecting to ‘Show items from multiple Site Collections’ – or any scope up to and including the entire Farm.

<Sandy/>