Lightning Conductor

Quickly and easily build reports on your Microsoft 365 content such as SharePoint lists, Planner Tasks, OneDrive items and much more. Display your content in a central report within modern SharePoint or Microsoft Teams tabs.

Core Features


he Lightning Conductor is a very powerful, but simple to use content aggregation tool for Microsoft SharePoint Online and Microsoft Teams. Users can quickly build rich, modern content reports based upon SharePoint lists, SharePoint Search, Microsoft Graph or Microsoft 365 Groups. Content can be aggregated from lists and libraries, and other applications such as Planner, To Do, OneDrive, Teams and more.

SharePoint List Rollup

You can spend a long time looking for content in SharePoint. Using the Lightning Conductor you can easily build powerful, customized reports on your SharePoint list content aggregated from across sites, site collections, Hub Sites and Associated sites.

Microsoft Graph Reports

Content can exist in many places throughout Microsoft 365. The Lightning Conductor works beyond lists and without code you can build reports on Microsoft Planner Tasks, OneDrive Items, Messages, User Information and much more using the Microsoft Graph API.

Search Rollups

When performance is critical, you can use SharePoint Search with the Lightning Conductor to display your content from Lists and Libraries. Display results from Search Result Sources such as Popular Items, Items by Content Type and Documents.

Try Out The Lightning Conductor

Try out the Lightning Conductor using the below guided tour. We’ll configure the Lightning Conductor to aggregate Document Libraries, Task Lists, Microsoft Graph Entities such as Microsoft Planner & OneDrive, and Finally configure the Lightning Conductor to connect to External Data such as Jira.


The Lightning Conductor is a powerful, modern, responsive SharePoint Content Aggregator that can be configured quickly and easily by business users. Using the Lightning Conductor you can aggregate content from SharePoint Lists such as Tasks, Document Libraries, Contact Lists, and Custom Lists making it easy to view your content in one place even if it is distributed across many sites and site collections. Key data can be highlighted using conditional formatting and data-bars as shown. Content from Search and Microsoft Graph can also be aggregated with the Lightning Conductor just as easily.


The Lightning Conductor Web Part can be used within Microsoft SharePoint or Microsoft Teams. Even if your content is stored within SharePoint sites, it is very useful to have your aggregated Documents, Tasks, Announcements, Calendars or Custom Lists from multiple sites displayed in a single handy view in Microsoft Teams right where you are working! You can add the Lightning Conductor as a Teams Tab in any of your Microsoft Teams Channels.


The Lightning Conductor can be used (without code) to aggregate content from Microsoft Graph as well as Search and SharePoint Lists. In this example, we are displaying Microsoft Planner Plans and Microsoft Planner Tasks where users can Add new Tasks, Assign Users to Planner Tasks, Delete Tasks, and Complete Tasks. The same can be performed on Microsoft To Do items and displayed within Modern SharePoint pages or Microsoft Teams Tabs. The Lighting Conductor can also contain multiple views of content, making it ideal to display all of your tasks from SharePoint Task lists, Microsoft To Do and Microsoft Planner in a single web part or Teams Tab.

*Microsoft Graph Reports are only available for SharePoint Online and not SharePoint 2019.

Aggregate Microsoft 365 Group Content within SharePoint

Powered by Microsoft Graph, the Microsoft 365 Group Rollup Provider enables users to aggregate content by browsing and selecting Microsoft 365 Groups. Within Microsoft 365 Groups, you’ll be able to select entities such as Drive Items, Owners, Members, Planner Plans, Planner Tasks, Events, Posts,  Sites, Lists, and Calendars.

*Microsoft Graph Reports are only available for SharePoint Online and not SharePoint 2019.

SharePoint List Rollup From Search Results

When performance is critical, you can use search for your rollups! The Lightning Conductor offers three data source configurations to get to your content. Object Model (Real Time Aggregation from SharePoint Lists), Microsoft Graph (Aggregation from Graph Entities such as Planner, OneDrive, Outlook), and Search. The Search Data Source enables you to aggregate content from large SharePoint lists and libraries when performance is critical. Thousands of documents can be displayed in under a second using Search.

SharePoint Content Aggregation with No Code Conditional Formatting

We empower end users and Site Owners to highlight the data that is important to them, the data that they need to prioritize! Using conditional formatting, data bars, and icons, you can configure conditions to highlight the data that is most important to you or your team. Icons and Data Bars can be any color or size that you desire. Examples include highlighting High Priority tasks, Showing data bars for the completion progress of Tasks, or indicating which tasks are assigned to you.

Register for our next Lightning Conductor webinar…


SharePoint Content Aggregation With Built In Calendar, Events, and Tile Views

The Lightning Conductor also includes many built in views. As well as using the flexible, responsive and modern Grid View, The Lightning Conductor includes views specifically designed for Events, Microsoft Planner, Microsoft To Do, Document Tile View, Calendar View and much more. You can also create your own custom views using JSON.

Build Adaptive Card Views

The Lightning Conductor allows you to use Adaptive Card views as a way of displaying your aggregated content. Adaptive Card views that are built into the Lightning Conductors quick configuration include Tasks, Events and Picture views.

Microsoft Adaptive Cards in SharePoint

Using the Advanced Configuration, you can generate the Sample Data to use with Microsoft’s Adaptive Card Designer. Then, use the Microsoft Adaptive Card Designer to build your view, and then copy the payload to the Lightning Conductor.

Connect Multiple SharePoint Rollup Web Parts

The Lightning Conductor can consume data connections from other web parts, environment variables such as query string parameters, current user, and page title. The connections can provide a value that can be consumed for filtering content aggregated into your view, applying conditional formatting, or selecting the entire view of content based upon the connected value.

*The Connections are only available for SharePoint Online and not SharePoint 2019.

Building Charts on Aggregated Content

Through web part connections, you can use the Data Viewer SPFx web part to build charts on the content aggregated with the Lightning Conductor. Here is an example of building charts based upon aggregated Task lists. You could also build charts on content aggregated through Microsoft Graph on entities such as Planner Tasks and display the dashboard within SharePoint or Teams. The Data Viewer is available as an addon purchase.

Lightning Conductor Customer Reviews

Consumer Goods
Within the Consumer Goods sector, our customers benefit from using the Lightning Conductor as a reporting tools to report across documents distributed through multiple projects (sites).
Automotive Sector
Within the Automotive sector, our customers benefit from using the Lightning Conductor to aggregate content across multiple classic site collections.
Oil and Gas
Within the Oil and Gas sector, our customers benefit from using the Lightning Conductor as part of a solution to aggregate content through Microsoft Graph
Item added to cart View Cart Checkout