How to Sync SharePoint Task Lists with Microsoft Planner
Question details
The user wants to know if and how SharePoint task lists, including those created from MPP files, can be synchronized with Microsoft Planner.

- Product
- SharePoint and Microsoft Planner
- Device & OS
- not provided
- Scenario
- Attempting to manage project tasks by synchronizing items between a SharePoint task list and a Microsoft Planner board.
- Observed behavior
- There is no built-in, native two-way synchronization feature between SharePoint task lists and Microsoft Planner.
Ensure you have an active Microsoft 365 subscription with access to SharePoint, Microsoft Planner, and Power Automate, along with the necessary permissions to create and manage automated flows.
Use Power Automate to Sync SharePoint and Planner Tasks
Since native synchronization is unavailable, you can use Microsoft Power Automate to create a custom flow that copies or syncs tasks between SharePoint and Planner.
Power Automate enables you to define custom triggers and actions across Microsoft 365 apps. By configuring a flow, you can accurately map task names, assignments, due dates, and statuses from your SharePoint list directly to your Planner board.
Log in to Microsoft Power Automate, click on 'Create' from the left sidebar, and select 'Automated cloud flow' to begin setting up your synchronization process.
Choose a trigger such as 'When an item is created or modified' and select your specific SharePoint site address and task list from the dropdown menus.
Click 'New step' and search for Microsoft Planner. Select an action like 'Create a task' or 'Update task details' depending on your sync requirements.
Click inside the Planner action fields (like Title, Start Date, Due Date, Assigned User Ids) and select the corresponding dynamic content tags from your SharePoint list to map the data correctly.
Add 'Condition' steps to check if a task already exists to prevent duplicate entries. Once configured, click 'Save' and use the 'Test' button to verify that the flow works as intended.

Manage Your Project Documents Seamlessly with WPS Office
While syncing SharePoint task lists requires specialized Microsoft 365 automation tools, your daily project documentation doesn't have to rely on expensive subscriptions. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your Word, Excel, and PowerPoint needs.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open Your Project Files: Launch WPS Office and directly open your existing project plans, spreadsheets, or presentations without worrying about format issues.
- 3. Edit and Share: Utilize the intuitive tools to update your project documents and share them effortlessly with your team as native office files or PDFs.

Frequently Asked Questions
Can I sync a Microsoft Project (MPP) file directly with Microsoft Planner?
No, Microsoft Planner does not support direct two-way synchronization with MPP files. You typically need to sync the MPP file to a SharePoint task list first, and then use Power Automate to bridge the SharePoint list with Planner.
Why is there no built-in sync between SharePoint and Planner?
Microsoft designed Planner as a standalone lightweight task management tool, while SharePoint task lists are part of the older SharePoint framework. Microsoft encourages using Power Automate to connect these different ecosystems based on custom user needs.
How do I prevent Power Automate from creating duplicate tasks in Planner?
To avoid duplicates, you must add a 'Condition' control step in your Power Automate flow. Set the condition to list existing tasks in Planner and verify if the SharePoint task ID or task name already exists before triggering the 'Create a task' action.




