Lightning Conductor – SharePoint Rollup Web Part for Lists, Calendars, News & More
WHY CHOOSE THE LIGHTNING CONDUCTOR?
The Lightning Conductor is a modern, no-code SharePoint Rollup Web Part that helps you build smarter SharePoint intranet pages by bringing together content from across your Microsoft 365 environment—and beyond.
With Lightning Conductor, you can aggregate SharePoint lists, libraries, calendars, tasks, and news from multiple sites and site collections into one clear, customizable view. No need to jump between sites or write complex queries—it’s all done through a user-friendly interface.
But it doesn’t stop at SharePoint. Using the Microsoft Graph API and Microsoft 365 Connectors, you can also pull in content from apps like Planner and Teams, and even connect to external systems such as Salesforce, SQL Databases, and Oracle. This makes it a true SharePoint content aggregation tool for both internal and third-party data.
Whether you need a SharePoint news rollup, a cross-site task dashboard, or a single web part that surfaces data from multiple tools, Lightning Conductor gives you the control and flexibility to build powerful, connected experiences—without writing any code.
- Unified SharePoint Content Aggregation Consolidate SharePoint lists, libraries, calendars, and news into a single view across sites, hubs, or tenants.
- External Data Aggregation via Microsoft Graph & Connectors Display tasks from Microsoft Planner, content from Teams, or data from external systems like Salesforce and ServiceNow using Microsoft 365 Graph Connectors.
- Advanced Customization Apply filters, grouping, sorting, conditional formatting, and view customization to tailor data displays for specific audiences.
- Modern Intranet Integration Embed the Lightning Conductor into modern SharePoint pages to enhance team dashboards, department landing pages, or executive portals.
- No-Code Solution for Business Users Empower users to build powerful dashboards and rollups without technical skills or PowerShell—saving time and reducing IT dependency.
The Lightning Conductor includes a rich set of features that make it the most flexible and powerful SharePoint Rollup Web Part for content aggregation across SharePoint and Microsoft 365. Whether you’re building project dashboards, news rollups, or calendar views, Lightning Conductor helps you surface the right content, in the right format, at the right time—without writing code.
- Multiple DIsplay Views: Choose how you want to visualize your data: Use Grid Views for list rollups, show events in calendar views, display news rollups or agenda views.
- Connected Web Parts for One-to-Many Views: Create connected web parts that show related items—such as documents linked to a task, or comments related to a list item. This enables one-to-many data aggregation across lists and libraries, giving your SharePoint intranet true relational visibility.
- Security Trimmed Content: The Lightning Conductor respects SharePoint permissions automatically. Users will only see content they have access to—making it ideal for secure cross-site content aggregation in large environments or multi-departmental portals.
- Calculated Columns: Add calculated columns to your rollups to display real-time summaries, custom date ranges, or conditional values. Great for tracking project status, due dates, and KPIs directly within the web part—no Excel export needed.
- Adaptive Card Views: Use Adaptive Cards to create modern, responsive layouts that look great in SharePoint Online and Microsoft Teams. Display aggregated content in an interactive, mobile-friendly way—ideal for alerts, summaries, or dynamic dashboards.
The Lightning Conductor is built as a SharePoint Framework (SPFx) web part, providing a robust and modern solution for content aggregation and display within SharePoint Online and Microsoft 365 environments. The SPFx architecture allows Lightning Conductor to seamlessly integrate with SharePoint and Microsoft Teams, leveraging the full capabilities of the Microsoft 365 ecosystem to deliver a responsive, fast, and user-friendly experience.
The SPFx solution also benefits from being fully deployed within the client’s Microsoft 365 tenant, ensuring that all data is securely handled and processed within the trusted Microsoft environment. This approach maintains data privacy and security, as no information leaves the tenant, and all user interactions are governed by SharePoint’s robust security and permissions model.
SharePoint Calendar Rollup
Aggregate and display calendar events from multiple SharePoint sites in one unified view.
The Lightning Conductor acts as a powerful SharePoint Calendar Rollup Web Part, providing a modern alternative to calendar overlays. Whether you’re tracking team events, project deadlines, or department schedules, Lightning Conductor helps you aggregate SharePoint calendars across site collections without needing to configure multiple calendar overlays.
- Display cross-site SharePoint calendars in a single calendar view
- Replace the legacy SharePoint calendar overlay functionality
- Filter events by category, date range, or team
- Surface important deadlines on SharePoint intranet homepages
SharePoint News Rollup
Create a central news hub by rolling up articles and announcements from across your SharePoint environment.
With the Lightning Conductor, you can build a dynamic SharePoint News Rollup Web Part that pulls news from communication sites, department pages, or hubs—ideal for your SharePoint intranet.
- Aggregate modern SharePoint news from multiple sites
- Create a company-wide news feed on your intranet homepage
- Filter and highlight news by topic or department
- Surface important deadlines on SharePoint intranet homepages
SharePoint Document Rollup
Surface documents from multiple SharePoint libraries in one place for better visibility and access.
Lightning Conductor supports SharePoint Document Library Rollup, allowing you to create centralized dashboards or pages that display content from across your Microsoft 365 environment.
- Roll up documents from multiple site collections
- Build a cross-site document library rollup for project portals
- Filter by file type, modified date, or metadata
- Display important files on department or team homepages
SharePoint Task Rollup
Display tasks from multiple SharePoint task lists or Microsoft Planner plans in one consolidated view.
Lightning Conductor enables powerful SharePoint task list rollup and Microsoft Planner integration using the Microsoft Graph API—ideal for project tracking and operational visibility.
- Aggregate SharePoint task lists into a unified dashboard
- Display Planner tasks assigned to the current user
- Track project tasks across multiple departments or teams
- Visualize progress using conditional formatting or views
Aggregate Beyond SharePoint Lists
Surface content from Microsoft 365 apps like Planner, OneDrive, and Teams—all without code.
Using Microsoft Graph, Lightning Conductor functions as a no-code Microsoft Graph query web part—letting you bring in rich data from outside SharePoint.
- Display OneDrive documents on a SharePoint page
- Show Microsoft Planner tasks in SharePoint dashboards
- Aggregate Teams content or loop components (via Graph)
- Query M365 data using adaptive cards or list views
Display External Data in SharePoint
Bring business-critical data from external systems into SharePoint using Microsoft 365 Connectors and Graph API.
Lightning Conductor allows you to surface structured external data like Salesforce, SQL, or Dynamics content directly within your SharePoint intranet.
- Display Salesforce data in SharePoint via Graph Connectors
- Show project metrics from SQL databases in dashboard views
- Integrate external CRM, ERP, or HR data into modern pages
- Create real-time SharePoint dashboards combining internal and external sources
For those requiring more advanced functionality, the Lightning Conductor offers a variety of granular configuration options. In its advanced mode, you can choose how to aggregate content based on your specific needs. Real-time content can be aggregated using the Client-Side Object Model, providing live updates directly from SharePoint. For larger data sets or improved performance, the search-based aggregation allows for rapid retrieval of content. Additionally, you can leverage Microsoft Graph to aggregate data from Microsoft 365 apps such as OneDrive or Planner. For even more flexibility, External Graph Connectors enable you to bring in content from external data sources, giving you a truly comprehensive overview across your business applications.
- Client-Side Object Model Aggregation: Display real-time content from SharePoint lists and libraries, ensuring live data is always at your fingertips.
- Search-Based Aggregation for Performance: Use search results to pull in large sets of content quickly, offering impressive performance and data retrieval speeds.
- Microsoft Graph & External Connectors: Aggregate content from Microsoft 365 apps like OneDrive and Planner, or extend beyond Microsoft 365 using External Graph Connectors to include third-party or custom data sources.
The Lightning Conductor seamlessly integrates with Viva Connections dashboards by offering an Adaptive Card display, ensuring that aggregated content is always at your fingertips. Whether you are viewing news, tasks, or documents, the Lightning Conductor allows you to access this content directly on your mobile device, within Microsoft Teams, or inside SharePoint. This unified approach ensures that you stay informed and productive, no matter where you are working from, providing real-time content updates across platforms for a truly connected experience.
- Adaptive Card Integration: Display key content like news, tasks, and documents in an easy-to-view Adaptive Card format within Viva Connections dashboards.
- Multi-Platform Accessibility: Access your aggregated content on the go from your mobile device, within Teams, or in SharePoint for seamless productivity.
- Unified Content Experience: Stay up-to-date with real-time content across your organization, ensuring that the information you need is always available at your fingertips.
While SharePoint’s Out-of-the-Box (OOB) content aggregation web parts provide basic functionality for aggregating lists and libraries, the Lightning Conductor significantly extends these capabilities, offering a more powerful, flexible, and customizable experience. With support for multiple content sources—including SharePoint, Microsoft 365 Apps, and external data—alongside advanced configuration options, the Lightning Conductor stands out for its ability to aggregate content in real time, provide interactive web part connections, and deliver customizable views like calendars and adaptive cards. Moreover, its seamless integration with Viva Connections, enhanced user experience features, and robust support make it an ideal solution for organizations looking to streamline their content aggregation beyond the standard SharePoint offerings.
Feature |
lIGHTNING cONDUCTOR |
SharePoint |
|---|---|---|
| Multiple Content Sources | SharePoint lists, libraries, Microsoft 365 Apps (e.g. Planner, OneDrive), Search, External data (via Graph Connectors) | SharePoint lists & libraries only |
| Configuration Flexibility | Advanced configuration for conditional formatting, calculated columns, data formatting with or without code. | Limited customization options |
| Display Options | Customizable grid, list, JSON, Adaptive Card, and calendar views | Standard list, grid, or tile views |
| Performance & Scalability | Search-based aggregation for high performance and large data sets | Good performance but small scopes |
| Real-Time Content Aggregation | Real-time content via Client-Side Object Model | Search based |
| Viva Connections Support | Adaptive Card display within Viva Connections dashboards | SharePoint Only |
| Interaction Between Web Parts | Full support for web part interactivity (filtering, linked previews, etc.) | Limited or no connection between web parts |
| External Data Aggregation | Support for external data via External Graph Connectors | No direct support for external data |
| Mobile & Teams Access | Full integration with mobile devices, Teams, and SharePoint via Viva Connections | Basic support through SharePoint Online |
| Support & Updates | Dedicated support from Lightning Tools with regular feature updates | Standard support from Microsoft |
| Custom Development Options | No-Code to Low-Code options, with advanced configurations for developers | No development required but very limited capabilities |
A SharePoint Rollup Web Part aggregates content—like lists, calendars, tasks, and news—from multiple SharePoint sites into a single, consolidated view. The Lightning Conductor is a modern, no-code rollup solution built for SharePoint Online and Microsoft 365.
Yes. With Lightning Conductor, you can roll up calendar events from multiple SharePoint sites or site collections into a single, interactive calendar view. It’s a modern alternative to traditional SharePoint calendar overlays.
Lightning Conductor allows you to aggregate SharePoint news posts from multiple communication sites or hubs. You can filter by metadata and display news in tile, list, or adaptive card formats—perfect for intranet homepages.
Absolutely. The Lightning Conductor uses the Microsoft Graph API to connect to Planner and display tasks assigned to users or teams. You can filter, sort, and display tasks alongside traditional SharePoint list items.
Yes. Using Microsoft 365 Graph Connectors, Lightning Conductor can display external data from systems like Salesforce, SQL Server, or Dynamics—all within your SharePoint intranet. It’s ideal for surfacing external data without leaving the Microsoft 365 environment.
Yes. Lightning Conductor automatically respects SharePoint permissions, so users will only see content they have access to. This ensures secure and compliant rollup views across your tenant.
No. Lightning Conductor is a 100% no-code solution. You can create and customize rollups using an intuitive UI—no PowerShell, JSON, or custom development required.
Yes. Lightning Conductor is built using SPFx (SharePoint Framework), making it fully compatible with modern SharePoint pages, Microsoft Teams, and adaptive card-based dashboards.