List Aggregator App (SPFx)
Roll-up data from any data source across your SharePoint sites
KWizCom’s List Aggregator app 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.
SharePoint data aggregation the easy way
Complex data aggregation made simple in SP Online
Aggregation & data display Tools for SP Online & Teams
- Aggregate data from multiple SharePoint sites and site collections
- Excel files
- All your Office 365 Online data through Graph API
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.
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 lists, sites & sub-sites and entire site-collection.
You can further limit your aggregation results 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.
Using the MS Graph API data source, you can easily aggregate data from any MS Online resource!
Easily highlight your data with icons and fore/back colors, according to various logic conditions.
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!
Out-of-the-box SharePoint list views are limited to a single SharePoint list, while Collaboration sites, Dashboards, Enterprise Project Management sites & many others require the ability to aggregate data from multiple sources, and display it in convenient way for end-user 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.) | ||
| Legend control |
Related Products
Calendar Plus App (SPFx)
SharePoint and Exchange Online Calendar Aggregation
Data View Plus App (SPFx)
The ultimate Swiss-knife of data retrieval and display!
Org. Chart App (SPFx)
Great-looking & highly customizable Organization Chart!
Picture Gallery App (SPFx)
Display your amazing pictures from remote/distributed locations the right way!
List View Plus App (SPFx)
Easily embed remote list views in your page, as if they were local!
Primary Version
| Version | 1.0.12 Build 131 |
| Base version | 1.0.12 Build 124 |
| Release date | Dec-30-2020 |
Version 1.0.12 Build 131, Dec-30-2020
| 6761 | Added: Sync with Data View Plus app version |
Version 1.0.12 Build 124, Oct-18-2020
| 6761 | Added: Sync with Data View Plus app version |
Version 1.0.12 Build 123, Oct-11-2020
| 6761 | Added: Sync with Data View Plus app version |
Version 1.0.12 Build 121, Jun-22-2020
| 6761 | Added: Sync with Data View Plus app version |
Version 1.0.12 Build 120, Jun-01-2020
| 6761 | Added: Sync with Data View Plus app version |
Version 1.0.12 Build 1168 May-16-2020,
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 116, Apr-30-2020
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 113, Mar-22-2020
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 107, Jan-14-2020
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 104, Dec-24-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 99, Dec-12-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 97, Nov-28-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 92, Oct-20-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.12 Build 91, Oct-10-2019
| 6135 | Added: Support SharePoint 2019 Server |
Version 1.0.12 Build 87, Jul-26-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.11 Build 84, Jun-12-2019
| 6088 | Added: Changed duplicate "data source" term to "Aggregation scope" |
Version 1.0.11 Build 80, May-28-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.11 Build 77, May-08-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.11 Build 75, Apr-24-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.11 Build 74, Apr-18-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.11 Build 73, Apr-03-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.11 Build 72, Mar-29-2019
| 5999 | Fixed: text will overlap search icon when search box loses focus |
Version 1.0.11 Build 61, Feb-20-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.10 Build 59, Jan-25-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.10 Build 57, Dec-31-2019
| 5200A | Added: sync with Data View Plus app version |
Version 1.0.0.9 Build 54, Oct-24-2018
| 5200A | Added: Sync with Data View Plus app version |
Version 1.0.0.9 Build 52, Oct-20-2018
| 5825 | Fixed: implement caching for list aggregator data source |
Version 1.0.0.8 Build 49, Sep-21-2018
| 5200A | Added: Sync with Data View Plus app version |
Version 1.0.0.7 Build 48, Sep-06-2018
Version 1.0.0.7 Build 47, Aug-22-2018
Version 1.0.0.7 Build 22, Feb-08-2018
| 5576 | Fixed: version field does not show up in list aggregator app |
Version 1.0.0.7 Build 19, Jan-09-2018 - Base version
| 5528 | Fixed: Field names with special characters will not show data when used in the list aggregator app |
| 5539 | Fixed: Approval Status field data does not appear in list aggregator app |
| 5540 | Fixed: The data in the 'Title' field will match the 'Name' field regardless of what is actually in the Title field |
| 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:
| 1. | For SharePoint Online – Download this zip file. For SharePoint Server 2019 – Download this zip file. |
| 2. | 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.
Documentation & Tools
| DESCRIPTION | |
|---|---|
| DESCRIPTION: User Guide | DOWNLOAD |
List Aggregator App STD. Annual Subscription
| #Users | SKU | Price (USD) | Payment Type | Action |
|---|---|---|---|---|
| #Users : Up to 100 | SKU: ASLAGS-100 | Price: $750 | Payment Type: Annual | Get a Quote |
| #Users : 101 to 1000 | SKU: ASLAGS-1000 | Price: $750+$1.2/user | Payment Type: Annual | Get a Quote |
List Aggregator App PRO. Annual Subscription
| #Users | SKU | Price (USD) | Payment Type | Action |
|---|---|---|---|---|
| #Users : Up to 100 | SKU: ASLAGP-100 | Price: $890 | Payment Type: Annual | Get a Quote |
| #Users : 101 to 1000 | SKU: ASLAGP-1000 | Price: $890+$1.5/user | Payment Type: Annual | Get a Quote |
| Subscription includes: ✓ Unlimited site collections ✓ 1 login domain ✓ Version upgrades and technical support included |
|
Top