List Aggregator app for Microsoft 365 is a SharePoint client-side web part, utilizing the new SharePoint Framework (SPFx), enabling users to aggregate data from various data sources and display the aggregated data using a great-looking “Lego” style controls.
Complex data aggregation made simple in SharePoint Online
Aggregation & data display Tools for SP Online & Teams
Roll-up Data from Any Data Source Across SharePoint Sites
Easily connect to data sources
Aggregate data from multiple SharePoint sites and site collections
Excel files
All your Office 365 Online data through Graph API
Add List Aggregator App to Microsoft Teams
You can now add the KWizCom List Aggregator App (SPFx) to your Microsoft Teams!
Easily roll up data from any data source right into your team, department or any other Teams work space.
Dynamic aggregation scope
The List Aggregator app allows you to connect it to multiple aggregation sources, each can have a different dynamic scope, enabling you to dynamically aggregate items from specific SharePoint lists, sites & sub-sites and entire site-collection.
You can further limit your aggregation results by using additional filtering options:
filter by list/site name pattern
filter by list types
filter by content type
This way you can easily create a dynamic query that retrieves only the relevant items and documents from various sites in your SharePoint online tenant.
OneDrive, Azure AD and other MS Online resources become accessible
Using the MS Graph API data source, you can easily aggregate data from any MS Online resource!
Conditional formatting
Easily highlight your data with icons and fore/back colors, according to various logic conditions.
Great-looking, "Lego" style UI
The entire end-user interface is composed of controls that you can add/remove to assemble the exact UI you want!
You can configure how your data will be displayed, what buttons and menus will be available, so you can have a custom aggregated view that matches your exact requirements!
The Business Need
Out-of-the-box SharePoint list views are limited to a single SharePoint list, while Collaboration sites, SharePoint Dashboards, Enterprise Project Management sites and many others require the ability to aggregate data from multiple sources, and display it in convenient way for end users to work with it.
Key Features & Benefits
Feature
List Aggregator App STD. edition
List Aggregator App PRO. edition
Aggregation of various list types
Cross-site aggregation
Supports Cross-site-Collection aggregation
Aggregate lists and libraries by content type
Refine the aggregation scope by site/list name patterns – Much more flexible than only aggregating by content types
SPFx responsive display controls: Table, List, Tabs, Groups, Paging, Global and item-actions
Deeper customizations available by using CSS and knockout
Export to CSV
Can be added to Microsoft Teams
MS Graph API data source
Excel file data source
SharePoint Search data source
Configurable Filters
Conditional formatting (apply different colors & icons according to various employee properties such as job title, branch, etc.)
This client-side web part is part of the KWizCom Data View Tools package (SPFx) for SharePoint Online/2019 Server.
Adding this client-side web part to your site is done in 2 steps:
Add the kwizcom-data-view-tools solution package to your organization’s App Catalog
Add the web part to your page
Add the kwizcom-data-view-tools package to your organization’s App Catalog
The App Catalog is the place where all apps used by the organization are managed.
Adding solution packages to the App Catalog is done by the Tenant Admin.
(To learn more about how to manage your company’s App Catalog, please refer to the relevant Microsoft documentation for SharePoint On-Premises and for SharePoint Online)
Add the kwizcom-data-view-tools solution package to your App Catalog by following these steps:
Upload the package extracted from the zip file to the “Apps for SharePoint” library in your App Catalog site:
After uploading the package, SharePoint will display a dialog and ask you to trust the client-side solution to deploy:
Check the “Make this solution available to all sites in the organization” and click “Deploy”.
Add the web part to a page
After the kwizcom-data-view-tools package was uploaded and deployed to your organization’s App Catalog, users can add the web part to pages:
1.
Edit the page.
2.
In a modern page, Click the “+” button in the zone where you want to add the web part (Add a new web part).
3.
Click the web part you want to add:
4.
After you click the web part you wish to add (in the screenshot below it’s List Aggregator), you will see all web parts which are part of the KWizCom Data View Tools package:
Click the Edit web part icon to start configuring your web part (or switch to one of the other web parts if you wish to check them out).
Update your installed app with a new version
When a new app build is released there is no need to re-install the solution package.
All you have to do is clean your browser’s cache and close all browser windows and then re-visit the page that includes the web part.
This will update your installed app with the new version’s javascript files.
