SharePoint Document Issues

How to Aggregate Planner Data on a SharePoint Site

Ayan MasoodAyan Masood Nov 2, 2026 868 views

Question details

The user needs to display task data and completion percentages from multiple Planner plans on a SharePoint site that is not connected to a Microsoft 365 group.

How to Aggregate Planner Data on a SharePoint Site
Product
SharePoint, Microsoft Planner
Device & OS
not provided
Scenario
Displaying centralized task data from multiple Microsoft Planner plans on a non-group connected SharePoint page.
Observed behavior
Because there is no built-in SharePoint feature to aggregate multiple Planner plans into a single view, an alternative workflow using SharePoint lists and Power Automate is required to achieve this goal.
Before you start

Ensure you have permission to create SharePoint lists on the target site and access to Power Automate to create automated cloud flows.

Solution 1Recommended

Use Power Automate to Sync Planner Tasks to a SharePoint List

Create a centralized SharePoint list and use a Power Automate flow to copy task data from multiple plans into this list for display.

Since SharePoint does not natively aggregate multiple Planner plans on a non-group site, creating a custom SharePoint list is the most reliable workaround. Power Automate will act as the bridge, ensuring tasks are synced efficiently.

1
Create a SharePoint List

Navigate to your SharePoint site, click 'New', and select 'List'. Add necessary columns for Task Name, Plan Name, Assignment, Status, and Completion Percentage.

2
Create a Power Automate Flow

Log in to Power Automate and create an automated cloud flow. Set the trigger to fire whenever a new task is created, assigned, or completed in your target Planner plans.

3
Map the Task Data

Add a 'Create item' or 'Update item' SharePoint action to your flow. Map the dynamic content from the Planner trigger to the corresponding columns in your newly created SharePoint list.

4
Display on SharePoint

Go to your SharePoint site page, edit the page, and insert a 'List' web part. Select your aggregated task list to display the integrated Planner data to your users.

Use Power Automate to Sync Planner Tasks to a SharePoint List
Automate Status Updates: Make sure your Power Automate flow includes condition logic to update existing list items when a task's completion percentage changes, rather than only creating new items.
Free Microsoft Office alternative

Manage Your Projects Effectively with WPS Office

If managing complex SharePoint setups and Power Automate flows is too cumbersome, consider using WPS Office for your project planning needs. It is a highly compatible, free Microsoft Office alternative that allows you to easily create, track, and share project plans using built-in spreadsheet templates.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open WPS Spreadsheets: Launch WPS Spreadsheets and browse the template library for project trackers and dashboards.
  3. 3. Customize Your Plan: Select a task management template and easily customize it to track multiple project stages without complex automations.
Fully compatible with Microsoft Excel, Word, and PowerPoint formats.Rich library of free project management and task tracking templates.Lightweight software that runs efficiently on Windows, Mac, and Linux.Familiar interface makes switching from Microsoft Office seamless.
microsoft office alternative - wps office

Frequently Asked Questions

Can I use the Planner web part to display multiple plans at once?

No, the native Planner web part in SharePoint currently only supports displaying a single plan at a time. Aggregating multiple plans requires a custom list or a third-party application.

Does this workaround require a premium Power Automate license?

Standard Planner and SharePoint connectors in Power Automate do not typically require a premium license and are included with most basic Microsoft 365 business subscriptions.

What if I only want to show my own assigned tasks across multiple plans?

Users can view all their personally assigned tasks across multiple plans without any SharePoint setup by using the 'My Tasks' view directly in the Microsoft Planner app or via the 'Tasks by Planner and To Do' app in Microsoft Teams.