Scaling Microsoft Planner with Power Platform: Expert Guide
For many organizations, the quest for the perfect project management tool feels like an endless cycle of trial and error. On one end of the spectrum, you have high-end, expensive Enterprise Project and Portfolio Management (PPM) platforms that require months of training and a significant financial investment. On the other end, you have simple task lists that quickly become overwhelmed as projects grow in complexity. But what if the solution is already sitting within your Microsoft 365 ecosystem?
In a recent episode of the M365 Podcast, industry veteran and Microsoft MVP Eric Thunderhook shared his deep insights into how organizations can bridge this gap. With over 17 years of experience in the field, Eric makes a confident and compelling case for evolving Microsoft Planner from a simple task-tracking app into a sophisticated PPM solution by leveraging the Power Platform. If you have ever felt overwhelmed by the “tool fatigue” of the modern workplace, this exploration of Microsoft’s planning ecosystem is for you.
The Evolution of Project Management as a Profession
Over the last two decades, project management has undergone a massive transformation. As Eric notes, the profession has matured significantly. Today’s project managers are highly trained professionals who understand complex concepts like Net Present Value (NPV), Internal Rate of Return (IRR), and the critical path. They aren’t just looking for a place to check off boxes; they need tools that reflect the strategic nature of their work.
However, while project management at the individual level has become more sophisticated, many organizations still struggle with the layers above: Program and Portfolio Management. Eric highlights that a portfolio is not just a collection of projects, and a program is not just a large project. These are distinct entities that require their own ownership, budgets, and risk assessments. This is where the standard “out-of-the-box” tools often fall short, and where the need for a more integrated solution becomes clear.
The “Holy Grail” of Project Management: Resource Utilization
One of the most persistent challenges Eric sees in medium to large organizations is the correct utilization of resources. He refers to this as the “holy grail” of project management. The struggle stems from a fundamental structural conflict within many companies:
The Project Manager: Owns the project and is responsible for delivering on time, on budget, and with high quality.
The Resource (or Line) Manager: Owns the people and is responsible for their long-term development and overall workload.
This creates a constant tug-of-war. How do you ensure that your 200-person pool of developers, project managers, and Scrum masters are utilized efficiently without being overstressed? Without a centralized system that provides visibility into both project needs and resource availability, organizations often find themselves “reinventing the wheel” or suffering from massive over-allocation.
Navigating the Microsoft Planning Ecosystem
Microsoft offers a variety of tools that touch on project management, which can lead to confusion. Eric breaks down the landscape to help organizations choose the right tool for the right job:
Microsoft Project: The Robust Veteran
Microsoft Project is as old as the industry itself. It is a beautiful and powerful application for running complex, single projects. However, it comes with a steep learning curve that can be intimidating for non-professional project managers.
Microsoft Excel: The “Eternal Parasite”
In a humorous but relatable observation, Eric refers to Excel as the “eternal parasite” of project management. While it is excellent for building quick Gantt charts, it doesn’t actually manage projects. Yet, because of its ubiquity, it remains the default tool for many, despite its lack of collaborative features and data integrity.
Azure DevOps: The Technical Choice
For technical teams, Azure DevOps is the gold standard. It is built for Agile and Kanban workflows, making it ideal for software development and IT operations. However, it may not always align with the needs of a marketing team or a construction project.
Microsoft Planner: The Modern Contender
Planner took the world by storm during the COVID-19 pandemic. As offices emptied and everyone migrated to Microsoft Teams, Planner’s lightweight, card-based interface became the go-to for quick communication and progress tracking. It was originally aimed at “accidental” project managers, those who manage work but don’t necessarily have “Project Manager” in their job title.
The Rise of Planner Premium
To address the gap between simple task tracking and high-end project management, Microsoft introduced Planner Premium (which many may know as the evolution of Project for the Web). This version brings professional-grade features into the familiar, easy-to-use Planner interface. Key additions include:
Gantt Chart Views: Visualize the timeline of your project and see how tasks overlap.
Dependencies: Understand how the delay of one task impacts the rest of the schedule.
Baseline Capabilities: Compare your current progress against your original plan to identify variances.
Critical Path Analysis: Identify the sequence of tasks that determines the shortest possible duration for the project.
By combining the simplicity of Planner with these advanced features, Microsoft is empowering a broader range of users to manage projects with professional precision.
Extending Planner with Power Apps and Dataverse
The real magic happens when you stop viewing Planner as a standalone app and start seeing it as a component of the Power Platform. Eric specializes in helping organizations build practical planning solutions by extending Planner with Power Apps and Dataverse.
Because the “new” Planner is built on Dataverse, it allows organizations to create that missing layer of Program and Portfolio Management. You can create custom entities for Programs that sit above individual projects. This allows for:
Centralized Financials: Track budgets at the portfolio level while individual projects track their own spending.
Unified Risk Management: Roll up risks from multiple projects into a single program-level view.
Custom Relationships: Link projects to specific strategic goals or departments using the relational power of Dataverse.
This approach offers a trustworthy and polished way to achieve enterprise-level results without the “enterprise-level” price tag or complexity.
Key Takeaways for Your Organization
If you are looking to improve your organization’s project management maturity, consider these actionable insights from Eric’s experience:
Identify Your Maturity Level: Are you struggling to track the number of projects you have, or are you struggling with complex resource allocation? Your tool choice should match your specific pain point.
Bridge the Gap with Dataverse: Don’t just settle for task lists. Use the Power Platform to create a “single source of truth” that connects projects to programs and portfolios.
Empower the “Accidental” PM: Use the intuitive interface of Microsoft Planner to encourage adoption across the organization, while using Premium features for those who need more control.
Focus on Resource Management: Start a dialogue between project managers and line managers. Use centralized data to move from a “battle for resources” to a collaborative utilization strategy.
Conclusion
The journey from simple task management to a fully-realized Project and Portfolio Management system doesn’t have to be a daunting or prohibitively expensive endeavor. As Eric Thunderhook demonstrated, the tools you already use, Microsoft Planner, Teams, and the Power Platform, are more than capable of evolving with your needs.
By leveraging the latest features in Planner Premium and the customization potential of Power Apps, you can build a solution that is both professional and practical. The goal isn’t just to check off tasks; it’s to gain the visibility and control needed to drive your organization forward. The future of planning is integrated, accessible, and powerful, and it’s already at your fingertips.