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.
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.
Modern SharePoint List Rollup
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.
Content Aggregation within Microsoft Teams
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.
Building Reports on Microsoft Graph
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.
Building Reports on Microsoft 365 GROUPS
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.
Aggregating using Search
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.
Highlight Key Business Data Within Your Views
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…
Built In 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.
Web Part Connections
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.
Before Lightning Conductor, all we had available to us was default SharePoint views and custom coded JSON views, which were difficult to built and maintain and had plenty of limitations. Lightning Conductor perfectly filled that gap and allowed us to easily create simple dashboards that pull from SharePoint lists. Read more
