Project to Planner Sync FAQ
The sync will work if you are using Project Professional and save/store your projects in Project Online.
By default, the following fields can be changed on either end:
- Task Title
- Task Start
- Task End (Due Date)
- Task % Complete (Progress)
- Task Description (Notes)
- Task Bucket Name
- Task Priority
- Task Labels
- Task Assignments
Yes, Planner does not have security controls to prevent this.
The sync solution will not delete tasks on either end.
If a Planner Task is deleted the task-level sync field in Project indicates “Deleted”
If a Project Task is deleted the planner task title is appending with “|Deleted”
There are separate configuration options to prevent Planner Task updates from updating:
- Project Task Title
- Project Task Start and Finish
- Project Task % Complete
- Project Task Assignments
During install a “Planner Sync to Multiple PlanId” custom task-level field is created. To sync a Project to multiple plans, you must copy the PlanId (described above) and paste into this task-level custom field.
During install a “Planner Sync Task Bucket” custom task-level field is created. This is a free form text field so it can support unlimited Bucket names. It’s possible to change this field to a drop-down list (lookup field). However, Project Online lookup fields are the same for all projects so you would need to have the same buckets across all projects.
The default sync time is every 10 minutes.
No, there is not a limit to the number of tasks from Project, however Planner used to have a limit (which was removed in 2010) and may come back.
Yes, the Dates, Assigned to, Task Title, as well as the Progress, Priority, Planner Buckets, Label and Comments have a bi-directional sync to/from Project and Planner.
Yes, the dependencies (both predecessors and successors) that are set in Project and go to Planner will remain in Project when the data syncs back from Planner to Project. When possible the task will remain automatically scheduled. However there are some conditions, such as setting a start/finish date on a weekend/non-working date that require manually scheduled tasks.
No, at this time checklist items are not synced.
The task will sync but the assignment will be blank – there will not be a resource assigned.
The tool will wait for the project to be checked in and apply the updates.
The tasks will be synched, duplicate tasks are not created, no risk to starting the service.
Yes, however these guest users will not be included in the Enterprise Resource Pool and they will not see any of the resources assigned to the tasks.
No, Project can not determine which update would apply
Yes, you can decide which plans task should be synchronized to. One Project can have tasks linked to multiple different plans.
Yes, the sync tracks deleted tasks and automatically updates the task that have been deleted in the Sync Status field.
Yes. This is very popular request from those currently managing a project in Planner and need to see the visibility and status in Microsoft Project
Please reach out to discuss pricing
PPM Works will install the code, PWA Project Views, and Project Detail Pages to support the Sync
For team members: Microsoft Planner (E1 or E2, etc.)
For project managers: Microsoft Project Online with a Project Plan 3 license:
The Sync Service account will need both Office 365 (with Planner) and a Microsoft Project Plan 3 license
An Azure AD Account with Group Admin role will be used by the Sync Service to access Project Online and Microsoft Planner
Yes. You will can add the existing Plan UID into the project to sync to an existing plan.
Similar to selecting which projects to sync, every task has a sync option which you can turn on or off.
Yes, the sync will allow changes from both Project and Planner to sync back and forth.
To get the integration capability, you need to subscribe to either Project Online Professional or Project Online Premium. For Planner, you need to subscribe to Office 365 Business Essentials, Business Premium, E1-E5, or an Education plan. Contact us with any questions.