How to Aggregate Planner Data on a SharePoint Site
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.

- 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.
Ensure you have permission to create SharePoint lists on the target site and access to Power Automate to create automated cloud flows.
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.
Navigate to your SharePoint site, click 'New', and select 'List'. Add necessary columns for Task Name, Plan Name, Assignment, Status, and Completion Percentage.
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.
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.
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.

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. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open WPS Spreadsheets: Launch WPS Spreadsheets and browse the template library for project trackers and dashboards.
- 3. Customize Your Plan: Select a task management template and easily customize it to track multiple project stages without complex automations.

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.




