Automated Project Management Process
Complete Formal Reference Guide
Document Version: 1.0
Effective Date: August 4, 2026
Classification: Public Edition
Document Owner: Project Management Office Director
Governing Authority: Project Management Office
Prepared By: Project Management Office — Automation and Governance Division
Platform Environment: Microsoft 365 Enterprise
This document has been prepared in accordance with the Project Management Institute's Project Management Body of Knowledge, Seventh Edition, and constitutes the authoritative reference for all automated project management processes conducted within this organization.
© 2026 — All Rights Reserved — Public Edition
Document Control Information
| Version | Date | Author | Description of Changes | Approved By |
|---|---|---|---|---|
| 1.0 | August 4, 2026 | Project Management Office — Automation and Governance Division | Initial release of the Automated Project Management Process Complete Formal Reference Guide. | Project Management Office Director |
| 1.1 | TBD | TBD | Reserved for future revision. | TBD |
Table of Contents
Section 1 — Executive Overview .............................................................… 7
1.1 Purpose and Scope of This Document
1.2 Vision for Fully Automated Project Management
1.3 Integration Architecture Overview
1.4 Alignment with Project Management Body of Knowledge, Seventh Edition
1.5 Governing Authority, Document Owner, and Version Control
Section 2 — Organizational Roles and Responsibilities (RACI Matrix) ..................... 10
Section 3 — Complete Project Charter ....................................................…. 18
3.1 through 3.11 — All Charter Subsections
Section 4 — Project Management Institute Best Practice Workflow ......................…. 28
4.1 through 4.13 — All Phases and Performance Domains
Section 5 — Microsoft Copilot Integration .................................................… 46
5.1 through 5.8 — All Copilot Integration Points
Section 6 — Microsoft Power Automate Flows — Complete Specifications ..................... 54
6.1 through 6.8 — All Automated Flows
Section 7 — Microsoft Power Business Intelligence Dashboard — Complete Specification .…. 72
7.1 through 7.7 — All Dashboard Pages and Configuration
Section 8 — Quality Management Plan ....................................................…. 88
Section 9 — Communication Plan ..........................................................… 92
Section 10 — Risk Management Framework .................................................… 98
Section 11 — Change Control Process ....................................................…. 104
Section 12 — Procurement and Vendor Management .......................................... 110
Section 13 — Project Closure and Archival Procedure .....................................… 115
Section 14 — Governance Framework and Compliance .....................................… 120
Section 15 — Glossary of Terms ..........................................................… 126
Appendix A — Project Charter Template (Blank) ...........................................… 140
Appendix B — Risk Register Template (Blank) ................................................ 144
Appendix C — Change Request Form Template (Blank) .....................................… 147
Appendix D — Status Update Collection Form Fields .......................................... 150
Appendix E — Lessons Learned Survey Questions ............................................. 152
Appendix F — Power Automate Flow Trigger Reference Table ...............................… 155
Appendix G — Microsoft Copilot Approved Prompt Library .................................... 158
Section 1: Executive Overview
1.1 Purpose and Scope of This Document
This document — the Automated Project Management Process Complete Formal Reference Guide, hereinafter referred to as "this Reference Guide" — establishes the authoritative, comprehensive, and binding procedural framework governing all aspects of automated project management within the organization. It is intended to serve as the singular, unified source of truth for all project personnel, technology administrators, governance bodies, and stakeholder representatives who participate in, oversee, or are impacted by project delivery activities conducted under this process.
The scope of this Reference Guide encompasses the full project management lifecycle, from the initial conception and formal authorization of a project through its controlled closure and archival. It explicitly covers the configuration, operation, and governance of automated tools including, but not limited to, Microsoft Copilot (the artificial intelligence — the technology that uses machine learning and large language model capabilities to assist human users with drafting, summarizing, and analyzing content — hereinafter referred to as "Copilot"), Microsoft Power Automate (the low-code workflow automation platform, hereinafter referred to as "Power Automate"), Microsoft Power Business Intelligence (the business analytics and data visualization platform, hereinafter referred to as "Power Business Intelligence"), Microsoft SharePoint (the collaborative document and list management platform, hereinafter referred to as "SharePoint"), Microsoft Teams (the unified collaboration and communication platform, hereinafter referred to as "Teams"), and Microsoft Dataverse (the scalable cloud data platform underpinning the Microsoft Power Platform, hereinafter referred to as "Dataverse").
This Reference Guide applies to all projects managed under the jurisdiction of the Project Management Office (hereinafter referred to as the "Project Management Office") and is binding upon all personnel — whether full-time employees, contractors, or external consultants — who are formally assigned to any project team governed by this framework. Any deviations from the processes, procedures, and standards set forth in this Reference Guide must be formally authorized in writing by the Project Management Office Director and documented as approved exceptions in the relevant project records.
1.2 Vision for Fully Automated Project Management
The overarching vision governing this Reference Guide is the establishment of an intelligent, integrated, and largely automated project management ecosystem in which administrative burden is systematically minimized, human decision-making is consistently supported by real-time data and artificial intelligence-generated insights, and project governance standards are enforced through technology rather than solely through manual processes. This vision is grounded in the recognition that the manual execution of project management activities — including status collection, risk identification, reporting, change tracking, and stakeholder communication — introduces significant inefficiencies, increases the likelihood of human error, and reduces the speed at which organizational leadership can respond to emerging issues.
The fully automated project management environment envisioned by this Reference Guide leverages the capabilities of the Microsoft 365 (Microsoft's cloud-based productivity and collaboration suite, hereinafter referred to as "Microsoft 365") and Microsoft Power Platform (the integrated suite of low-code development, automation, and analytics tools including Power Automate, Power Business Intelligence, Power Apps, and Dataverse, hereinafter referred to as the "Power Platform") ecosystems to create a seamless, end-to-end flow of project information. In this environment, project data is captured at the point of origination — whether through a team member submitting a status update, a risk being logged, or a milestone being marked complete — and flows automatically through validation, consolidation, notification, escalation, and reporting processes without requiring manual intervention at each step.
It is expressly acknowledged that automation does not replace human judgment. The automated processes defined in this Reference Guide are designed to ensure that the right information reaches the right people at the right time, thereby enabling faster, more informed, and more consistent human decision-making. All automated notifications, escalations, approvals, and reports require human review and, where appropriate, human action. The role of automation is to eliminate low-value administrative tasks so that project professionals can direct their attention toward strategic planning, stakeholder engagement, and problem-solving activities that genuinely require human expertise.
1.3 Integration Architecture Overview
The integration architecture supporting this automated project management process is built entirely within the Microsoft 365 and Power Platform ecosystems, ensuring data residency compliance, security consistency, and operational continuity within a single, governed technology environment. The following tools constitute the core of the integration architecture:
Microsoft Copilot: The artificial intelligence assistant embedded throughout Microsoft 365 applications and the Power Platform. Copilot is used to draft documents, summarize meeting transcripts, generate risk registers, produce status reports, analyze project data, and provide natural language query capabilities within Power Business Intelligence. Copilot operates within the organization's Microsoft 365 tenant and is governed by the organization's data governance and data loss prevention policies.
Microsoft Power Automate: The cloud-based workflow automation platform used to build, deploy, and manage all automated flows described in Section 6 of this Reference Guide. Power Automate connects to SharePoint, Teams, Microsoft Planner, Microsoft Forms, Microsoft Outlook, Dataverse, and Power Business Intelligence through certified connectors, enabling event-driven automation across the project management lifecycle.
Microsoft Power Business Intelligence: The data visualization and business analytics platform used to build and maintain the project management performance dashboards described in Section 7 of this Reference Guide. Power Business Intelligence ingests data from SharePoint lists, Dataverse tables, Microsoft Planner (via the Microsoft Graph Application Programming Interface — the Microsoft application programming interface that enables programmatic access to Microsoft 365 data, hereinafter referred to as the "Microsoft Graph Application Programming Interface"), and external financial systems, and presents this data in role-appropriate visual reports.
Microsoft SharePoint: The foundational data repository platform for this process. All project lists — including the Project Registry, Risk Register, Issue Log, Status Updates list, Budget Tracking list, Change Request log, Stakeholder Register, and Lessons Learned Register — are hosted in SharePoint. SharePoint also serves as the document management system for all project artifacts, including charters, plans, reports, and meeting records.
Microsoft Teams: The primary communication and collaboration platform for all project-related interactions. Teams serves as the delivery channel for automated notifications, adaptive card approvals, meeting management, and real-time project collaboration. Each project is provisioned with a dedicated Teams environment with structured channels as defined in Section 9.5 of this Reference Guide.
Microsoft Dataverse: The enterprise-grade data platform used to store structured project data that requires relational integrity, advanced security controls, and Power Platform integration. Dataverse is used for Copilot data grounding, advanced workflow state management, and integration with the broader Power Platform ecosystem including Power Apps (the low-code application development platform within the Power Platform).
The following table provides a high-level summary of the tool integration architecture:
| Tool | Primary Role in This Process | Integration Points |
|---|---|---|
| Copilot | Artificial intelligence assistance: drafting, summarizing, analyzing | Teams, Outlook, SharePoint, Power Business Intelligence, Power Automate |
| Power Automate | Workflow automation: triggers, routing, notifications, escalation | SharePoint, Teams, Planner, Outlook, Forms, Dataverse, Power Business Intelligence |
| Power Business Intelligence | Data visualization: dashboards, reports, trend analysis | SharePoint, Dataverse, Graph Application Programming Interface, OData |
| SharePoint | Data repository: lists, document libraries, project sites | Power Automate, Power Business Intelligence, Teams, Copilot |
| Teams | Communication: notifications, approvals, meetings, channels | Power Automate, Copilot, Planner, SharePoint |
| Dataverse | Enterprise data: relational tables, security, Power Platform state | Power Automate, Power Business Intelligence, Copilot, Power Apps |
1.4 Alignment with the Project Management Body of Knowledge, Seventh Edition
This Reference Guide is expressly designed to align with and operationalize the standards, principles, and performance domain framework established by the Project Management Institute (the globally recognized professional association for project management, hereinafter referred to as the "Project Management Institute") in its Project Management Body of Knowledge, Seventh Edition (the authoritative guide to the knowledge, skills, and principles essential for effective project management practice, hereinafter referred to as the "Project Management Body of Knowledge Seventh Edition"). The Project Management Body of Knowledge Seventh Edition represents a principles-based evolution from its predecessor editions, emphasizing outcomes-driven delivery, adaptive approaches, and stakeholder value over prescriptive process compliance alone.
This Reference Guide maps the automated processes and governance structures defined herein to the eight performance domains of the Project Management Body of Knowledge Seventh Edition — specifically: the Stakeholder Performance Domain, the Team Performance Domain, the Development Approach and Life Cycle Performance Domain, the Planning Performance Domain, the Project Work Performance Domain, the Delivery Performance Domain, the Measurement Performance Domain, and the Uncertainty Performance Domain. Additionally, all twelve guiding principles of the Project Management Body of Knowledge Seventh Edition are embedded into the governance, automation, and human-review elements of this process, as detailed in Section 4 of this Reference Guide. The practical embodiment of these principles and performance domains in the specific automated workflows, quality gates, and escalation procedures defined in this Reference Guide ensures that compliance with Project Management Institute standards is not merely aspirational but is systematically enforced at the process level.
Section 2: Organizational Roles and Responsibilities
2.1 Role Definitions
Executive Sponsor
The Executive Sponsor is the senior organizational leader who holds ultimate accountability for the strategic outcome and business value of the project. This individual authorizes the Project Charter, secures funding, removes organizational impediments that exceed the Project Manager's authority, and serves as the primary liaison between the project and the organization's executive leadership team. The Executive Sponsor engages directly with automated reporting through the Power Business Intelligence Executive Portfolio Overview dashboard page and receives automated escalation alerts from Power Automate when budget variances exceed twenty-five percent of the approved baseline or when critical risks reach a severity rating of five on a five-point scale.
Portfolio Manager
The Portfolio Manager is responsible for overseeing the strategic alignment, prioritization, and resource allocation of all projects within the organizational portfolio. This individual reviews the Power Business Intelligence Executive Portfolio Overview dashboard to monitor portfolio-level performance, approves the initiation of new projects based on strategic fit and capacity availability, and coordinates with the Project Management Office Director to resolve cross-project resource conflicts. The Portfolio Manager receives weekly automated digest reports generated by Power Automate summarizing the status of all active projects.
Project Steering Committee
The Project Steering Committee is a formal governance body composed of senior stakeholders representing the key business units and functions affected by the project. The Project Steering Committee reviews and approves milestone completion through the automated gate review process defined in Flow 6.4, provides strategic direction at formal review meetings, and resolves escalated issues that exceed the Project Manager's authority. Members of the Project Steering Committee receive automated milestone completion notifications and are required to provide formal digital approval or rejection responses through Teams adaptive card approvals.
Project Management Office Director
The Project Management Office Director leads the Project Management Office and is responsible for establishing, maintaining, and enforcing all project management standards, methodologies, templates, and governance processes across the organization. This individual owns this Reference Guide, approves all material deviations from standard process, and has oversight authority over all Power Platform configurations used in project management automation. The Project Management Office Director reviews the portfolio-level Power Business Intelligence dashboard weekly and participates in executive governance forums as the voice of project management standards.
Project Manager
The Project Manager is the individual assigned with the day-to-day responsibility for planning, executing, monitoring, controlling, and closing a specific project. The Project Manager is responsible for the overall success of the project within the constraints of scope, schedule, budget, quality, and stakeholder satisfaction. This individual is the primary user and consumer of all automated project management tools defined in this Reference Guide, receives all automated escalation notifications generated by Power Automate, reviews and approves all Copilot-generated drafts before formal publication, and is accountable for ensuring the accuracy of project data entered into SharePoint lists and Microsoft Planner.
Deputy Project Manager
The Deputy Project Manager supports the Project Manager in executing all project management responsibilities and acts as the designated substitute for the Project Manager in their absence. This individual is responsible for monitoring the completeness and accuracy of team member status update submissions, coordinating follow-up actions when automated reminders do not elicit responses, and managing the day-to-day administrative operations of the project site on SharePoint. The Deputy Project Manager has full access to all automated workflow dashboards and Power Business Intelligence reports applicable to the project.
Business Analyst
The Business Analyst is responsible for eliciting, documenting, and validating business and functional requirements; facilitating stakeholder workshops; translating organizational needs into actionable project scope; and supporting the development and review of the Work Breakdown Structure (the hierarchical decomposition of the total project scope into manageable components, hereinafter referred to as the "Work Breakdown Structure"). The Business Analyst contributes to Copilot-assisted charter drafting by providing structured stakeholder input summaries and is the primary author of the requirements documentation stored in the project SharePoint document library.
Technical Lead and Solution Architect
The Technical Lead and Solution Architect is responsible for defining the technical approach, solution design, and architectural standards for the project's technical deliverables. This individual reviews all technical scope items in the Work Breakdown Structure, identifies technical risks and dependencies, and approves technical deliverables at quality gates. The Technical Lead and Solution Architect is a required Consultant on all change requests with a technical impact classification and participates in the Change Control Board review process for technically complex changes.
Subject Matter Expert
The Subject Matter Expert is an individual with deep domain-specific knowledge who is engaged on a consultative basis to provide expert input into specific aspects of the project. Subject Matter Experts are assigned to specific tasks or review activities within Microsoft Planner and are included in automated notifications relevant to their area of expertise. Subject Matter Experts do not carry ongoing project management responsibilities but are expected to respond to consultation requests within the timeframes specified in the Communication Plan defined in Section 9 of this Reference Guide.
Project Team Member
Project Team Members are the individuals who perform the work of the project as defined in the Work Breakdown Structure and reflected in their task assignments in Microsoft Planner. Each Project Team Member is responsible for submitting accurate and timely weekly status updates through the automated collection process defined in Flow 6.1, maintaining the currency of their task completion percentages in Microsoft Planner, and logging risks or issues as they are identified in the SharePoint Risk Register and Issue Log. Project Team Members participate in project meetings, collaborate through the project Teams channels, and are expected to respond to all automated requests within the timeframes specified in the Communication Plan.
Quality Assurance Manager
The Quality Assurance Manager is responsible for establishing and enforcing the project's quality management plan as defined in Section 8 of this Reference Guide, conducting formal quality audits of project processes and deliverables, and approving deliverables at designated quality gates. This individual reviews quality-related data in the Power Business Intelligence dashboard, documents non-conformances in the Issue Log on SharePoint, and works with the Project Manager to implement corrective actions when quality standards are not met.
Risk Manager
The Risk Manager is responsible for overseeing the comprehensive identification, assessment, response planning, monitoring, and escalation of all project risks. This individual is the primary maintainer of the SharePoint Risk Register, receives immediate automated notifications for high-severity risk entries through Flow 6.2, and chairs the periodic risk review meetings. The Risk Manager reviews the Risk and Issue Management View in the Power Business Intelligence dashboard on a daily basis and is responsible for ensuring that all risk response actions are assigned, tracked, and completed within the defined timeframes.
Communications Manager
The Communications Manager is responsible for developing and executing the project communication plan defined in Section 9 of this Reference Guide, managing the onboarding of new stakeholders through the automated onboarding flow defined in Flow 6.6, and overseeing the content and distribution of all formal project communications. The Communications Manager works closely with Copilot to draft stakeholder communications, status reports, and project newsletters, and ensures that all communications are reviewed and approved before distribution.
Change Control Board Member
Change Control Board Members are senior representatives from the key project stakeholder groups who are collectively responsible for evaluating, deliberating upon, and rendering formal decisions on all change requests submitted to the project. Each Change Control Board Member participates in the automated digital voting process enabled by Flow 6.3, in which they receive a Teams adaptive card requesting their vote (Approve, Reject, or Defer) for each submitted change request. Change Control Board Members are expected to cast their votes within the timeframes defined in Section 11 of this Reference Guide.
Microsoft Power Platform Administrator
The Microsoft Power Platform Administrator is the technical specialist responsible for the configuration, deployment, maintenance, security, and governance of all Power Platform resources — including Power Automate flows, Power Business Intelligence workspaces and datasets, and Dataverse environments — used in support of this automated project management process. This individual is responsible for monitoring flow health, managing connector permissions, enforcing data loss prevention policies as defined in Section 14.5, and ensuring that all Power Platform resources comply with the organization's security and governance standards.
Microsoft Copilot Coordinator
The Microsoft Copilot Coordinator is responsible for the governance, configuration, and adoption of Copilot within the project management context. This individual maintains the approved prompt library defined in Appendix G, trains project personnel on effective and compliant use of Copilot, monitors Copilot usage for compliance with data privacy and data governance requirements defined in Section 5.8, and coordinates with the Microsoft Power Platform Administrator to ensure that Copilot's data grounding sources are accurate and appropriately permissioned.
Stakeholder Representative
Stakeholder Representatives are individuals who represent specific business units, customer groups, or functional areas that have a material interest in the outcome of the project. Stakeholder Representatives participate in formal review meetings, provide feedback on deliverables, and are engaged according to the stakeholder engagement strategy defined in Section 9.4. They are onboarded through the automated process defined in Flow 6.6 and receive communications tailored to their classification level and interests as documented in the Stakeholder Register.
Finance Controller
The Finance Controller is responsible for managing the project's financial controls, reviewing and approving budget expenditures, monitoring actual costs against the approved baseline, and receiving immediate automated alerts when budget variances exceed the thresholds defined in Flow 6.5. The Finance Controller reviews the budget-related data in the Power Business Intelligence dashboard, approves purchase orders and invoices through the automated procurement flow defined in Section 12.5, and provides financial reporting data to the Project Manager for inclusion in formal status reports.
Procurement Officer
The Procurement Officer is responsible for managing all vendor selection, contract execution, purchase order administration, and invoice processing activities associated with the project, as defined in Section 12 of this Reference Guide. This individual participates in the automated purchase order and invoice approval flows, maintains vendor performance data in the designated SharePoint list, and works with the Finance Controller to ensure that all procurement activities remain within approved financial thresholds and comply with organizational procurement policies.
2.2 RACI Matrix
The following RACI (Responsible, Accountable, Consulted, Informed) matrix defines the roles and responsibilities of each participant across the key deliverables and processes of this automated project management framework. The following codes apply throughout this matrix: R = Responsible (the individual who performs or leads the task), A = Accountable (the individual who is ultimately answerable for the correct and thorough completion of the task — there is only one Accountable party per row), C = Consulted (individuals whose input is sought; two-way communication), and I = Informed (individuals who are notified of outcomes; one-way communication).
| Process / Deliverable | Exec Sponsor | Portfolio Mgr | Steering Cmte | PMO Director | Project Manager | Deputy PM | Bus. Analyst | Tech Lead | QA Manager | Risk Manager | Comms Manager | CCB Member | PP Admin | Finance Controller | Procurement Officer |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Project Charter Approval | A | C | C | C | R | C | R | C | I | C | I | I | I | C | I |
| Project Management Plan | I | C | C | C | A | R | R | C | C | R | R | I | C | C | I |
| Risk Register Maintenance | I | I | I | I | A | C | C | C | C | R | I | I | I | I | I |
| Weekly Status Reporting | I | I | I | I | A | R | R | R | R | R | R | I | I | R | R |
| Change Request Processing | I | C | C | C | A | R | C | C | C | C | I | R | I | C | I |
| Budget Monitoring | I | I | I | I | A | C | I | I | I | I | I | I | I | R | R |
| Milestone Gate Review | C | I | R | C | A | R | C | C | R | C | I | I | I | I | I |
| Stakeholder Onboarding | I | I | I | I | A | C | I | I | I | I | R | I | C | I | I |
| Lessons Learned Facilitation | I | I | C | C | A | R | R | R | R | R | R | R | C | R | R |
| Project Closure and Archival | A | I | R | C | R | R | C | C | C | C | R | I | R | C | C |
| Power Platform Configuration | I | I | I | A | C | I | I | C | I | I | I | I | R | I | I |
| Quality Audit | I | I | I | C | A | C | C | C | R | C | I | I | I | I | I |
| Procurement and Vendor Mgmt | I | I | I | I | A | I | I | C | I | I | I | I | I | R | R |
Section 3: Complete Project Charter
The Project Charter is the formal document that officially authorizes the existence of the project and grants the Project Manager the authority to apply organizational resources to project activities. The following template defines the complete and required structure of all Project Charters issued under this process. All fields are mandatory unless explicitly marked as optional. The Project Charter must be drafted by the Project Manager, reviewed by the Business Analyst and Risk Manager, and formally approved by the Executive Sponsor, Project Steering Committee, Project Management Office Director, and Project Manager prior to the commencement of any planning activities.
3.1 Project Title and Unique Identifier
The Project Title is the official designation of the project as recognized throughout all project documentation, reporting systems, and organizational communications. The title must be clear, descriptive, and approved by the Project Management Office. The Project Unique Identifier is a system-generated alphanumeric code assigned automatically by the Power Automate project intake flow upon formal submission of the Project Charter for approval. This identifier serves as the primary key linking all project records across SharePoint, Planner, Dataverse, and Power Business Intelligence.
| Field | Value |
|---|---|
| Project Title | [Insert formal project title here] |
| Project Unique Identifier | [Auto-generated by Power Automate upon charter submission — e.g., PRJ-2026-0042] |
| Charter Version | [e.g., 1.0] |
| Charter Date | [Date of initial charter issuance] |
| Project Start Date (Proposed) | [Proposed commencement date] |
| Project End Date (Proposed) | [Proposed completion date] |
| Sponsoring Organization / Department | [Name of the organizational unit sponsoring the project] |
3.2 Project Purpose and Business Justification
This section must articulate the strategic rationale for undertaking the project, the organizational problem or opportunity being addressed, and the expected contribution of the project to one or more organizational objectives or key performance indicators (quantifiable measurements of organizational performance against defined targets, hereinafter referred to as "key performance indicators"). The Business Justification must reference the specific business case or strategic plan from which the project is derived, and must explain why this project is the preferred solution over identified alternatives.
| Field | Content |
|---|---|
| Business Problem or Opportunity Statement | [Describe in two to four sentences the specific problem or opportunity that this project addresses.] |
| Strategic Alignment | [Identify the organizational strategic goal, objective, or plan to which this project contributes.] |
| Expected Business Benefits | [List the quantified or qualifiable benefits expected upon project completion — e.g., cost reduction, revenue increase, compliance achievement, efficiency gain.] |
| Reference to Business Case or Strategic Plan | [Cite the document name, version, and date of the business case or plan that authorizes this project.] |
| Priority Classification | [High / Medium / Low — as assigned by the Portfolio Manager] |
3.3 Project Objectives (SMART Format)
All project objectives must be written in Specific, Measurable, Achievable, Relevant, and Time-bound (hereinafter referred to as "SMART") format, in accordance with the Project Management Institute's guidance on defining project success criteria. Each objective must identify a specific, quantifiable outcome, the metric by which success will be measured, the evidence that the objective is realistically achievable within the project's constraints, the connection of the objective to a business benefit, and the specific date by which the objective must be achieved. The Project Manager, in collaboration with the Business Analyst and key stakeholders, is responsible for drafting and validating all project objectives.
| Objective Number | Objective Statement | Metric | Target Value | Due Date | Strategic Linkage |
|---|---|---|---|---|---|
| OBJ-01 | [State the first specific project objective in full, formal language.] | [Define the specific measure used to evaluate success.] | [State the quantified target value.] | [State the specific date by which this objective must be met.] | [Identify the organizational goal to which this objective contributes.] |
| OBJ-02 | [State the second specific project objective.] | [Define the metric.] | [State the target value.] | [State the due date.] | [Identify the strategic linkage.] |
| OBJ-03 | [State additional objectives as required.] | [Define the metric.] | [State the target value.] | [State the due date.] | [Identify the strategic linkage.] |
3.4 Project Scope
3.4.1 In-Scope Items
The following items are formally included within the boundaries of this project and will be addressed through the project's Work Breakdown Structure, schedule, and budget. All in-scope items must be traceable to one or more project objectives defined in Section 3.3 above. The Project Manager is responsible for ensuring that the in-scope boundary is clearly communicated to all team members and stakeholders.
[In-scope item 1: Describe in full what is included, referencing the relevant project objective.]
[In-scope item 2: Describe in full what is included, referencing the relevant project objective.]
[In-scope item 3: Describe in full what is included, referencing the relevant project objective.]
[Add additional items as required.]
3.4.2 Out-of-Scope Items
The following items are formally excluded from the boundaries of this project and will not be addressed through the project's Work Breakdown Structure, schedule, or budget. Out-of-scope items are documented explicitly to prevent scope creep and to establish a clear baseline for change control purposes. Any request to include an out-of-scope item must be submitted as a formal change request through the process defined in Section 11 of this Reference Guide.
[Out-of-scope item 1: Describe clearly what is excluded and, where possible, explain why.]
[Out-of-scope item 2: Describe clearly what is excluded.]
[Out-of-scope item 3: Describe clearly what is excluded.]
[Add additional items as required.]
3.5 High-Level Deliverables and Milestones
The following table presents the high-level deliverables and key milestones of the project. This information is used to populate the initial project schedule in Microsoft Planner and the milestones view in the Power Business Intelligence dashboard. Each milestone represents a significant point in the project timeline and triggers the automated gate review process defined in Flow 6.4. All milestone dates are subject to revision through the formal change control process.
| Milestone Number | Milestone / Deliverable Name | Description | Target Completion Date | Phase | Approver |
|---|---|---|---|---|---|
| MS-01 | Project Charter Approved | The Project Charter has been formally signed by all required approvers and the project has been formally authorized. | [Date] | Initiating | Executive Sponsor |
| MS-02 | Project Management Plan Approved | The comprehensive Project Management Plan, including all subsidiary plans, has been approved and baselined. | [Date] | Planning | Project Manager / PMO Director |
| MS-03 | [Key Executing Milestone — e.g., Solution Design Complete] | [Describe the milestone deliverable and its significance.] | [Date] | Executing | [Responsible Approver] |
| MS-04 | [Second Executing Milestone — e.g., User Acceptance Testing Complete] | [Describe the milestone deliverable and its significance.] | [Date] | Executing | [Responsible Approver] |
| MS-05 | Project Formally Closed | All deliverables have been formally accepted, all contracts closed, lessons learned documented, and all project artifacts archived in accordance with Section 13 of this Reference Guide. | [Date] | Closing | Executive Sponsor |
3.6 Assumptions, Constraints, and Dependencies
3.6.1 Assumptions
Assumptions are factors that are considered to be true, real, or certain for the purposes of project planning, without proof. All assumptions carry inherent risk; if an assumption proves to be false, the project may be materially impacted. The Project Manager is responsible for validating assumptions throughout the project lifecycle and escalating any assumption that is invalidated through the risk management process.
[Assumption 1: State the assumption in full, formal language.]
[Assumption 2: State the assumption in full, formal language.]
[Add additional assumptions as required.]
3.6.2 Constraints
Constraints are binding limitations or restrictions that affect the planning and execution of the project. Constraints may relate to budget, schedule, resources, technology, regulatory requirements, or organizational policies. Unlike risks, constraints are known certainties that must be planned around rather than managed as probabilities.
[Constraint 1: State the constraint clearly, specifying its nature and its impact on the project.]
[Constraint 2: State the constraint clearly.]
[Add additional constraints as required.]
3.6.3 Dependencies
Dependencies are relationships between this project and other projects, programs, organizational activities, or external events upon which the project's ability to proceed depends. Dependencies must be tracked in the project schedule and monitored regularly to detect changes that could affect the project timeline or scope.
[Dependency 1: Describe the dependency, including the external project, event, or decision on which this project depends, and the nature and direction of the dependency.]
[Dependency 2: Describe the dependency.]
[Add additional dependencies as required.]
3.7 Risk Summary
This section provides a high-level summary of the most significant risks identified during the project initiation phase. A full risk assessment will be conducted during the planning phase, and all risks will be entered into the SharePoint Risk Register and actively monitored through the automated processes defined in Section 10 of this Reference Guide. The following table captures the initial risks identified at the time of charter development.
| Risk Identifier | Risk Description | Probability (1–5) | Impact (1–5) | Severity Score | Proposed Response Strategy | Risk Owner |
|---|---|---|---|---|---|---|
| RSK-001 | [Describe the risk in one to two sentences.] | [1–5] | [1–5] | [Probability × Impact] | [Avoid / Transfer / Mitigate / Accept / Escalate] | [Role Name] |
| RSK-002 | [Describe the risk.] | [1–5] | [1–5] | [Score] | [Strategy] | [Role Name] |
| RSK-003 | [Describe the risk.] | [1–5] | [1–5] | [Score] | [Strategy] | [Role Name] |
3.9 Stakeholder Register (Initial)
The following table presents the initial Stakeholder Register as developed during the project initiation phase. The full Stakeholder Register will be maintained as a living document in SharePoint throughout the project lifecycle and will be updated as new stakeholders are identified or as existing stakeholders' engagement levels, interests, or influence change. New stakeholders added to this register will trigger the automated onboarding process defined in Flow 6.6.
| Stakeholder Name | Role / Title | Organization | Classification | Interest Area | Influence Level | Current Engagement | Desired Engagement | Communication Preference |
|---|---|---|---|---|---|---|---|---|
| [Name] | [Role] | [Org] | [Internal / External] | [What they care about] | [High / Medium / Low] | [Unaware / Resistant / Neutral / Supportive / Leading] | [Target level] | [Email / Teams / Meeting] |
| [Name] | [Role] | [Org] | [Internal / External] | [Interest area] | [Influence] | [Engagement] | [Target] | [Preference] |
3.11 Sign-off and Approval Block
The formal execution of this Project Charter by the individuals identified below constitutes their official authorization of the project as described in this document and their agreement to provide the resources, governance, and support necessary for project success. Digital signatures collected through the automated approval flow in Microsoft Teams are legally equivalent to handwritten signatures for the purposes of this document.
| Role | Printed Name | Signature | Date of Approval |
|---|---|---|---|
| Executive Sponsor | |||
| Project Steering Committee Chairperson | |||
| Project Management Office Director | |||
| Project Manager |
Section 4: Project Management Institute Best Practice Workflow
This section describes the complete project management lifecycle as implemented under this Reference Guide, aligned to the Project Management Body of Knowledge Seventh Edition framework. The Project Management Body of Knowledge Seventh Edition defines project management through eight performance domains and twelve guiding principles, which together provide a comprehensive, flexible foundation for delivering value across diverse project environments. Each subsection below describes the entry criteria, key activities, responsible roles, deliverables, exit criteria, and quality gates applicable to each phase and performance domain.
4.1 Initiating Phase
Entry Criteria: A formal business case or strategic directive has been approved by the Portfolio Manager, and the project has been placed in the project intake queue on the Project Management Office SharePoint site. Sufficient budget authority exists to fund at minimum the planning phase, and an Executive Sponsor has been identified and has agreed to fulfill the role as defined in Section 2.1 of this Reference Guide.
Key Activities: During the Initiating Phase, the Project Manager drafts the Project Charter using the template defined in Section 3, leveraging Copilot to analyze stakeholder inputs, summarize the business case, and generate an initial risk register. The Business Analyst conducts stakeholder identification workshops, and the Risk Manager performs an initial risk screening. The Communications Manager develops the preliminary stakeholder register. The Power Automate project intake flow assigns the project its unique identifier and creates the project SharePoint site, Teams environment, and initial Planner board.
Responsible Roles: Executive Sponsor (accountable), Project Manager (responsible for charter), Business Analyst (responsible for stakeholder identification), Risk Manager (responsible for initial risk screening), Communications Manager (responsible for stakeholder register), Microsoft Power Platform Administrator (responsible for project site provisioning).
Deliverables Produced: Approved Project Charter, initial Stakeholder Register, initial Risk Register, provisioned SharePoint project site, provisioned Teams environment, provisioned Planner board.
Exit Criteria: The Project Charter has been formally approved and digitally signed by all parties identified in Section 3.11. The project unique identifier has been assigned and is active in the Project Registry SharePoint list. The project SharePoint site, Teams channels, and Planner board have been provisioned and are accessible to all assigned team members.
Quality Gate — Gate 1 (Charter Approval): The Quality Assurance Manager reviews the Project Charter against the mandatory template requirements defined in Section 3 and confirms that all mandatory fields are complete, all objectives are written in Specific, Measurable, Achievable, Relevant, Time-bound format, all required signatories have approved, and the project unique identifier has been properly registered. Gate 1 is formally passed only upon the Quality Assurance Manager's documented concurrence.
4.2 Planning Phase
Entry Criteria: Gate 1 has been formally passed. The approved Project Charter is accessible on the project SharePoint site. The Project Manager has been formally assigned and has accepted their role. The project Teams environment is active and all team members have been granted access.
Key Activities: The Planning Phase is the most documentation-intensive phase of the project lifecycle and results in the creation of the comprehensive Project Management Plan. During this phase, Copilot assists the Project Manager and Business Analyst in generating the Work Breakdown Structure, drafting the project schedule, producing the Communication Plan, and structuring the Risk Management Plan. The Work Breakdown Structure is populated into Microsoft Planner as a structured task hierarchy. The project schedule is developed using rolling wave planning — a technique in which near-term work is planned in detail while future work is planned at a higher level, with detail added progressively as the project advances — to accommodate uncertainty in later phases. The Finance Controller reviews and baselines the budget plan, and the Risk Manager completes the full risk assessment for all identified risks.
Responsible Roles: Project Manager (accountable and responsible for Project Management Plan), Business Analyst (responsible for requirements documentation and Work Breakdown Structure), Risk Manager (responsible for Risk Management Plan), Quality Assurance Manager (responsible for Quality Management Plan), Communications Manager (responsible for Communication Plan), Finance Controller (responsible for budget baseline), Technical Lead and Solution Architect (responsible for technical approach documentation).
Deliverables Produced: Project Management Plan (inclusive of all subsidiary plans: Scope Management Plan, Schedule Management Plan, Cost Management Plan, Quality Management Plan, Resource Management Plan, Communication Plan, Risk Management Plan, Procurement Management Plan, Stakeholder Engagement Plan), Work Breakdown Structure, Project Schedule Baseline, Cost Baseline, Risk Register (full), Stakeholder Engagement Plan.
Exit Criteria: The Project Management Plan and all subsidiary plans have been reviewed by the Quality Assurance Manager, approved by the Project Manager, and endorsed by the Project Steering Committee. All baseline documents — schedule, cost, scope — have been locked in SharePoint and are protected against uncontrolled modification.
Quality Gate — Gate 2 (Planning Baseline Approval): The Quality Assurance Manager reviews all subsidiary plans for completeness against defined templates. The Project Management Office Director confirms alignment with organizational methodology standards. The Finance Controller confirms budget baseline accuracy. Only upon documented approval from all three reviewers does Gate 2 pass and execution activities commence.
4.3 Executing Phase
Entry Criteria: Gate 2 has been formally passed. All required resources — including personnel, technology licenses, and vendor contracts — have been confirmed as available and are ready to support the commencement of execution activities. The project schedule, as reflected in Microsoft Planner, is populated with all tasks and assignments for at minimum the first planning horizon.
Key Activities: During the Executing Phase, Project Team Members perform the work of the project as defined in the Work Breakdown Structure and tracked in Microsoft Planner. The Project Manager directs and manages project work, conducts regular team meetings in Teams, and uses Copilot to summarize meeting transcripts and extract action items for automatic creation in Planner. The Communications Manager executes the Communication Plan, including automated weekly status reports generated through the Power Automate flow defined in Section 6.1. The Quality Assurance Manager conducts ongoing quality assurance activities as defined in Section 8.2. The Risk Manager monitors the Risk Register and responds to automated alerts generated by Flow 6.2.
Responsible Roles: Project Manager (accountable), all Project Team Members (responsible for assigned tasks), Quality Assurance Manager (responsible for quality assurance), Risk Manager (responsible for risk monitoring), Communications Manager (responsible for communication execution), Deputy Project Manager (responsible for day-to-day administrative management).
Deliverables Produced: Completed Work Breakdown Structure deliverables (as defined in the project-specific Work Breakdown Structure), Quality Assurance audit reports, weekly Status Reports, meeting records and action item logs, updated Risk Register, updated Issue Log.
Exit Criteria: All Work Breakdown Structure deliverables for the Executing Phase have been completed, reviewed, and accepted by the designated approvers. All open issues and risks have been assessed and have active response plans. All milestone deliverables due within this phase have been completed and have passed Gate 3.
Quality Gate — Gate 3 (Executing Phase Milestones): For each milestone within the Executing Phase, the automated gate review process defined in Flow 6.4 is triggered. The Project Steering Committee reviews the gate review package and provides formal digital approval or rejection via Teams adaptive card. The Quality Assurance Manager must confirm the deliverable has passed all applicable quality control checks before the gate review package is transmitted to the Steering Committee.
4.4 Monitoring and Controlling Phase
Entry Criteria: The Executing Phase has commenced and project performance data is being generated. The Power Business Intelligence dashboard is populated with at minimum one full cycle of status data, and the project schedule and budget baselines are active and locked.
Key Activities: The Monitoring and Controlling Phase runs concurrently with the Executing Phase throughout the project lifecycle. The Project Manager and Deputy Project Manager review the Power Business Intelligence dashboard on a daily basis to monitor Schedule Performance Index (the ratio of Earned Value to Planned Value, indicating schedule efficiency, hereinafter referred to as the "Schedule Performance Index") and Cost Performance Index (the ratio of Earned Value to Actual Cost, indicating cost efficiency, hereinafter referred to as the "Cost Performance Index") trends. Copilot analyzes project performance data to identify variances and recommend corrective actions. Automated Power Automate flows alert the appropriate roles when thresholds are breached. The Change Control Board reviews and decides upon all submitted change requests through the automated process defined in Flow 6.3. The Risk Manager reviews and updates the Risk Register on a weekly basis.
Responsible Roles: Project Manager (accountable), Deputy Project Manager (responsible for daily monitoring), Risk Manager (responsible for risk monitoring), Finance Controller (responsible for budget monitoring), Quality Assurance Manager (responsible for quality control), Change Control Board (responsible for change decisions).
Deliverables Produced: Performance reports, Earned Value Analysis (a methodology that integrates scope, schedule, and cost performance data to provide a comprehensive picture of project performance, hereinafter referred to as "Earned Value Analysis") reports, corrective and preventive action records, approved or rejected Change Requests, updated project baselines (where changes are approved), variance analysis reports.
Exit Criteria: All project deliverables have been completed and accepted, all open Change Requests have been resolved, and the project is ready to transition to formal closure. The Schedule Performance Index and Cost Performance Index values are within acceptable thresholds, or documented corrective actions have been implemented and are producing the expected improvement.
Quality Gate — Gate 4 (Pre-Closing Readiness Review): The Project Manager, Quality Assurance Manager, and Finance Controller jointly confirm that all deliverables have been formally accepted, all change requests are closed, all invoices have been processed, and all outstanding risks and issues have been resolved or formally accepted. Only upon this joint confirmation does the project advance to the Closing Phase.
4.5 Closing Phase
Entry Criteria: Gate 4 has been formally passed. The customer or authorizing entity has formally accepted all project deliverables. The project status has been updated to "Closing" in the Project Registry SharePoint list, which triggers the automated Lessons Learned Collection Flow defined in Flow 6.7.
Key Activities: During the Closing Phase, the Project Manager coordinates the formal acceptance of all deliverables, closes all vendor contracts, facilitates the lessons learned process, and ensures the orderly transition of project outputs to the operations team. Copilot generates the draft lessons learned document and the project closure report based on the consolidated lessons learned survey responses and project performance data. All project documents are archived in the designated SharePoint archive folder. The project site is set to read-only and remains accessible for reference purposes in accordance with the retention policy defined in Section 13.5.
Responsible Roles: Executive Sponsor (accountable for formal closure), Project Manager (responsible for closure activities), Procurement Officer (responsible for contract closeout), Communications Manager (responsible for final stakeholder communications), Microsoft Power Platform Administrator (responsible for archiving Power Platform resources).
Deliverables Produced: Final Project Closure Report, Lessons Learned Register, Benefits Realization Report, archived project document library, final Stakeholder Register, archived Planner board.
Exit Criteria: The Executive Sponsor has formally signed the Project Closure Report. All project documents are archived. All contracts are closed. The project status in the Project Registry has been updated to "Closed." Power Automate flows specific to this project have been deactivated by the Microsoft Power Platform Administrator.
Quality Gate — Gate 5 (Formal Project Closure): The Project Management Office Director reviews the Project Closure Report and Lessons Learned Register for completeness. The Finance Controller confirms all financial obligations have been settled. The Executive Sponsor provides final digital approval of the project closure. Only upon the Executive Sponsor's approval is the project formally closed.
4.6 Stakeholder Performance Domain
The Stakeholder Performance Domain encompasses all activities and functions associated with identifying, analyzing, and engaging project stakeholders effectively throughout the project lifecycle. Effective stakeholder engagement is a critical determinant of project success, as stakeholders who are insufficiently engaged or whose interests are inadequately addressed can withhold support, introduce obstacles, or actively oppose project activities. This domain recognizes that stakeholder engagement is not a one-time activity confined to the initiating phase but a continuous, adaptive process that evolves as stakeholder interests, influence levels, and engagement states change over time.
Under this automated project management process, stakeholder engagement activities are systematically supported through the automated onboarding flow defined in Flow 6.6, the communication delivery mechanisms defined in Section 9, and the Stakeholder Engagement Classification model defined in Section 9.4. The Communications Manager is the primary role responsible for this performance domain and works in conjunction with Copilot to draft tailored stakeholder communications that reflect the individual interests, influence levels, and preferred communication channels of each stakeholder. Stakeholder engagement assessments are conducted at each gate review and updated in the Stakeholder Register accordingly.
4.7 Team Performance Domain
The Team Performance Domain addresses the activities and functions associated with establishing an effective, collaborative, and high-performing project team. This domain encompasses team development from the initial forming of the team through the norming, performing, and adjourning stages described in Tuckman's model of team development. It includes establishing a shared team culture, clarifying individual roles and responsibilities, providing development opportunities, addressing performance issues, and managing conflict constructively and professionally.
Under this automated process, team health is monitored indirectly through the Resource and Team Utilization dashboard page in Power Business Intelligence, which tracks individual workload, utilization rates, and overtime alerts. The Project Manager uses this data to identify and address capacity imbalances, prevent burnout, and ensure equitable work distribution. Conflict resolution follows a structured escalation path: the Project Manager first attempts to resolve conflict through direct facilitation; if unresolved, the matter is escalated to the Project Steering Committee and, if necessary, to the Executive Sponsor for final resolution.
4.8 Development Approach and Life Cycle Performance Domain
The Development Approach and Life Cycle Performance Domain addresses the selection and tailoring of the project life cycle — predictive, agile, or hybrid — best suited to the nature, complexity, and uncertainty of the specific project. A predictive (also known as "waterfall") approach is appropriate for projects with well-defined, stable requirements, high certainty, and a clear understanding of the solution, where scope is defined comprehensively upfront and work proceeds sequentially through planned phases. An agile approach is appropriate for projects with high uncertainty, evolving requirements, or where early and continuous delivery of value is prioritized, using iterative cycles (called "sprints" or "iterations") of planning, execution, and review. A hybrid approach combines elements of both, typically using predictive methods for governance and overall schedule management while using agile methods for specific delivery components.
Under this Reference Guide, the development approach for each project is formally selected during the Initiating Phase and documented in the Project Charter. The choice of approach directly determines how the project schedule is structured in Microsoft Planner — sequentially for predictive approaches, or in sprint cycles for agile approaches — and how status reporting, milestone gates, and quality reviews are configured. The Microsoft Power Platform Administrator is responsible for configuring the appropriate Planner board structure and Power Automate flow triggers to reflect the chosen development approach.
4.9 Planning Performance Domain
The Planning Performance Domain addresses the activities and functions associated with the initial and ongoing organization, elaboration, and coordination of the work required to deliver the project's outcomes. Planning under the Project Management Body of Knowledge Seventh Edition is explicitly recognized as a continuous, iterative process rather than a single, front-loaded event. Rolling wave planning — the technique of planning near-term work in comprehensive detail while planning future work at a higher level of abstraction, progressively elaborating the plan as more information becomes available — is the preferred planning approach for all projects governed by this Reference Guide.
Under this automated process, planning activities are supported by Copilot's ability to generate initial Work Breakdown Structure drafts, project schedule structures, and communication plan templates based on the approved Project Charter and requirements documentation. These Copilot-generated drafts are reviewed, validated, and refined by the Project Manager and relevant subject matter experts before being approved and baselined. All planning artifacts are version-controlled in the project SharePoint document library, and any post-baseline changes must pass through the change control process defined in Section 11.
4.10 Project Work Performance Domain
The Project Work Performance Domain addresses the activities and functions associated with establishing project processes, managing the physical resources of the project, fostering a learning environment, and coordinating ongoing project work to produce the intended deliverables. This domain encompasses the day-to-day operational management of the project, including directing and managing project work, managing project knowledge, monitoring work performance, and implementing approved changes and corrective actions.
Under this automated process, the Project Work Performance Domain is supported by the weekly status collection flow defined in Flow 6.1, which ensures a consistent, automated mechanism for gathering work performance data from all Project Team Members. The action item tracking flow defined in Flow 6.8 ensures that all commitments made in project meetings are captured, assigned, and followed up automatically. The Project Manager reviews consolidated work performance data through the Power Business Intelligence Individual Project Health Dashboard each week and uses this data to make informed decisions about resource reallocation, scope prioritization, and corrective action implementation.
4.11 Delivery Performance Domain
The Delivery Performance Domain addresses the activities and functions associated with delivering the scope and quality of the project that meet stakeholder expectations and create the intended value. This domain emphasizes that delivery is not merely the production of outputs (tangible artifacts or products) but the creation of outcomes (changes in behavior or capability) and ultimately the realization of benefits (improvements to organizational performance) that justify the investment in the project. Effective delivery requires maintaining clear traceability from business objectives through deliverables to benefits throughout the project lifecycle.
Under this automated process, the Delivery Performance Domain is supported by the milestone gate review mechanism defined in Flow 6.4, which provides structured checkpoints at which the Project Steering Committee formally evaluates whether completed deliverables meet the acceptance criteria defined in the Project Charter and subsidiary plans. Deliverable acceptance records are stored in SharePoint and are incorporated into the Power Business Intelligence Work Breakdown Structure completion percentage metric. The Benefits Realization Report produced during the Closing Phase, as described in Section 13.4, formally documents the extent to which the intended benefits have been realized or are on track for realization post-project.
4.12 Measurement Performance Domain
The Measurement Performance Domain addresses the activities and functions associated with assessing project performance and implementing appropriate responses to maintain optimal performance. Effective measurement in the context of the Project Management Body of Knowledge Seventh Edition requires identifying the right metrics, collecting accurate and timely data, analyzing data to understand what is happening and why, communicating findings to the right audiences, and using insights to drive informed decisions and corrective actions. Measurement must be purposeful — metrics should be selected because they provide actionable insight, not merely because they are easy to collect.
The primary performance metrics used under this automated process are those of Earned Value Analysis, including Planned Value (the authorized budget assigned to work scheduled to be accomplished at a given point in time), Earned Value (the authorized budget associated with work that has actually been accomplished), Actual Cost (the realized cost incurred for work accomplished on the project), Schedule Variance (Earned Value minus Planned Value — a positive value indicates ahead of schedule; a negative value indicates behind schedule), Cost Variance (Earned Value minus Actual Cost — a positive value indicates under budget; a negative value indicates over budget), Schedule Performance Index, Cost Performance Index, Estimate at Completion (the expected total cost of completing all project work, calculated as Actual Cost plus the Estimate to Complete — the expected cost needed to finish all the remaining project work), and Variance at Completion (the difference between the Budget at Completion — the total approved budget for the project — and the Estimate at Completion). These metrics are calculated automatically by Power Business Intelligence from the data collected through the automated status collection and budget tracking flows and are displayed on the Individual Project Health Dashboard described in Section 7.3.
4.13 Uncertainty Performance Domain
The Uncertainty Performance Domain addresses the activities and functions associated with navigating risk, ambiguity, complexity, and volatility throughout the project lifecycle. The Project Management Body of Knowledge Seventh Edition defines uncertainty not merely as risk — the possibility of an event occurring that has an effect on the project — but as a broader category that includes ambiguity (the lack of clarity about requirements, solutions, or the project environment), complexity (the result of human behavior, system interactions, and ambiguity that make projects difficult to manage using linear, reductionist approaches), and volatility (the speed and unpredictability of change in the project environment).
Under this automated process, the Uncertainty Performance Domain is addressed through the comprehensive risk management framework defined in Section 10, the automated risk escalation flows defined in Flow 6.2, the real-time risk monitoring capabilities of the Power Business Intelligence Risk and Issue Management View, and the adaptive planning techniques — including rolling wave planning and the maintenance of contingency reserves — embedded throughout this Reference Guide. The Risk Manager is the primary role responsible for this performance domain, supported by all Project Team Members who are required to log risks and issues as they are identified and to participate in periodic risk reviews.
4.14 The Twelve Guiding Principles of the Project Management Body of Knowledge Seventh Edition
The following twelve guiding principles, as established in the Project Management Body of Knowledge Seventh Edition, are embedded throughout all processes, governance structures, and automated workflows defined in this Reference Guide. Each principle is described below, along with an explanation of how it is operationalized within this automated project management process.
Principle 1: Be a Diligent, Respectful, and Caring Steward
This principle calls for project professionals to act as responsible stewards of organizational resources — including financial assets, human capital, technology, and environmental resources — by making decisions that reflect integrity, care, and trustworthiness. Stewardship extends beyond mere compliance with rules to an active commitment to the well-being of the team, the organization, and the broader community. Under this process, this principle is embedded in the mandatory financial threshold controls defined in Section 3.8, the ethical procurement standards defined in Section 12, the data governance requirements defined in Section 14.3, and the data loss prevention policies defined in Section 14.5, which together ensure that organizational resources are used responsibly and that all project decisions are made with transparency and accountability.
Principle 2: Create a Collaborative Project Team Environment
This principle recognizes that successful project outcomes depend on the ability of diverse project team members to collaborate effectively, share knowledge, and contribute their unique skills and perspectives toward common goals. A collaborative team environment is one in which psychological safety is maintained, communication is open and respectful, individual contributions are valued, and team members are empowered to make decisions within their areas of responsibility. Under this process, this principle is embedded in the structured Microsoft Teams channel environment defined in Section 9.5, the action item tracking flow defined in Flow 6.8 — which ensures that all team members' commitments are visible and respected — and the team utilization monitoring capabilities of the Power Business Intelligence dashboard defined in Section 7.3, which enables the Project Manager to identify and address capacity imbalances before they impair team health.
Principle 3: Effectively Engage with Stakeholders
This principle requires that project professionals proactively engage with all stakeholders — both those who may positively and negatively impact the project — to understand their interests, needs, and expectations, and to develop and execute strategies that build and maintain productive relationships throughout the project lifecycle. Stakeholder engagement is recognized as a continuous, adaptive activity rather than a one-time event. Under this process, this principle is operationalized through the automated stakeholder onboarding flow defined in Flow 6.6, the Communication Matrix defined in Section 9.1, the stakeholder engagement classification model defined in Section 9.4, and the Copilot-assisted communication drafting capabilities described in Section 5, which together ensure that stakeholder communications are timely, relevant, and appropriately tailored to each stakeholder's interests and preferred communication channels.
Principle 4: Focus on Value
This principle places the delivery of value — the net positive benefit realized by the organization as a result of the project — at the center of all project decision-making. Value may be financial, social, environmental, strategic, or operational in nature, and it must be defined, measured, and actively pursued throughout the project lifecycle, not merely assumed to materialize upon the completion of planned deliverables. Under this process, this principle is embedded in the requirement that all project objectives be written in Specific, Measurable, Achievable, Relevant, and Time-bound format in Section 3.3 — ensuring that value is quantified and measurable — and in the Benefits Realization Report produced during project closure as described in Section 13.4, which formally documents the extent to which intended value has been delivered.
Principle 5: Recognize, Evaluate, and Respond to System Interactions
This principle acknowledges that projects do not exist in isolation but operate within complex organizational, technological, and environmental systems. Changes in one part of the system frequently produce intended and unintended effects in other parts. Project professionals must develop and maintain a systemic perspective — understanding how the project interacts with and is affected by its broader context — and must be prepared to recognize, evaluate, and respond to emergent system interactions as they arise. Under this process, this principle is embedded in the integration architecture overview defined in Section 1.3, which explicitly maps the interdependencies among all automated tools, and in the dependency management requirements defined in Section 3.6.3 of the Project Charter template, which ensure that cross-system dependencies are identified and monitored throughout the project lifecycle.
Principle 6: Demonstrate Leadership Behaviors
This principle holds that effective project management is fundamentally a leadership activity, and that all project participants — not only the Project Manager — are expected to demonstrate leadership behaviors appropriate to their roles. Leadership in the context of the Project Management Body of Knowledge Seventh Edition encompasses vision setting, motivation, influence, conflict resolution, decision-making, and the ability to adapt one's leadership style to the needs of the team and the demands of the situation. Under this process, this principle is embedded in the role definitions in Section 2, which explicitly describe the leadership responsibilities of each role, and in the escalation structures defined in Section 9.3, which ensure that leadership is exercised at the appropriate level when situations require decisions beyond the scope of individual roles.
Principle 7: Tailor Based on Context
This principle requires that project management approaches, tools, processes, and practices be intentionally selected and adapted to fit the unique characteristics of each project — including its size, complexity, uncertainty, stakeholder environment, regulatory context, and development approach — rather than applied as rigid, one-size-fits-all prescriptions. Tailoring must be thoughtful, deliberate, and documented. Under this process, this principle is embedded in the Development Approach and Life Cycle Performance Domain guidance in Section 4.8, which defines how the development approach is selected during initiation, and in the Microsoft Power Platform Administrator's responsibility to configure the Planner board structure, Power Automate flow triggers, and Power Business Intelligence data model to reflect the specific characteristics of each project.
Principle 8: Build Quality into Processes and Deliverables
This principle requires that quality be embedded into all project processes and deliverables from the outset, rather than inspected in after the fact. Quality is both a process characteristic — reflecting the degree to which project management activities are performed consistently, correctly, and in compliance with defined standards — and a product characteristic — reflecting the degree to which deliverables meet their defined acceptance criteria and stakeholder expectations. Under this process, this principle is embedded in the Quality Management Plan defined in Section 8, the quality gates defined at each phase in this section, the Quality Assurance Manager's role in reviewing all deliverables before milestone gate reviews, and the automated non-conformance tracking capabilities of the Power Business Intelligence dashboard.
Principle 10: Optimize Risk Responses
This principle requires that project professionals actively identify, assess, and respond to both threats (negative risks) and opportunities (positive risks) in a manner that optimizes overall project outcomes. Risk management must be proactive, ongoing, and integrated into all project decision-making activities, rather than treated as a periodic administrative exercise. Under this process, this principle is operationalized through the comprehensive Risk Management Framework defined in Section 10, the automated risk escalation flows defined in Flow 6.2, the Risk and Issue Management View in the Power Business Intelligence dashboard described in Section 7.3, and the automated risk digest notifications sent to the Risk Manager and Project Manager every Friday at 4:00 in the afternoon Eastern Daylight Time.
Principle 11: Embrace Adaptability and Resiliency
This principle calls for project professionals to build adaptability and resiliency into all aspects of the project, so that the project can absorb disruptions, adjust to changes in the environment, and continue to make progress toward its goals even when unexpected events occur. Adaptability refers to the capacity to respond effectively to change; resiliency refers to the capacity to recover from setbacks and continue functioning under stress. Under this process, this principle is embedded in the change control process defined in Section 11, which provides a structured but efficient mechanism for incorporating necessary changes into the project baseline; in the contingency reserve requirements defined in Section 3.8; and in the hybrid development approach option defined in Section 4.8, which enables teams to adopt iterative practices where they provide the greatest resilience benefit.
Principle 12: Enable Change to Achieve the Envisioned Future State
This principle recognizes that projects are fundamentally change initiatives, and that successful project delivery requires not only the technical completion of deliverables but also the active management of the organizational change that those deliverables create. Stakeholders must be prepared to adopt new ways of working, and the project team must actively support that adoption through communication, training, and engagement. Under this process, this principle is embedded in the Stakeholder Engagement Plan required as part of the Project Management Plan, the Communication Plan defined in Section 9, the formal transition to operations process defined in Section 13.6, and the Benefits Realization Report defined in Section 13.4, which collectively ensure that the project's outcomes are effectively embedded into the organization's ongoing operations and that the intended change is sustained beyond the project's formal closure.
Section 5: Microsoft Copilot Integration
Microsoft Copilot is an artificial intelligence assistant embedded throughout the Microsoft 365 and Power Platform ecosystems that leverages large language model technology — machine learning models trained on large volumes of text data to understand and generate human language — to assist project personnel with a wide range of cognitive tasks, including drafting, summarizing, analyzing, translating, and querying data. Copilot operates within the security and compliance boundary of the organization's Microsoft 365 tenant, meaning that all data processed by Copilot remains within the organization's data environment and is governed by the organization's data governance, data loss prevention, and access control policies. Copilot does not train its underlying language models on organizational data.
The use of Copilot under this Reference Guide is governed by the standards and requirements defined in Section 5.8. All Copilot-generated content is treated as a draft that requires human review, validation, and approval before it is used for any official project purpose. The Microsoft Copilot Coordinator is responsible for maintaining the approved prompt library defined in Appendix G and for training all project personnel in the effective and compliant use of Copilot.
5.1 Copilot in the Initiating Phase
During the Initiating Phase, Copilot is used primarily to accelerate the drafting of foundational project documents and to synthesize stakeholder input into structured, actionable formats. The Project Manager uses Copilot in Microsoft Word to generate an initial draft of the Project Charter based on the approved business case and the Project Charter template defined in Section 3. Copilot analyzes the business case document and prompts the Project Manager with questions to fill any identified gaps in the charter's mandatory fields, reducing the time required to produce a complete first draft from hours to minutes while ensuring comprehensive coverage of all required content areas.
Copilot in Microsoft Teams is used during the initial stakeholder identification workshops to generate real-time summaries of meeting discussions, capturing key stakeholder interests, concerns, and requirements as they are articulated. These summaries are saved to the project SharePoint site and reviewed by the Business Analyst for accuracy before being incorporated into the Stakeholder Register. Additionally, Copilot in SharePoint is used to generate an initial risk register by analyzing the Project Charter, business case, and any prior related project documentation, identifying potential risk themes and drafting initial risk descriptions for review by the Risk Manager. This Copilot-assisted risk identification process ensures that the initial risk register is comprehensive and that no major risk categories are overlooked.
5.2 Copilot in the Planning Phase
During the Planning Phase, Copilot's document generation capabilities are used extensively to produce the subsidiary plans that comprise the Project Management Plan. Using the approved Project Charter and requirements documentation as input, Copilot generates initial drafts of the Work Breakdown Structure, project schedule structure, Communication Plan, and Risk Management Plan. The Project Manager and relevant subject matter experts review, refine, and validate each of these Copilot-generated drafts before they are finalized and baselined. Copilot's ability to generate comprehensive first drafts significantly accelerates the planning process while ensuring that all mandatory plan components are addressed.
Copilot in Microsoft Planner — accessed through the Teams interface — assists the Project Manager in decomposing the Work Breakdown Structure into specific tasks, assigning estimated durations, identifying dependencies, and organizing tasks into a logical sequence. Copilot can also suggest resource assignments based on team member skill profiles documented in Dataverse. Additionally, Copilot generates the Communication Plan by analyzing the Stakeholder Register and proposing tailored communication strategies, frequencies, and channels for each stakeholder group, which the Communications Manager then refines to reflect organizational norms and stakeholder preferences.
5.3 Copilot in the Executing Phase
During the Executing Phase, Copilot's meeting intelligence capabilities — specifically, the ability to generate post-meeting summaries, extract action items, and identify key decisions from Microsoft Teams meeting transcripts — are among its most valuable and frequently used features. At the conclusion of every project meeting conducted in Teams, Copilot automatically generates a structured meeting summary that includes a brief narrative overview of the topics discussed, a bulleted list of all action items identified (with proposed owners and due dates), a list of decisions made, and a list of open questions requiring follow-up. The Project Manager reviews this summary for accuracy and, upon approval, it is saved to the project SharePoint site. The confirmed action items are then automatically created as tasks in Microsoft Planner through the action item tracking flow defined in Flow 6.8.
Copilot is also used during the Executing Phase to draft weekly project status reports. The Deputy Project Manager provides Copilot with the current week's status data — consolidated from the automated status collection flow defined in Flow 6.1 — and prompts Copilot to generate a formal, professional status report in the organization's standard format. Copilot produces a draft that includes narrative summaries of schedule status, budget status, risk status, and key accomplishments, which the Project Manager reviews and finalizes before distribution to stakeholders in accordance with the Communication Plan.
5.4 Copilot in the Monitoring and Controlling Phase
During the Monitoring and Controlling Phase, Copilot's data analysis capabilities — particularly its integration with Power Business Intelligence — are used to provide the Project Manager with intelligent, contextualized insights about project performance. Using natural language queries within Power Business Intelligence, the Project Manager can ask questions such as "Which tasks are most at risk of causing a schedule delay?" or "What is the projected Estimate at Completion if the current Cost Performance Index trend continues?" and receive immediate, data-grounded responses. Copilot in Power Business Intelligence analyzes the project's Earned Value Analysis metrics, schedule status, risk register, and budget actuals to generate these insights, and can automatically produce narrative explanations of anomalies or trends detected in the project data.
When the Power Business Intelligence dashboard or automated Power Automate flows identify a performance variance that exceeds defined thresholds, Copilot is used to assist the Project Manager in drafting corrective action recommendations. The Project Manager provides Copilot with the performance data and the nature of the variance, and Copilot generates a set of potential corrective actions, with pros and cons for each option, that the Project Manager can use as a starting point for decision-making. All Copilot-generated corrective action recommendations require human review and explicit approval before implementation.
5.5 Copilot in the Closing Phase
During the Closing Phase, Copilot's document generation capabilities are used to produce the project's closing documentation efficiently and comprehensively. Upon the triggering of the Lessons Learned Collection Flow defined in Flow 6.7, Copilot analyzes the consolidated lessons learned survey responses from all project participants and generates a structured, thematically organized lessons learned document that identifies recurring themes, highlights the most impactful lessons, and proposes specific process improvements for consideration in future projects. The Project Manager reviews this Copilot-generated document and adds their own qualitative assessment before it is finalized and stored in the Lessons Learned Register on SharePoint.
Copilot is also used to generate the Project Closure Report, which provides a comprehensive retrospective assessment of the project's performance against its original objectives, scope, schedule, budget, and quality targets. Copilot produces this report by analyzing the project's performance data from Power Business Intelligence, the approved Project Charter objectives, and the final status records in SharePoint. The Project Manager refines the Copilot-generated draft with qualitative context and lessons learned before presenting the final report to the Executive Sponsor for formal approval. Additionally, Copilot generates a summary of all formal deliverable acceptance records, consolidated from the individual acceptance records stored in SharePoint throughout the project lifecycle, for inclusion in the closure documentation package.
5.6 Copilot in Microsoft Power Automate
Copilot in Power Automate enables the Microsoft Power Platform Administrator and project team members to create, describe, and troubleshoot automated workflows using natural language rather than requiring deep technical expertise in Power Automate's visual interface. Using the "Describe your flow" feature, an administrator can describe the desired automation behavior in plain English — for example, "When a new item is added to the Risk Register list in SharePoint, if the severity rating is four or five, send a Teams message to the Risk Manager and Project Manager" — and Copilot will generate a draft Power Automate flow implementing that behavior, which the administrator then reviews, validates, and refines before activating.
Additionally, Copilot in Power Automate is used to generate comprehensive documentation for each automated flow — including a plain-language description of the flow's purpose, trigger, logic, actions, and error handling behavior — which is stored in the Microsoft Power Platform Administrator's documentation library in SharePoint. This documentation is essential for the ongoing maintenance and governance of the automated flows and ensures that any authorized administrator can understand, modify, or troubleshoot any flow without relying on undocumented institutional knowledge. Copilot can also assist in diagnosing failed flow runs by analyzing error messages and run history logs and suggesting potential root causes and remediation steps.
5.7 Copilot in Microsoft Power Business Intelligence
Copilot in Power Business Intelligence provides project stakeholders with the ability to query project data using natural language, enabling individuals who are not trained in Power Business Intelligence report authoring to obtain specific data insights on demand without requiring the assistance of the Microsoft Power Platform Administrator or a report developer. For example, an Executive Sponsor can navigate to the Power Business Intelligence dashboard and ask "Show me all projects where the Cost Performance Index is below 0.9 and the projected completion date has slipped by more than thirty days" and receive an immediate, formatted answer derived from the project performance data model.
Copilot also generates automated narrative descriptions of dashboard pages — plain-language summaries of key findings, trends, and anomalies visible in the visual reports — that are updated each time the data model is refreshed. These narratives are particularly useful for stakeholders who consume reports in email distribution format rather than interactively through the Power Business Intelligence service, as they provide a concise, intelligible summary of the most important information without requiring the recipient to navigate the full visual dashboard. Additionally, Copilot in Power Business Intelligence supports automated anomaly detection — the identification of data points that deviate significantly from expected patterns or historical norms — and generates alerts when anomalies are detected in project performance data, which are routed to the appropriate role through the Power Automate notification flows.
5.8 Copilot Governance and Prompt Engineering Standards
The governance of Copilot usage within this automated project management process is the responsibility of the Microsoft Copilot Coordinator, in coordination with the Microsoft Power Platform Administrator. All project personnel who use Copilot are required to complete the Copilot onboarding training program administered by the Microsoft Copilot Coordinator before using Copilot for any project-related activity. This training covers the capabilities and limitations of Copilot, the approved use cases defined in the approved prompt library in Appendix G, data privacy and sensitivity requirements, and the mandatory human review requirement that applies to all Copilot-generated content.
The following governance standards apply to all Copilot usage under this Reference Guide:
Human Review Requirement: All content generated by Copilot — including drafted documents, summaries, risk register entries, action items, and data analysis narratives — must be reviewed and approved by a qualified human reviewer before being used for any official project purpose, published to any SharePoint site, sent to any stakeholder, or recorded in any formal project record. The identity of the reviewing human and the date of their review must be documented.
Sensitive Data Prohibition: Personnel must not input personally identifiable information (information that can be used to identify a specific individual, hereinafter referred to as "personally identifiable information"), protected health information, classified information, or any data subject to contractual or regulatory confidentiality restrictions into Copilot prompts without explicit authorization from the Data Governance Officer and the organization's Privacy Officer. The approved prompt library in Appendix G identifies which prompts involve sensitive data considerations.
Approved Prompt Library Requirement: All Copilot prompts used for recurring, standardized project management activities — such as charter drafting, status report generation, lessons learned synthesis, and risk register generation — must be drawn from or modeled on the approved prompt library defined in Appendix G. Customizations to approved prompts are permitted, provided the customization does not introduce sensitive data inputs or deviate materially from the approved prompt's intended use case.
Attribution Requirement: All Copilot-generated content incorporated into official project documents must be identified as having been produced with Copilot assistance in the document's revision history, in accordance with the organization's intellectual property and attribution policy.
Periodic Governance Review: The Microsoft Copilot Coordinator will conduct a quarterly review of Copilot usage logs, approved prompt library currency, and compliance with data privacy requirements, and will report findings to the Project Management Office Director and the Data Governance Officer.
Section 6: Microsoft Power Automate Flows — Complete Specifications
The following subsections provide complete specifications for each automated flow deployed under this Reference Guide. Each flow specification includes the flow name, trigger, trigger source, conditions and logic branches, step-by-step actions, notifications and recipients, data written to Dataverse or SharePoint, error handling and retry logic, frequency of execution, and the responsible owner role. All flows are built, deployed, and maintained by the Microsoft Power Platform Administrator in the designated Power Automate environment for this process. All flows must be tested in a non-production environment before deployment to the production environment, and all flow documentation must be maintained current in the Microsoft Power Platform Administrator's documentation library on SharePoint.
6.1 Weekly Project Status Collection Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-001: Weekly Project Status Collection |
| Trigger | Scheduled recurrence — every Monday at 8:00 in the morning Eastern Time |
| Trigger Source | Power Automate Recurrence trigger (built-in connector) |
| Frequency | Weekly — every Monday; suspended during formally declared organizational holidays as maintained in the holiday exclusion list in SharePoint |
| Owner Role | Microsoft Power Platform Administrator; monitored by Deputy Project Manager |
Conditions and Logic Branches:
If the current date is listed in the Holiday Exclusion List in SharePoint, the flow terminates without sending notifications and logs a "Holiday Skip" record in the flow execution log in SharePoint.
If a team member's account is listed as "On Leave" in the Team Status SharePoint list, the status request is not sent to that individual, and their response is automatically recorded as "Excused Absence."
If a team member has not responded to the adaptive card within four hours of delivery, a reminder is sent via Teams direct message.
If a team member has still not responded by 5:00 in the afternoon Eastern Time, an escalation notification is sent to the Project Manager via Teams.
Step-by-Step Actions:
The flow is triggered at 8:00 in the morning Eastern Time every Monday.
The flow queries the Project Registry SharePoint list to retrieve all projects with a status of "Active."
For each active project, the flow queries the Team Member Dimension table in Dataverse to retrieve the list of all active Project Team Members assigned to that project.
For each Project Team Member, the flow sends a personalized adaptive card via Teams containing the following fields, as defined in Appendix D: Task Identifier, Task Name, Percentage Complete (numeric entry), Blockers and Impediments (free-text entry), New Risks Identified (free-text entry), Hours Logged This Week (numeric entry), and overall Project Health Assessment (Red / Yellow / Green selection).
The adaptive card response data is captured and written to the Status Updates SharePoint list for the relevant project, with the following fields populated: Project Identifier, Team Member Name, Response Date and Time, all submitted response values, and a Response Status of "Submitted."
A scheduled check runs at 12:00 noon Eastern Time to identify all team members for whom no response has been recorded in the Status Updates list. For each non-respondent, the flow sends a reminder message via Teams direct message stating that their weekly status update is required by 5:00 in the afternoon Eastern Time.
A second scheduled check runs at 5:00 in the afternoon Eastern Time. All team members who have still not submitted a response are flagged as "Non-Respondent" in the Status Updates SharePoint list. The flow sends a Teams notification to the Project Manager listing all non-respondents and requesting that the Project Manager follow up directly.
Upon completion of all response collection activities, the Power Business Intelligence dataset for the project is refreshed via the Power Business Intelligence Application Programming Interface refresh endpoint, ensuring the dashboard reflects the most current data.
A flow execution summary — recording the total number of status requests sent, responses received, reminders sent, and escalations triggered — is written to the Flow Execution Log in SharePoint.
Notifications and Recipients: Initial adaptive card to all active Project Team Members (via Teams); reminder message at noon to non-respondents (via Teams); escalation notification at 5:00 in the afternoon to Project Manager (via Teams).
Data Written: Status Updates SharePoint list (one record per team member per project per week); Flow Execution Log in SharePoint.
Error Handling and Retry Logic: If a Teams adaptive card delivery fails for a specific user, the flow retries delivery three times at five-minute intervals. If delivery still fails after three retries, the flow logs an error record in the Flow Error Log in SharePoint and sends an alert to the Microsoft Power Platform Administrator via Teams. If the Power Business Intelligence dataset refresh fails, the flow retries twice at fifteen-minute intervals and, if unsuccessful, notifies the Microsoft Power Platform Administrator.
6.2 Risk and Issue Escalation Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-002: Risk and Issue Escalation |
| Trigger | When a new item is created in the Risk Register SharePoint list, OR when an existing item is modified to set the Severity Rating field to four or five |
| Trigger Source | SharePoint — "When an item is created or modified" connector |
| Frequency | Event-driven (real-time upon risk or issue submission or modification); also executes a weekly digest component every Friday at 4:00 in the afternoon Eastern Daylight Time |
| Owner Role | Microsoft Power Platform Administrator; monitored by Risk Manager |
Conditions and Logic Branches:
If the Severity Rating is one, two, or three: The flow logs the new risk to the Risk Register and notifies the Risk Manager by Teams message within one hour. No immediate escalation to the Project Manager is triggered.
If the Severity Rating is four: The flow sends an immediate Teams notification to both the Risk Manager and the Project Manager. A task is created in the project's Microsoft Planner board with a due date of three business days from the date of risk submission.
If the Severity Rating is five: All actions for a Severity Rating of four apply, plus the flow schedules an emergency risk review meeting in Microsoft Outlook calendar for the next available business day, inviting the Risk Manager, Project Manager, and relevant Subject Matter Experts as identified in the Risk Register entry.
Step-by-Step Actions:
The flow is triggered by the creation or modification of a Risk Register item in SharePoint.
The flow reads the Severity Rating field from the triggering item.
The flow evaluates the Severity Rating against the conditional logic branches defined above.
For Severity Ratings of four or five, the flow sends an immediate Teams notification to the Risk Manager and Project Manager, including the Risk Identifier, Risk Description, Probability rating, Impact rating, Severity Score, Proposed Response Strategy, and Risk Owner as recorded in the Risk Register entry.
For all Severity Ratings, the flow creates an action item task in the relevant project's Microsoft Planner board, assigned to the Risk Owner identified in the Risk Register entry, with the task name, due date, and a hyperlink to the Risk Register item in SharePoint.
For a Severity Rating of five, the flow calls the Microsoft Graph Application Programming Interface to create a calendar event in Microsoft Outlook for the next available business day, inviting all relevant parties.
Every Friday at 4:00 in the afternoon Eastern Daylight Time, the flow generates a summary digest of all new and modified risks added during the current week and sends this digest as a Teams channel message to the project's Risk and Issues channel, and as an email via Microsoft Outlook to the Risk Manager, Project Manager, and Deputy Project Manager.
Error Handling and Retry Logic: If any Teams notification action fails, the flow retries three times at two-minute intervals and, if unsuccessful, falls back to sending the notification via Microsoft Outlook email. If the Outlook calendar event creation via the Microsoft Graph Application Programming Interface fails, the flow sends a Teams alert to the Microsoft Power Platform Administrator and logs the failure in the Flow Error Log.
6.3 Change Control Board Approval Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-003: Change Control Board Approval |
| Trigger | When a Change Request form is submitted via Microsoft Forms |
| Trigger Source | Microsoft Forms — "When a new response is submitted" connector |
| Frequency | Event-driven (real-time upon form submission) |
| Owner Role | Microsoft Power Platform Administrator; monitored by Project Manager |
Conditions and Logic Branches:
If the Change Request classification is "Minor": The flow routes the request to the Project Manager only for a single-approver decision. No Change Control Board vote is required.
If the Change Request classification is "Moderate" or "Major": The flow routes the request to all Change Control Board members for parallel voting. A majority vote (greater than fifty percent of voting members) determines the outcome.
If the Change Request classification is "Emergency": The flow bypasses the standard Change Control Board voting process and routes the request directly to the Project Manager and Executive Sponsor for immediate joint decision, as defined in Section 11.6.
If an approved majority vote is achieved: The flow updates the project schedule baseline and relevant SharePoint records.
If the vote results in rejection or deferral: The flow notifies the Change Request submitter of the decision and the reasons recorded by the Change Control Board members.
Step-by-Step Actions:
The flow is triggered when a Change Request form is submitted in Microsoft Forms.
The flow retrieves the form response data, including the Change Request title, description, classification, impacted scope items, schedule impact (in business days), cost impact (in United States dollars), submitter name, and supporting rationale.
The flow generates a unique Change Request Identifier using a sequential numbering scheme (format: CRQ-[Year]-[Sequential Number], e.g., CRQ-2026-0017) and records the new Change Request in the Change Requests SharePoint list with a status of "Pending Review."
The flow sends a confirmation Teams message to the Change Request submitter acknowledging receipt and providing the Change Request Identifier.
Based on the Change Request classification, the flow applies the appropriate routing logic as defined in the Conditions section above.
For Moderate and Major classifications, the flow sends a Teams adaptive card to each Change Control Board member containing the full Change Request details and a three-option vote: Approve, Reject, or Defer. The adaptive card specifies the voting deadline (forty-eight hours from the time of card delivery).
The flow collects all votes received within the forty-eight-hour window and calculates the outcome based on majority vote rule. If fewer than fifty percent of Change Control Board members respond within the deadline, the flow escalates to the Project Manager to determine whether to extend the voting period or assign a default outcome.
The flow updates the Change Request record in the SharePoint Change Requests list with the vote tally, individual votes (for audit purposes), and the final decision (Approved, Rejected, or Deferred).
If the decision is "Approved," the flow sends a notification to all Project Team Members whose Planner tasks are impacted by the change, updates the relevant project schedule fields in SharePoint, and generates a Teams channel announcement in the project's General channel notifying all team members of the approved change.
If the decision is "Rejected" or "Deferred," the flow sends a Teams message and email notification to the submitter explaining the decision, including any comments recorded by the Change Control Board members.
Error Handling and Retry Logic: If an adaptive card delivery fails for a specific Change Control Board member, the flow falls back to sending the voting request via Microsoft Outlook email with a link to a dedicated voting form. All delivery failures are logged in the Flow Error Log in SharePoint.
6.4 Milestone Completion and Gate Review Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-004: Milestone Completion and Gate Review |
| Trigger | When a task marked as a "Milestone" in Microsoft Planner is set to 100% completion |
| Trigger Source | Microsoft Planner via Microsoft Graph Application Programming Interface — "When a task is completed" connector |
| Frequency | Event-driven (real-time upon milestone task completion) |
| Owner Role | Microsoft Power Platform Administrator; monitored by Project Manager |
Step-by-Step Actions:
The flow is triggered when a Planner task labeled with the category tag "Milestone" is marked as complete by the assigned Project Team Member or Project Manager.
The flow retrieves the milestone details from the Planner task record via the Microsoft Graph Application Programming Interface, including milestone name, associated project identifier, completion date, and assigned team member.
The flow updates the Milestones SharePoint list for the relevant project, recording the milestone name, completion date, and completion status as "Completed — Pending Gate Review."
The flow compiles the gate review package by retrieving all relevant deliverable documents from the project SharePoint document library associated with the completed milestone, as defined in the Milestone Deliverables mapping table maintained by the Project Manager in SharePoint.
The flow sends a Teams adaptive card notification to all Project Steering Committee members, attaching or linking to the gate review package documents, and requesting formal approval or rejection of the milestone via the adaptive card interface. The adaptive card specifies a seventy-two-hour review and response window.
Upon receipt of all Steering Committee responses (or upon expiration of the seventy-two-hour window), the flow calculates the majority decision. If a majority approves, the flow proceeds with the approval actions. If a majority rejects, the flow proceeds with the rejection actions.
If the milestone is approved: The flow updates the Milestones SharePoint list record to "Approved," unlocks the next phase's task assignments in Microsoft Planner by updating the tasks' start dates to the current date (or the next business day, if the approval occurs outside business hours), and sends a Teams channel announcement notifying all project team members that the milestone has been approved and the next phase has commenced.
If the milestone is rejected: The flow updates the Milestones SharePoint list record to "Rejected," creates a Corrective Action task in Microsoft Planner assigned to the Project Manager with a due date of five business days from rejection, and sends a Teams direct message to the Project Manager specifying the rejection reasons recorded by the Steering Committee members.
Error Handling and Retry Logic: If the Planner task completion event is not received within an expected window after a manual completion is reported, the Microsoft Power Platform Administrator should manually trigger the flow via the Power Automate portal. All adaptive card delivery failures fall back to Microsoft Outlook email notification, as described in Flow 6.3.
6.5 Budget Variance Alert Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-005: Budget Variance Alert |
| Trigger | When an item in the Financial Tracking SharePoint list is created or modified such that the "Actual Cost to Date" field value exceeds the "Planned Cost to Date" field value by more than ten percent |
| Trigger Source | SharePoint — "When an item is created or modified" connector with a conditional filter |
| Frequency | Event-driven (real-time upon financial data entry or modification); the financial data refresh from the organization's finance system occurs daily at midnight via the OData connector |
| Owner Role | Microsoft Power Platform Administrator; monitored by Finance Controller and Project Manager |
Conditions and Logic Branches:
If the actual cost variance is between ten percent and twenty-four-point-nine percent above the planned cost baseline: The flow sends an immediate alert to the Finance Controller and Project Manager and generates a Power Business Intelligence variance report export.
If the actual cost variance is twenty-five percent or more above the planned cost baseline: All actions for the ten-to-twenty-four-point-nine percent threshold apply, plus the flow sends an immediate escalation notification to the Executive Sponsor via both Teams and Microsoft Outlook email.
Step-by-Step Actions:
The flow is triggered by the creation or modification of a Financial Tracking record in SharePoint.
The flow calculates the budget variance percentage using the formula: ((Actual Cost to Date minus Planned Cost to Date) divided by Planned Cost to Date) multiplied by one hundred.
If the variance percentage exceeds ten percent, the flow proceeds with alert actions.
The flow retrieves the relevant project information — including project name, project unique identifier, Project Manager name, current phase, and budget baseline details — from the Project Registry SharePoint list.
The flow sends an immediate Teams notification and Microsoft Outlook email to the Finance Controller and Project Manager, including the variance percentage, the monetary amount of the variance, the current actual cost to date, the planned cost to date, and the remaining budget available.
The flow calls the Power Business Intelligence Application Programming Interface to trigger a refresh of the Budget Variance report and exports the refreshed report as a PDF (Portable Document Format) file, attaching it to the Microsoft Outlook email notification.
If the variance percentage is twenty-five percent or more, the flow additionally sends an escalation notification to the Executive Sponsor via Teams and Microsoft Outlook email, including a summary of the variance, the potential impact on project completion, and a request for guidance on whether to apply contingency reserve funds.
The flow records the alert event in the Budget Alert History SharePoint list, capturing the date and time of the alert, the variance percentage at the time of alert, the recipients notified, and the escalation level applied.
Error Handling and Retry Logic: If the Power Business Intelligence Application Programming Interface call fails, the flow retries twice at ten-minute intervals. If the report export still fails, the flow sends the notification without the attached report and includes a note directing recipients to access the dashboard directly. The failure is logged in the Flow Error Log.
6.6 New Stakeholder Onboarding Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-006: New Stakeholder Onboarding |
| Trigger | When a new item is created in the Stakeholder Register SharePoint list |
| Trigger Source | SharePoint — "When an item is created" connector |
| Frequency | Event-driven (real-time upon new stakeholder record creation) |
| Owner Role | Microsoft Power Platform Administrator; monitored by Communications Manager |
Step-by-Step Actions:
The flow is triggered when a new stakeholder record is created in the Stakeholder Register SharePoint list by the Communications Manager or Project Manager.
The flow reads the stakeholder's name, email address, organization, stakeholder classification (Internal or External), and communication preference from the new SharePoint list item.
The flow retrieves the project overview document, Communication Plan, and reporting schedule from the project SharePoint document library.
The flow sends a formal welcome email via Microsoft Outlook to the new stakeholder, including: a personalized salutation, a brief introduction to the project (project name, purpose, and objectives), an attached copy of the Project Overview document, an attached copy of the applicable sections of the Communication Plan outlining how and how frequently they will receive project communications, and the name and contact information of the Communications Manager as the primary point of contact.
The flow grants appropriate SharePoint site permissions to the stakeholder's organizational account based on their stakeholder classification — Internal stakeholders receive "Read" access to the project SharePoint site; External stakeholders receive access only to the designated External Stakeholder document library, which contains publicly approved project documents.
The flow adds the stakeholder to the relevant project Teams channels based on their classification — all stakeholders are added to the "Announcements" channel; Internal stakeholders with a classification of "Supportive" or "Leading" are also added to the project's "General" channel.
The flow adds the stakeholder's email address to the relevant Microsoft Outlook distribution list for the project, ensuring they receive all broadcast email communications.
The flow creates a scheduled onboarding meeting in the Communications Manager's Microsoft Outlook calendar for the next available business day following the stakeholder's addition to the register, with the new stakeholder invited as a required attendee. The meeting invitation includes a standard agenda covering project overview, stakeholder role and expectations, and communication cadence.
A confirmation record is written to the Onboarding History SharePoint list, capturing the stakeholder name, onboarding date, permissions granted, channels added, and whether the welcome email was successfully delivered.
Error Handling and Retry Logic: If the permission assignment action fails (for example, due to the stakeholder's organizational account not being accessible in the tenant), the flow logs the failure and sends an alert to the Microsoft Power Platform Administrator and the Communications Manager to handle permission assignment manually. All email delivery failures are retried three times at five-minute intervals.
6.7 Lessons Learned Collection Flow (Project Closing)
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-007: Lessons Learned Collection and Project Archival |
| Trigger | When the "Project Status" field in the Project Registry SharePoint list is modified to the value "Closing" |
| Trigger Source | SharePoint — "When an item is modified" connector with a conditional filter on the Project Status field |
| Frequency | Event-driven (triggered once per project upon transition to Closing status) |
| Owner Role | Microsoft Power Platform Administrator; monitored by Project Manager |
Step-by-Step Actions:
The flow is triggered when the Project Manager updates the Project Status field in the Project Registry SharePoint list to "Closing."
The flow retrieves the complete list of all project participants — including Project Team Members, Subject Matter Experts, Stakeholder Representatives, and the Project Manager — from the Team Member Dimension table in Dataverse.
The flow sends a Microsoft Forms survey link via Microsoft Outlook email to all project participants, accompanied by a formal covering message from the Project Manager requesting their candid participation in the lessons learned process. The survey questions are as defined in Appendix E of this Reference Guide.
The flow sets a fourteen-calendar-day response window for the survey. A reminder email is sent to non-respondents at day seven via Microsoft Outlook.
Upon expiration of the fourteen-day window (or upon receipt of all expected responses, whichever occurs first), the flow retrieves all Microsoft Forms survey responses via the Forms connector.
The flow consolidates all survey responses into the Lessons Learned Register in SharePoint, organizing entries by project phase, category (People / Process / Technology / Communication), and sentiment (Positive Lesson — what worked well; Negative Lesson — what should be improved).
The flow triggers a Copilot-assisted summary generation process: it sends the consolidated response data to Copilot, using the approved prompt from Appendix G, requesting a structured, thematically organized lessons learned summary document. The generated document is saved as a draft in the project SharePoint document library, flagged for review by the Project Manager.
The flow initiates the document archival process: it copies all documents from the active project SharePoint document library to the designated archive folder within the Project Management Office SharePoint archive site, maintaining the original folder structure. Documents are tagged with the project unique identifier, project name, and archival date.
The flow sets the permissions on the active project SharePoint site to "Read Only" for all current members, preventing further modification of project records.
Upon completion of all archival actions, the flow sends a Teams notification to the Project Manager and Microsoft Power Platform Administrator confirming that the archival process is complete and providing a link to the archive location.
A completion record is written to the Project Closure Log in SharePoint, capturing the date and time of archival, the number of documents archived, the Lessons Learned Register entry count, and confirmation that all actions were completed successfully.
Error Handling and Retry Logic: If the document copy action fails for individual files, the flow logs the failed files in a "Archival Errors" SharePoint list and continues with the remaining files. A summary of all archival errors is sent to the Microsoft Power Platform Administrator upon completion of the archival process for manual remediation. The flow does not set the site to read-only until all documents have been successfully archived or the archival error list has been reviewed and acknowledged by the Microsoft Power Platform Administrator.
6.8 Meeting Action Item Tracking Flow
| Attribute | Details |
|---|---|
| Flow Name | PMO-FLOW-008: Meeting Action Item Tracking |
| Trigger | When a new Microsoft Teams meeting transcript file is saved to the designated "Meeting Transcripts" folder in the project SharePoint document library |
| Trigger Source | SharePoint — "When a file is created in a folder" connector; specifically monitoring the "Meeting Transcripts" document library folder |
| Frequency | Event-driven (triggered automatically after every Teams meeting for which transcription is enabled) |
| Owner Role | Microsoft Power Platform Administrator; monitored by Deputy Project Manager |
Step-by-Step Actions:
The flow is triggered when a new meeting transcript file — in VTT (Web Video Text Tracks) or DOCX format as generated by Teams — is saved to the "Meeting Transcripts" folder in the project SharePoint document library. This occurs automatically when the Teams meeting organizer has enabled transcription for the meeting.
The flow reads the transcript file content and retrieves the associated meeting metadata — including meeting title, date and time, attendee list, and meeting organizer — from the Teams meeting record via the Microsoft Graph Application Programming Interface.
The flow submits the transcript content to Copilot using the approved action item extraction prompt from Appendix G, requesting that Copilot identify all action items, commitments, and follow-up tasks mentioned in the transcript. For each identified action item, Copilot returns the action item description, the name of the individual assigned to the action (as identified in the transcript), and the due date as stated in the meeting (if mentioned).
The flow reviews the Copilot output for completeness and, for any action items where the due date was not stated in the transcript, assigns a default due date of seven calendar days from the meeting date.
For each identified action item, the flow creates a task in the relevant project's Microsoft Planner board, assigned to the team member identified as the action item owner. The task title is the action item description, and the task notes field includes the meeting title, date, and a link to the transcript in SharePoint for reference.
The flow generates a post-meeting summary document using Copilot, including: the meeting title and date, a list of all attendees, a brief narrative summary of the topics discussed, a structured list of all decisions made, and a table of all action items with owners and due dates. This summary document is saved to the "Meeting Records" folder in the project SharePoint document library.
The flow sends the post-meeting summary to all meeting attendees via a Teams channel message in the project's meeting channel, with a link to the full summary document in SharePoint. For attendees who were invited but did not attend, the summary is also sent via Microsoft Outlook email.
The flow schedules a reminder notification: twenty-four hours before each action item's due date, the assigned Planner task owner receives a Teams direct message reminding them that their action item is due the following day, with the action item description and a link to the Planner task.
Upon completion of all actions, the flow writes a record to the Action Item Tracking Log in SharePoint, including the meeting identifier, the number of action items extracted, the number of Planner tasks created, and the date and time of processing.
Error Handling and Retry Logic: If Copilot fails to process the transcript (for example, due to the transcript file being too large or in an unrecognized format), the flow sends an alert to the Deputy Project Manager and Microsoft Power Platform Administrator, attaching the raw transcript file for manual review. If a Planner task creation fails for a specific action item, the flow retries three times and, if unsuccessful, logs the failed action item in the Action Item Error Log in SharePoint and notifies the Deputy Project Manager.
Section 7: Microsoft Power Business Intelligence Dashboard — Complete Specification
The Power Business Intelligence project management dashboard is the central performance visibility and analytical tool for this automated project management process. It provides role-appropriate visual representations of project and portfolio performance data, enabling all stakeholders — from Executive Sponsors reviewing portfolio health to Project Team Members checking task completion rates — to access the information they need in a timely, accurate, and comprehensible format. The dashboard is maintained by the Microsoft Power Platform Administrator and is accessible to authorized users through the Power Business Intelligence service, the Power Business Intelligence mobile application, and scheduled email subscription reports.
7.1 Data Sources and Connections
The Power Business Intelligence dashboard connects to the following data sources through certified Power Platform connectors, all of which are configured to use the organizational service accounts provisioned by the Microsoft Power Platform Administrator:
SharePoint Lists: Project Registry (containing all project metadata), Risk Register (containing all risk records), Issue Log (containing all issue records), Status Updates (containing all weekly status submissions), Budget Tracking (containing all financial data), Change Requests (containing all change request records), Stakeholder Register (containing all stakeholder records), and Lessons Learned Register (containing all lessons learned records).
Microsoft Planner (via Microsoft Graph Application Programming Interface): Task completion data, milestone status, and resource assignment information are retrieved from Planner through the certified Microsoft Graph Application Programming Interface connector.
Microsoft Dataverse (via Power Platform connector): Team Member Dimension table, Risk Category Dimension table, Project Dimension table, and workflow state data maintained by Power Automate flows.
Finance System Data (via OData feed): Actual cost data, purchase order data, and invoice data are retrieved from the organization's financial management system through an OData (Open Data Protocol — an open standard data access protocol) feed connection refreshed daily at midnight.
Microsoft Project Online (where applicable): For projects using Microsoft Project Online for schedule management, the Project Online connector provides task and milestone data to supplement the Planner data model.
7.2 Data Model
The Power Business Intelligence data model follows a star schema — a relational data model structure in which a central fact table is surrounded by dimension tables, each connected to the fact table through a defined relationship — to optimize query performance and enable flexible, multi-dimensional analysis of project performance data. The following tables constitute the core data model:
7.2.1 Fact Tables
| Fact Table Name | Grain (Level of Detail) | Key Measures |
|---|---|---|
| Status Updates Fact | One record per team member per project per week | Percentage Complete, Hours Logged, Risk Count Reported, Health Assessment Score |
| Budget Actuals Fact | One record per cost category per project per reporting period | Actual Cost, Planned Cost, Earned Value, Cost Variance, Cost Performance Index, Estimate at Completion, Variance at Completion |
| Task Completion Fact | One record per task per project per day (daily snapshot) | Tasks Planned, Tasks Completed, Tasks Overdue, Planned Value, Earned Value, Schedule Variance, Schedule Performance Index |
| Risk Events Fact | One record per risk event (creation or status change) per project | Probability Rating, Impact Rating, Severity Score, Days Open, Risk Status, Response Status |
7.2.2 Dimension Tables
| Dimension Table Name | Key Attributes | Source |
|---|---|---|
| Project Dimension | Project Identifier, Project Name, Phase, Status, Department, Priority, Start Date, End Date, Budget at Completion, Project Manager Name | SharePoint — Project Registry |
| Team Member Dimension | Member Identifier, Member Name, Role, Department, Skill Set Tags, Assigned Projects | Microsoft Dataverse — Team Member table |
| Date Dimension | Date, Day of Week, Week Number, Month, Quarter, Year, Is Business Day, Is Holiday | Generated by Power Query — M language script maintained by Microsoft Power Platform Administrator |
| Risk Category Dimension | Category Identifier, Category Name, Category Description, Parent Category | Microsoft Dataverse — Risk Category table |
7.2.3 Relationships and Cardinality
The following key relationships are defined in the data model. All relationships use single-direction filters (from dimension to fact) to ensure predictable query behavior and prevent ambiguous cross-filter interactions. Bidirectional filtering is used only for the Date Dimension to Project Dimension relationship, which is required to support time intelligence calculations across the portfolio.
Project Dimension (one) → Status Updates Fact (many): Cardinality is one-to-many, joined on Project Identifier.
Project Dimension (one) → Budget Actuals Fact (many): Cardinality is one-to-many, joined on Project Identifier.
Project Dimension (one) → Task Completion Fact (many): Cardinality is one-to-many, joined on Project Identifier.
Project Dimension (one) → Risk Events Fact (many): Cardinality is one-to-many, joined on Project Identifier.
Team Member Dimension (one) → Status Updates Fact (many): Cardinality is one-to-many, joined on Member Identifier.
Date Dimension (one) → all Fact Tables (many): Cardinality is one-to-many, joined on Date field.
Risk Category Dimension (one) → Risk Events Fact (many): Cardinality is one-to-many, joined on Category Identifier.
7.2.4 Data Refresh Schedule
The Power Business Intelligence dataset is configured with the following refresh schedule: Every two hours during business hours (from 7:00 in the morning Eastern Daylight Time to 7:00 in the evening Eastern Daylight Time, Monday through Friday); once daily at midnight Eastern Daylight Time for a full dataset refresh including the finance system OData feed. The Microsoft Power Platform Administrator monitors the data refresh history in the Power Business Intelligence service and is alerted by an automated flow if any scheduled refresh fails.
7.3 Dashboard Pages
Page 1: Executive Portfolio Overview
This page provides the Portfolio Manager, Executive Sponsor, and Project Management Office Director with a high-level view of the entire project portfolio's health, performance, and strategic alignment. It is designed to enable rapid identification of projects requiring executive attention without requiring the viewer to navigate into individual project details. The following visual elements are presented on this page:
Total Active Projects Card: A single-number card visual displaying the count of all projects with a status of "Active" in the Project Registry, updated in real time with each data refresh.
Projects On Schedule versus Projects Delayed (Donut Chart): A donut chart visual segmenting all active projects into "On Schedule" (Schedule Performance Index greater than or equal to 0.95), "At Risk" (Schedule Performance Index between 0.85 and 0.94), and "Delayed" (Schedule Performance Index below 0.85) categories, with each segment colored green, yellow, and red respectively.
Portfolio Budget versus Actual Spending (Clustered Bar Chart): A clustered bar chart displaying the planned cost baseline versus actual cost to date for each active project, enabling quick visual identification of projects with significant cost variances.
Schedule Performance Index and Cost Performance Index Trend Lines: Line charts displaying the weekly trend of the portfolio-average Schedule Performance Index and Cost Performance Index values over the trailing twelve weeks, enabling the identification of improving or deteriorating portfolio-wide performance trends.
Top Five Risks by Severity Heat Map: A table visual formatted as a heat map, displaying the five highest-severity open risks across the portfolio, with cells color-coded by severity score (dark red for severity scores of twenty through twenty-five; orange for fifteen through nineteen; yellow for ten through fourteen).
Milestone Completion Timeline (Gantt-Style Visual): A Gantt-style visual — a horizontal bar chart representing tasks or milestones on a timeline — displaying all portfolio milestones for the current quarter, color-coded by completion status (green for completed, blue for on track, red for overdue).
Page Slicers: Date Range (selecting the analysis period), Department (filtering by sponsoring department), and Project Manager (filtering by assigned Project Manager).
Page 2: Individual Project Health Dashboard
This page provides the Project Manager, Deputy Project Manager, and Project Steering Committee with a comprehensive view of a single selected project's performance status. All visuals on this page are filtered to the project selected in the Project Name slicer at the top of the page. The following visual elements are presented:
Project Metadata Header: A text visual displaying the project name, current phase, and a status badge — color-coded green (on track), yellow (at risk), or red (in trouble) — based on the overall health assessment derived from the Schedule Performance Index, Cost Performance Index, and risk severity scores.
Work Breakdown Structure Completion Percentage (Progress Bar): A progress bar visual displaying the percentage of Work Breakdown Structure tasks marked as complete in Microsoft Planner, compared to the percentage that should be complete based on the current date and the project schedule baseline.
Budget Burn Rate Chart (Area Chart): An area chart displaying the cumulative actual cost curve versus the cumulative planned cost curve and the earned value curve over time, providing a visual representation of cost performance trends.
Risk and Issue Count by Category (Clustered Bar Chart): A clustered bar chart displaying the count of open risks and open issues grouped by risk category, enabling the Project Manager to identify which areas of the project carry the greatest risk exposure.
Team Member Utilization Gauge: A gauge visual displaying the average utilization rate of all Project Team Members assigned to the selected project, with threshold markers at eighty percent (optimal) and one hundred percent (over-capacity).
Recent Status Update Feed: A table visual displaying the five most recent weekly status update records for the selected project, including the submission date, reporting team member, overall health assessment, and any blockers reported.
Earned Value Analysis Section: A structured table displaying the current values of all core Earned Value Analysis metrics: Planned Value (the authorized budget assigned to work scheduled to be accomplished), Earned Value (the authorized budget associated with work actually accomplished), Actual Cost (the realized cost incurred for work accomplished), Schedule Variance (Earned Value minus Planned Value), Cost Variance (Earned Value minus Actual Cost), Schedule Performance Index, Cost Performance Index, Estimate at Completion (the expected total cost to complete all project work), Estimate to Complete (the expected cost to finish all remaining project work), and Variance at Completion (Budget at Completion minus Estimate at Completion).
Page 3: Risk and Issue Management View
This page provides the Risk Manager, Project Manager, and Quality Assurance Manager with a comprehensive view of all risks and issues affecting the selected project or portfolio. It is designed to support the daily risk monitoring activities required by this Reference Guide and to facilitate the preparation of the weekly risk digest distributed through Flow 6.2.
Risk Matrix (Bubble Chart): A bubble chart plotting each open risk on a probability (vertical axis, scale of one to five) versus impact (horizontal axis, scale of one to five) grid. Each bubble represents one risk; bubble size represents the number of days the risk has been open; bubble color represents the risk category. Clicking on a bubble filters the remaining visuals on the page to that specific risk.
Open Risks by Category and Owner (Stacked Bar Chart): A stacked bar chart displaying the count of open risks grouped by risk category, with each bar subdivided by the Risk Owner role, enabling quick identification of which roles are carrying the greatest risk ownership burden.
Issue Aging Chart (Scatter Plot): A scatter plot displaying each open issue as a point, with the horizontal axis representing the number of days the issue has been open and the vertical axis representing the issue's severity rating. A vertical reference line at thirty days highlights issues that have been open for more than one month and require escalation attention.
Risk Trend Over Time (Line Chart): A line chart displaying the weekly count of open high-severity risks (severity score of fifteen or above) over the trailing twelve weeks, enabling the identification of whether the project's overall risk exposure is increasing, decreasing, or stable.
Issues Requiring Escalation (Highlighted Table): A table visual displaying all open issues that meet the escalation criteria defined in Section 9.3 — specifically, issues that have been open for more than fifteen business days without a recorded remediation action — with conditional formatting highlighting these records in red.
Page 4: Resource and Team Utilization
This page provides the Project Manager, Deputy Project Manager, and Portfolio Manager with a comprehensive view of team member workload, capacity, and utilization across all active projects. It is designed to support proactive capacity management and to enable early identification of over-allocation and under-utilization conditions.
Team Member Workload by Project (Stacked Bar Chart): A stacked bar chart displaying the total estimated hours of active tasks assigned to each team member, subdivided by project. Each bar is color-coded by project for easy visual differentiation. A horizontal reference line at forty hours per week indicates the standard full-time capacity threshold.
Capacity versus Demand Gap Chart (Line and Clustered Column Chart): A combination chart displaying, for each week in the project schedule horizon, the total available team capacity (line) versus the total estimated work demand (columns), enabling the identification of future periods of over- or under-capacity.
Utilization by Skill Set (Treemap): A treemap visual — a space-filling visualization in which each category is represented by a rectangle proportional in size to the value being measured — displaying the distribution of team utilization across different skill categories, enabling the identification of skill areas that are in high demand or that have available capacity.
Overtime Alerts (Conditionally Formatted Table): A table displaying all team members whose logged hours for the current week exceed forty hours, sorted in descending order by hours logged, with rows color-coded red for greater than fifty hours, orange for forty-five to fifty hours, and yellow for forty to forty-five hours.
Page 5: Change Control Log
This page provides the Project Manager, Change Control Board members, and Project Steering Committee with a comprehensive view of all change requests submitted to the project, their current status, and the historical performance of the change control process. It enables the monitoring of change request volumes, cycle times, and cumulative impact on the project baseline.
Change Request Volume by Status (Donut Chart): A donut chart displaying the total count of change requests segmented by status — Approved, Pending, Rejected, and Deferred — providing a quick overview of the change control pipeline's current state.
Average Cycle Time for Change Approval (Card Visual): A single-number card displaying the average number of calendar days from the submission of a change request to the recording of a final decision, calculated across all resolved change requests on the selected project.
Change Impact by Cost and Schedule (Scatter Plot): A scatter plot displaying each approved change request as a point, with the horizontal axis representing the cumulative schedule impact (in business days) and the vertical axis representing the cumulative cost impact (in United States dollars). This visual enables the assessment of the total cumulative impact that approved changes have had on the project baseline.
Full Change Log Table with Drill-Through: A table displaying all change requests for the selected project, including Change Request Identifier, title, submitter name, submission date, classification, schedule impact, cost impact, current status, and decision date. Clicking on any row in the table activates a drill-through navigation to a detail page showing the full Change Request record, including all vote records and Change Control Board member comments.
Page 6: Lessons Learned Repository
This page provides the Project Management Office Director, Portfolio Manager, and all project personnel with access to the organizational lessons learned repository, enabling the systematic application of prior project experience to inform future project planning, risk management, and process improvement initiatives.
Lessons Learned by Phase and Category (Matrix Visual): A matrix visual (analogous to a pivot table) displaying the count of lessons learned entries organized by project phase (rows) and category — People, Process, Technology, Communication — (columns), filterable by project and time period.
Word Cloud of Most Frequently Cited Improvement Themes (Custom Visual): A word cloud custom visual displaying the most frequently occurring improvement-related keywords extracted from the lessons learned descriptions, with word size proportional to frequency of occurrence. This visual provides a quick, intuitive summary of the most common themes in the organizational lessons learned repository.
Completed versus Pending Lessons Learned Actions (Donut Chart): A donut chart displaying the proportion of recommended lessons learned improvement actions that have been formally assigned, completed, or are still pending assignment, enabling the Project Management Office Director to assess the degree to which lessons learned insights are being actively applied.
7.4 Row-Level Security Configuration
Row-level security — a Power Business Intelligence feature that restricts which rows of data a given user is authorized to see based on their identity and role — is configured in the data model to ensure that project data is accessible only to authorized personnel. The following row-level security roles are defined in the Power Business Intelligence data model and assigned to organizational security groups by the Microsoft Power Platform Administrator:
Executive Portfolio Role: Users in this role see data for all active projects across the organization. This role is assigned to the Executive Sponsor, Portfolio Manager, and Project Management Office Director.
Project Manager Role: Users in this role see data only for the specific projects to which they are assigned as Project Manager or Deputy Project Manager in the Project Dimension table. This role is assigned to all Project Managers and Deputy Project Managers.
Project Team Member Role: Users in this role see data only for the specific project to which they are assigned in the Team Member Dimension table, and only the task and status data relevant to their own assignments. Aggregate project performance data (Earned Value Analysis metrics, budget totals, risk severity scores) is visible but not filterable to individual team member data of other participants.
Finance Role: Users in this role see budget and cost data for all projects but are restricted from viewing task-level and team member-level data. This role is assigned to the Finance Controller and Procurement Officer.
Risk Manager Role: Users in this role see full risk and issue data for all projects but are restricted from viewing budget and team member utilization details of other roles. This role is assigned to the Risk Manager.
7.5 Automated Report Distribution
The Power Business Intelligence service's scheduled email subscription feature is configured to deliver formatted dashboard report snapshots to role-based distribution lists on the following schedule. All subscriptions are managed by the Microsoft Power Platform Administrator and are updated whenever changes to role assignments, stakeholder lists, or distribution list membership are made. Report snapshots are delivered as PDF attachments and include a direct link to the live dashboard for interactive exploration.
| Report Name | Dashboard Page | Frequency | Delivery Time | Recipients |
|---|---|---|---|---|
| Executive Portfolio Weekly Digest | Page 1: Executive Portfolio Overview | Weekly — every Monday | 7:00 in the morning Eastern Daylight Time | Executive Sponsors, Portfolio Managers, Project Management Office Director |
| Project Health Weekly Report | Page 2: Individual Project Health | Weekly — every Monday | 8:00 in the morning Eastern Daylight Time | Project Manager, Deputy Project Manager, Project Steering Committee |
| Risk Digest | Page 3: Risk and Issue Management | Weekly — every Friday | 4:00 in the afternoon Eastern Daylight Time | Risk Manager, Project Manager, Deputy Project Manager |
| Resource Utilization Report | Page 4: Resource and Team Utilization | Weekly — every Friday | 5:00 in the afternoon Eastern Daylight Time | Project Manager, Deputy Project Manager, Portfolio Manager |
| Change Control Summary | Page 5: Change Control Log | Monthly — first Monday of each month | 8:00 in the morning Eastern Daylight Time | Project Steering Committee, Change Control Board Members, Project Manager |
7.6 Mobile Optimization and Power Business Intelligence Mobile Application
All dashboard pages are configured with mobile-optimized layouts using the Power Business Intelligence mobile layout editor, enabling authorized users to access project performance data through the Power Business Intelligence Mobile Application (the native mobile application for iOS and Android that provides access to Power Business Intelligence reports and dashboards) on smartphones and tablets. Mobile layouts are simplified versions of the desktop layouts, prioritizing the most critical visual elements — primarily card visuals, status badges, and the top-five risk table — for clear readability on small screens without requiring horizontal scrolling.
The Microsoft Power Platform Administrator is responsible for maintaining the mobile layouts and ensuring that they remain synchronized with any changes made to the desktop layouts during dashboard maintenance activities. All users who access the dashboard through the mobile application must complete the same authentication and row-level security controls as desktop users, ensuring consistent access governance regardless of device type. The organization's mobile device management policy governs the installation and use of the Power Business Intelligence Mobile Application on personal and organizational devices.
7.7 Natural Language Query Configuration
The Power Business Intelligence natural language query feature — also known as "Questions and Answers" — is configured for all dashboard pages to allow users to ask questions about the project data in plain English and receive immediate visual or numerical answers. The Microsoft Power Platform Administrator has configured a library of pre-defined question-and-answer terms — synonyms, entity names, measure names, and common questions — to optimize the accuracy and relevance of natural language query results. Copilot's integration with the natural language query feature further enhances this capability by enabling more complex, context-aware queries that reference multiple data sources simultaneously. All natural language query sessions are subject to the same row-level security controls as the underlying data model, ensuring that users cannot access data beyond their authorized scope through natural language queries.
Section 8: Quality Management Plan
8.1 Quality Standards and References
The quality management approach for all projects governed by this Reference Guide is aligned with the following standards and references: the Project Management Body of Knowledge Seventh Edition (specifically the Delivery Performance Domain, which addresses the quality of outputs, outcomes, and benefits); the International Organization for Standardization 9001 (an internationally recognized standard for quality management systems, hereinafter referred to as "International Organization for Standardization 9001") where applicable to the organization's certified processes; and the organization's internal Quality Management Framework, maintained by the Quality Assurance Manager and accessible on the Project Management Office SharePoint site. In cases of conflict between these standards and the requirements of this Reference Guide, the organization's internal Quality Management Framework shall take precedence, unless the conflict pertains to a Project Management Institute standard, in which case the Project Management Institute standard shall prevail.
8.2 Quality Assurance Activities
Quality assurance activities are process-oriented activities performed to provide confidence that the project will satisfy the relevant quality standards. Under this Reference Guide, the following quality assurance activities are mandatory for all projects:
Process Compliance Audits: The Quality Assurance Manager conducts a formal process compliance audit at the midpoint of each project phase, reviewing the project team's adherence to the processes defined in this Reference Guide, including status reporting, risk management, change control, and communication activities. Audit findings are documented in the Quality Audit Report in SharePoint and reviewed by the Project Manager within five business days of receipt.
Document Quality Reviews: All formal project documents — including the Project Charter, Project Management Plan, status reports, risk register, and closure documentation — are reviewed by the Quality Assurance Manager for completeness, accuracy, and compliance with the templates defined in this Reference Guide and the appendices thereto before being formally approved or distributed.
Automated Process Monitoring: The Power Business Intelligence dashboard's automated anomaly detection capability, described in Section 7.7, is used to monitor the quality of process execution by identifying patterns that deviate from defined standards — for example, consistently late status update submissions, unusually high rates of change request rejections, or unusually long mean time to close issues — and alerting the Project Manager and Quality Assurance Manager to these patterns for investigation.
8.3 Quality Control Activities
Quality control activities are product-oriented activities performed to identify defects in deliverables and take corrective action to ensure that deliverables meet their defined acceptance criteria. Under this Reference Guide, the following quality control activities are mandatory for all projects:
Deliverable Inspections: All formal project deliverables must be formally inspected by the Quality Assurance Manager against the acceptance criteria defined in the relevant section of the Project Management Plan before being submitted for stakeholder approval at a milestone gate review. The inspection must be documented using the Deliverable Inspection Checklist template maintained by the Project Management Office on SharePoint.
Testing Activities: For technical deliverables, the Quality Assurance Manager and Technical Lead and Solution Architect jointly define the testing strategy — including unit testing, integration testing, user acceptance testing, and performance testing as appropriate — and the specific acceptance criteria for each test type. All testing activities and their results must be documented in the Test Results Log in SharePoint.
Defect Management: All defects identified during deliverable inspections or testing activities are logged in the Issue Log in SharePoint with full traceability to the deliverable, the acceptance criterion that was not met, the severity of the defect, and the remediation action required. Defects with a severity rating of four or five on a five-point scale are automatically escalated to the Project Manager through the Risk and Issue Escalation Flow defined in Flow 6.2.
8.4 Quality Gates by Phase
| Gate | Phase | Entry Conditions | Reviewer(s) | Exit Conditions |
|---|---|---|---|---|
| Gate 1 | Initiating → Planning | Project Charter drafted and submitted for review | Quality Assurance Manager, Project Management Office Director, Executive Sponsor | All mandatory charter fields complete; all objectives in Specific, Measurable, Achievable, Relevant, Time-bound format; all required signatories obtained |
| Gate 2 | Planning → Executing | All Project Management Plan subsidiary plans drafted and submitted for review | Quality Assurance Manager, Project Management Office Director, Finance Controller | All subsidiary plans complete; baselines approved and locked; all team resources confirmed |
| Gate 3 | Executing — Milestone Reviews | Milestone task marked complete in Planner; gate review package compiled | Project Steering Committee (via automated adaptive card), Quality Assurance Manager | Majority Steering Committee approval; deliverable acceptance criteria met per inspection records |
| Gate 4 | Monitoring and Controlling → Closing | All phase deliverables complete; all change requests resolved | Project Manager, Quality Assurance Manager, Finance Controller | All deliverables formally accepted; all contracts reviewed; all open issues resolved or formally accepted |
| Gate 5 | Closing → Closed | Closure documentation package complete; lessons learned finalized | Project Management Office Director, Executive Sponsor | Project Closure Report formally approved; all documents archived; all Power Automate flows deactivated |
8.5 Defect and Non-Conformance Management
A defect is a condition in which a deliverable fails to meet one or more of its defined acceptance criteria. A non-conformance is a condition in which a process activity fails to adhere to one or more of the standards or procedures defined in this Reference Guide or the organization's Quality Management Framework. Both defects and non-conformances are recorded in the Issue Log in SharePoint using the Non-Conformance Record template maintained by the Quality Assurance Manager. Each record must include: the identifier and description of the defect or non-conformance, the deliverable or process activity affected, the acceptance criterion or standard violated, the date of discovery, the severity rating, the assigned remediation owner, the required remediation due date, and the status of the remediation action.
For defects and non-conformances with a severity rating of four or five, the Risk and Issue Escalation Flow defined in Flow 6.2 automatically notifies the Project Manager and Quality Assurance Manager and creates a remediation task in Microsoft Planner. The Project Manager is responsible for ensuring that all defects and non-conformances are remediated within the timeframes defined in the Non-Conformance Record before the affected deliverable is resubmitted for approval or the project advances through its next quality gate. A pattern of recurring non-conformances in the same process area shall trigger a formal process improvement review led by the Quality Assurance Manager and the Project Management Office Director.
Section 9: Communication Plan
9.1 Communication Matrix
The following Communication Matrix defines every formal communication associated with this automated project management process, specifying the intended audience, message content, delivery frequency, communication channel, and responsible role for each communication type. All communications must be executed in accordance with this matrix unless formally amended through the change control process defined in Section 11.
| Communication | Audience | Content | Frequency | Channel | Owner |
|---|---|---|---|---|---|
| Weekly Project Status Report | Project Steering Committee, Project Manager, Deputy Project Manager, Executive Sponsor | Schedule status, budget status, risk summary, key accomplishments, upcoming milestones, open issues | Weekly — every Monday by noon Eastern Daylight Time | Microsoft Outlook email, Teams channel post | Project Manager (assisted by Copilot) |
| Executive Portfolio Dashboard | Executive Sponsor, Portfolio Manager, Project Management Office Director | Portfolio-level Schedule Performance Index, Cost Performance Index, milestone status, top risks | Weekly — every Monday at 7:00 in the morning Eastern Daylight Time (automated) | Power Business Intelligence service, email subscription | Microsoft Power Platform Administrator (automated) |
| Risk Digest | Risk Manager, Project Manager, Deputy Project Manager | All new and modified risks from the past week, escalation status, risk response actions due | Weekly — every Friday at 4:00 in the afternoon Eastern Daylight Time (automated via Flow 6.2) | Teams channel message, Microsoft Outlook email | Flow 6.2 (automated), overseen by Risk Manager |
| Milestone Gate Review Notification | Project Steering Committee | Milestone name, deliverables completed, gate review package, request for formal approval | Event-driven (upon milestone completion) | Teams adaptive card (via Flow 6.4) | Flow 6.4 (automated), overseen by Project Manager |
| Change Request Decision Notification | Change Request submitter, all project team members, Project Steering Committee | Change Request Identifier, decision (Approved / Rejected / Deferred), vote tally, Change Control Board comments | Event-driven (upon Change Control Board decision) | Teams channel message, Microsoft Outlook email (via Flow 6.3) | Flow 6.3 (automated), overseen by Project Manager |
| Monthly Portfolio Review Briefing | Executive Sponsor, Portfolio Manager, Project Management Office Director, all Project Steering Committees | Monthly portfolio performance summary, key decisions required, strategic alignment review | Monthly — first Tuesday of each month | Teams meeting with screen share of Power Business Intelligence dashboard | Project Management Office Director |
| Post-Meeting Action Item Summary | All meeting attendees and invitees who did not attend | Meeting summary, decisions made, all action items with owners and due dates | Event-driven (within two hours of meeting conclusion) | Teams channel message, Microsoft Outlook email (via Flow 6.8) | Flow 6.8 (automated), reviewed by Deputy Project Manager |
| Budget Variance Alert | Finance Controller, Project Manager; Executive Sponsor if variance exceeds twenty-five percent | Variance percentage, monetary amount, current actual cost, planned cost baseline, contingency reserve status | Event-driven (when variance threshold is breached) | Teams notification, Microsoft Outlook email with Power Business Intelligence report attachment (via Flow 6.5) | Flow 6.5 (automated), monitored by Finance Controller |
| Project Closure Announcement | All project stakeholders and team members | Confirmation of formal project closure, summary of outcomes, reference to archived documentation, post-project contact information | Once — upon formal project closure | Microsoft Outlook email, Teams channel announcement | Communications Manager |
9.2 Reporting Cadence
The following reporting cadence applies to all projects governed by this Reference Guide. Adherence to this cadence is monitored by the Deputy Project Manager, and any deviations — including late or missed reports — must be documented in the project issue log and remediated promptly. The automated flows defined in Section 6 enforce the cadence for all event-driven and scheduled automated communications.
Daily: The Project Manager and Deputy Project Manager review the Power Business Intelligence Individual Project Health Dashboard each business day for schedule, cost, risk, and issue anomalies. No formal daily report is published unless a critical issue requiring immediate stakeholder notification is identified.
Weekly: Weekly project status reports are published every Monday by noon Eastern Daylight Time. Risk digests are distributed every Friday at 4:00 in the afternoon Eastern Daylight Time. Power Business Intelligence dashboard email subscriptions are delivered as defined in Section 7.5.
Monthly: The Portfolio Review Briefing is conducted on the first Tuesday of each month. The Change Control Summary Power Business Intelligence report subscription is delivered on the first Monday of each month.
Milestone-Based: Gate review notifications are distributed immediately upon milestone completion through Flow 6.4. Milestone approval or rejection notifications are distributed within twenty-four hours of the gate review decision.
9.3 Escalation Path and Escalation Thresholds
The following escalation path defines the sequence of contacts and timeframes governing escalation of issues, risks, decisions, and performance variances that cannot be resolved at the current level of authority. Escalation is mandatory whenever the conditions defined in this table are met; failure to escalate in accordance with this path is a process non-conformance subject to the defect management procedure defined in Section 8.5.
| Escalation Trigger | Initial Contact | Escalation Level 1 | Escalation Level 2 | Timeframe for Initial Escalation |
|---|---|---|---|---|
| Schedule Performance Index below 0.85 for two consecutive weeks | Project Manager | Project Steering Committee | Executive Sponsor | Within one business day of second consecutive week below threshold |
| Cost Performance Index below 0.85 for two consecutive weeks | Finance Controller, Project Manager | Project Steering Committee | Executive Sponsor | Within one business day of second consecutive week below threshold |
| Budget variance exceeding ten percent | Finance Controller, Project Manager (automated via Flow 6.5) | Project Steering Committee | Executive Sponsor | Immediate (automated); human response required within four hours |
| Risk with severity rating of five | Risk Manager, Project Manager (automated via Flow 6.2) | Project Steering Committee | Executive Sponsor | Immediate (automated); risk review meeting within one business day |
| Open issue unresolved for more than fifteen business days | Project Manager | Project Steering Committee | Executive Sponsor | Within two business days of the fifteen-day threshold being reached |
| Milestone delayed by more than ten business days from baseline | Project Manager | Project Steering Committee | Executive Sponsor | Within two business days of identifying the delay |
9.4 Stakeholder Engagement Classification
All stakeholders identified in the Stakeholder Register are classified according to the engagement level model defined in the Project Management Body of Knowledge Seventh Edition. This classification is used to guide the development of tailored communication and engagement strategies for each stakeholder group. The five engagement levels are defined as follows:
Unaware: The stakeholder is not aware of the project or its potential impact on them. Communication strategy: inform of project existence, purpose, and relevance to the stakeholder's interests through an introductory communication and follow-up meeting.
Resistant: The stakeholder is aware of the project but is resistant to the change it represents. Communication strategy: engage actively through one-on-one meetings facilitated by the Communications Manager to understand and address specific concerns; involve in working groups where feasible to build ownership.
Neutral: The stakeholder is aware of the project but is neither resistant nor actively supportive. Communication strategy: maintain regular informational communications to build awareness and understanding; seek opportunities to highlight benefits relevant to the stakeholder's interests.
Supportive: The stakeholder is aware of and supportive of the project. Communication strategy: leverage the stakeholder's support by inviting them to serve as internal advocates; keep them informed and engaged to sustain their support through regular, substantive communications.
Leading: The stakeholder is actively engaged in ensuring the project succeeds. Communication strategy: involve in governance activities, gate reviews, and decision-making processes; provide full access to project performance information and recognize their leadership contribution formally.
Stakeholder engagement classifications are assessed by the Communications Manager at each gate review and updated in the Stakeholder Register accordingly. Changes in a stakeholder's classification that represent a deterioration (for example, from Supportive to Neutral, or from Neutral to Resistant) must trigger an immediate review of the communication strategy for that stakeholder and, if warranted, an escalation to the Project Manager for personal engagement.
9.5 Microsoft Teams Channel Structure for the Project
Each project governed by this Reference Guide is provisioned with a dedicated Microsoft Teams environment with the following standardized channel structure. This structure is created automatically by the project intake Power Automate flow upon charter approval and is maintained by the Microsoft Power Platform Administrator. All project team members and relevant stakeholders are added to the appropriate channels as defined by their role and classification.
| Channel Name | Purpose | Members | Automated Flow Posts |
|---|---|---|---|
| General | Broad project announcements, general project communications, file sharing | All project team members, Internal Supportive and Leading stakeholders | Milestone approval announcements (Flow 6.4), Change Request decisions (Flow 6.3) |
| Status and Reporting | Weekly status update submissions, status reports, performance summaries | Project Manager, Deputy Project Manager, all Project Team Members | Weekly status adaptive card requests (Flow 6.1), reminder notifications (Flow 6.1) |
| Risk and Issues | Risk register updates, issue log updates, risk digest, escalation notifications | Project Manager, Deputy Project Manager, Risk Manager, Quality Assurance Manager | Risk escalation notifications (Flow 6.2), weekly risk digest (Flow 6.2) |
| Change Control | Change request submissions, voting communications, change control board discussions | Project Manager, Change Control Board Members, Technical Lead and Solution Architect | Change request voting adaptive cards (Flow 6.3) |
| Meeting Records | Post-meeting summaries, action item notifications, transcript storage links | All project team members | Post-meeting action item summaries (Flow 6.8) |
| Finance and Procurement | Budget tracking updates, purchase order notifications, invoice approvals | Project Manager, Finance Controller, Procurement Officer | Budget variance alerts (Flow 6.5) |
| Announcements (read-only) | Official project announcements to all stakeholders; posting restricted to Project Manager and Communications Manager | All project team members, all stakeholders (Internal and External) | Major milestone achievements, project closure announcement |
Section 10: Risk Management Framework
10.1 Risk Identification Process
Risk identification is the systematic process of identifying and documenting all potential events or conditions that could positively or negatively affect the project's ability to achieve its objectives. Under this Reference Guide, risk identification is a continuous, organization-wide responsibility — not the exclusive domain of the Risk Manager — and all project personnel are expected to identify and log risks as they are encountered throughout the project lifecycle. New risks may be identified through formal risk workshops, structured stakeholder interviews, expert judgment sessions, analysis of historical project data in the Lessons Learned Repository accessible via the Power Business Intelligence Page 6 dashboard, and review of analogous project records.
The primary automated trigger for risk identification is the Risk and Issue Escalation Flow defined in Flow 6.2, which activates whenever a new risk record is created in the SharePoint Risk Register. Additionally, Copilot is used during the Initiating Phase to perform an automated initial risk screening of the Project Charter and business case, as described in Section 5.1, to ensure that no major risk categories are overlooked in the initial risk register. All newly identified risks must be entered into the SharePoint Risk Register within one business day of identification.
10.2 Risk Assessment: Probability and Impact Matrix
All identified risks are assessed on two dimensions: Probability (the likelihood that the risk event will occur) and Impact (the magnitude of the consequence to the project if the risk event occurs). Both dimensions are rated on a five-point ordinal scale as defined in the following tables. The Severity Score for each risk is calculated by multiplying the Probability rating by the Impact rating, yielding a score between one and twenty-five. The automated Risk and Issue Escalation Flow applies different routing and escalation actions based on the Severity Score as described in Flow 6.2.
| Probability Rating | Description | Approximate Probability Range |
|---|---|---|
| 1 — Very Low | The risk event is unlikely to occur during the project lifecycle. | Less than 10% |
| 2 — Low | The risk event has a low but non-trivial probability of occurring. | 10% to 30% |
| 3 — Medium | The risk event has a moderate probability of occurring. | 30% to 50% |
| 4 — High | The risk event is more likely than not to occur. | 50% to 70% |
| 5 — Very High | The risk event is highly likely or almost certain to occur. | Greater than 70% |
| Impact Rating | Schedule Impact | Cost Impact | Quality Impact | Stakeholder Impact |
|---|---|---|---|---|
| 1 — Negligible | Less than 1% schedule delay | Less than 1% cost increase | Minor rework; no deliverable impact | No stakeholder concern expected |
| 2 — Minor | 1%–5% schedule delay | 1%–5% cost increase | Some rework; minor deliverable impact | Minor stakeholder concern |
| 3 — Moderate | 5%–10% schedule delay | 5%–10% cost increase | Significant rework; deliverable quality affected | Moderate stakeholder concern; escalation possible |
| 4 — Significant | 10%–25% schedule delay | 10%–25% cost increase | Major rework; deliverable acceptance at risk | Significant stakeholder concern; escalation required |
| 5 — Critical | Greater than 25% schedule delay or project failure | Greater than 25% cost increase or budget exhaustion | Deliverable unacceptable; project objectives cannot be met | Major stakeholder impact; project viability at risk |
The following five-by-five Risk Matrix summarizes the Severity Score ranges and their associated escalation classification:
| Probability \ Impact | 1 — Negligible | 2 — Minor | 3 — Moderate | 4 — Significant | 5 — Critical |
|---|---|---|---|---|---|
| 5 — Very High | 5 | 10 | 15 | 20 | 25 |
| 4 — High | 4 | 8 | 12 | 16 | 20 |
| 3 — Medium | 3 | 6 | 9 | 12 | 15 |
| 2 — Low | 2 | 4 | 6 | 8 | 10 |
| 1 — Very Low | 1 | 2 | 3 | 4 | 5 |
Color Key: Green (1–4) = Low; Yellow (5–9) = Moderate; Orange (10–14) = High; Red (15–19) = Very High; Dark Red (20–25) = Critical
10.3 Risk Response Strategies
For each identified risk, the Risk Manager and Project Manager must define and document an appropriate risk response strategy in the Risk Register. The following five response strategies, aligned with the Project Management Body of Knowledge Seventh Edition's guidance on risk response planning, are available:
Avoid: Changing the project plan to eliminate the risk or protect the project from its impact. Avoidance involves eliminating the root cause of the risk rather than merely reducing its probability or impact. Avoidance is most appropriate for risks with Critical severity scores (twenty to twenty-five) where the potential impact is unacceptable and where the necessary plan change is feasible within the project's constraints.
Transfer: Shifting the financial consequence of the risk to a third party — typically through insurance, performance bonds, warranties, or fixed-price contracts with vendors — without eliminating the risk itself. Transference reduces the organization's financial exposure to the risk but does not prevent the risk event from occurring. It is most appropriate for financial risks that can be contractually assigned to another party.
Mitigate: Reducing the probability of a risk occurring, reducing the impact of the risk if it does occur, or both. Mitigation actions must be specific, measurable, and achievable within the project's time and cost constraints. Mitigation is the most commonly applicable strategy and is appropriate for risks with Moderate, High, or Very High severity scores where the risk cannot be avoided or transferred.
Accept: Acknowledging the risk and deciding to take no proactive action unless and until the risk event occurs (passive acceptance) or establishing a contingency plan and contingency reserve to be invoked if the risk materializes (active acceptance). Acceptance is appropriate for risks with Low severity scores (one to four) or for risks where no cost-effective response strategy is available.
Escalate: Escalating the risk to a higher level of authority within or outside the organization when the risk is beyond the scope of the project manager's authority or when its impact would extend beyond the boundaries of the project. Escalated risks are reported to the Executive Sponsor or Portfolio Manager and are managed at the program or portfolio level rather than the project level.
10.4 Residual Risk Monitoring
Residual risks are risks that remain after the implementation of risk response strategies. Even after a risk response has been implemented, the underlying risk may not be fully eliminated, and the remaining probability and impact of the risk must be reassessed and continuously monitored. Residual risks are documented in the Risk Register alongside the original risk and its response strategy, and are assigned their own Residual Probability, Residual Impact, and Residual Severity Score. The Risk Manager reviews all residual risks on a weekly basis as part of the Risk Register maintenance activity and updates the residual ratings as new information becomes available. Residual risks with a Residual Severity Score of ten or above are reviewed by the Project Manager and are included in the weekly risk digest distributed through Flow 6.2.
10.5 Automated Risk Escalation Rules
The following automated risk escalation rules are implemented in the Risk and Issue Escalation Flow defined in Flow 6.2 and are enforced automatically by Power Automate without requiring manual intervention by the Risk Manager or Project Manager:
Severity Rating of five on the Probability or Impact scale alone: The Risk Manager receives an automated Teams notification within thirty minutes of the risk record being created or modified. A Planner task is created for the Risk Manager with a due date of two business days.
Severity Score of fifteen through nineteen (Very High): The Risk Manager and Project Manager both receive immediate Teams notifications. A Planner action item is created with a due date of three business days. The risk is included in the next weekly digest.
Severity Score of twenty through twenty-five (Critical): All Very High escalation actions apply, plus an emergency risk review meeting is scheduled in Microsoft Outlook for the next available business day, and the Executive Sponsor is notified via Teams direct message.
Any risk that remains open (status not set to Closed or Accepted) for more than thirty calendar days without a recorded response action: The Risk Manager and Project Manager receive an automated Teams reminder. The risk is highlighted in the Power Business Intelligence Risk and Issue Management View with a red "Stale Risk" indicator.
10.6 Risk Register Template
The following table defines all required fields in the SharePoint Risk Register list. The Microsoft Power Platform Administrator is responsible for ensuring that the SharePoint list is configured with all fields defined below and that all field types, validation rules, and automated flow triggers are correctly implemented. The blank Risk Register template for project use is provided in Appendix B of this Reference Guide.
| Field Name | Data Type | Required | Description |
|---|---|---|---|
| Risk Identifier | Text (auto-generated) | Yes | Unique identifier in format RSK-[ProjectID]-[Sequential Number] |
| Project Identifier | Lookup (Project Registry) | Yes | The unique identifier of the associated project |
| Risk Title | Single line of text | Yes | A concise, descriptive title for the risk (maximum fifty characters) |
| Risk Description | Multiple lines of text | Yes | A complete description of the risk event and its potential cause and effect |
| Risk Category | Choice (lookup to Risk Category Dimension) | Yes | The category of the risk: Technical, Schedule, Financial, Resource, Stakeholder, External, Regulatory |
| Probability Rating (1–5) | Number | Yes | Assessed probability as per the five-point scale in Section 10.2 |
| Impact Rating (1–5) | Number | Yes | Assessed impact as per the five-point scale in Section 10.2 |
| Severity Score | Calculated (Probability × Impact) | Yes (auto-calculated) | Automatically calculated as Probability Rating multiplied by Impact Rating |
| Response Strategy | Choice | Yes | Avoid / Transfer / Mitigate / Accept / Escalate |
| Response Description | Multiple lines of text | Yes | Detailed description of the specific actions to be taken under the selected response strategy |
| Risk Owner | Person (lookup to organizational directory) | Yes | The individual responsible for executing the risk response and monitoring the risk |
| Risk Status | Choice | Yes | Open / In Progress / Accepted / Closed |
| Date Identified | Date | Yes | The date on which the risk was first identified and entered in the register |
| Target Resolution Date | Date | Yes | The date by which the risk response actions must be completed |
| Residual Probability (1–5) | Number | Yes (after response) | The probability of the risk occurring after the response strategy has been implemented |
| Residual Impact (1–5) | Number | Yes (after response) | The impact of the risk if it occurs after the response strategy has been implemented |
| Last Review Date | Date | Yes | The date of the most recent formal review of this risk record |
| Notes and History | Multiple lines of text (append-only) | No | A running log of notes, updates, and historical observations added by the Risk Manager over the life of the risk |
Section 11: Change Control Process
11.1 Change Request Submission Procedure
Any project stakeholder — including Project Team Members, Subject Matter Experts, Stakeholder Representatives, or external parties — may submit a Change Request at any time during the project lifecycle by completing the Change Request Form in Microsoft Forms, the link to which is pinned in the project's Change Control Teams channel and is accessible from the project SharePoint site. The Change Request Form template is provided in Appendix C of this Reference Guide and includes all mandatory fields required for the Change Control Board to evaluate the request.
The submitter is responsible for providing a complete, accurate, and detailed description of the proposed change, including its rationale, the specific scope elements or baselines it would affect, and a preliminary estimate of its impact on the project schedule and budget. Incomplete Change Request forms will be returned to the submitter by the Project Manager with a request for the missing information; the clock for the Change Control Board review period does not begin until a complete Change Request form has been received. All Change Request submissions trigger the automated Change Control Board Approval Flow defined in Flow 6.3.
11.2 Change Request Classification
All Change Requests are classified by the Project Manager upon receipt, based on the scope and magnitude of the proposed change. The classification determines the routing, approval authority, and timeline for the change control process:
| Classification | Criteria | Approval Authority | Maximum Review Cycle Time |
|---|---|---|---|
| Minor | No impact on baseline scope, budget less than five percent of the budget baseline, schedule less than five business days' impact; administrative corrections only | Project Manager alone | Two business days |
| Moderate | Limited scope change; budget impact five to fifteen percent of baseline; schedule impact five to twenty business days | Change Control Board (majority vote) | Five business days |
| Major | Significant scope change; budget impact greater than fifteen percent of baseline; schedule impact greater than twenty business days; significant stakeholder impact | Change Control Board (majority vote) plus Executive Sponsor ratification | Ten business days |
| Emergency | Immediate action required to prevent imminent project failure, regulatory non-compliance, or irreversible harm; cannot wait for standard review cycle | Project Manager and Executive Sponsor jointly, with retrospective Change Control Board review within five business days | Twenty-four hours for initial approval; five business days for retrospective review |
11.3 Change Control Board Composition and Voting Rules
The Change Control Board is composed of the following roles, as defined in Section 2.1 of this Reference Guide: the Project Manager (who serves as the non-voting Change Control Board Chair, responsible for presenting the Change Request package and facilitating the review process), a minimum of two and a maximum of five Change Control Board Members representing the key stakeholder groups, the Finance Controller (non-voting, providing financial impact analysis), and the Technical Lead and Solution Architect (non-voting for minor and moderate changes; voting member for major and technically complex changes). The Executive Sponsor participates in the Change Control Board review only for Major classification changes requiring Executive Sponsor ratification.
The voting rules for the Change Control Board are as follows: A quorum is established when at least two-thirds of the voting Change Control Board members have cast their votes within the defined review period. A majority vote — defined as more than fifty percent of votes cast — is required to approve a change request. If a quorum is not achieved within the review period, the Project Manager may extend the voting period by an additional forty-eight hours, or may escalate to the Project Steering Committee for a decision. All votes are recorded in the Change Requests SharePoint list for audit purposes, regardless of whether the vote is cast via the Teams adaptive card or via the fallback Microsoft Outlook email voting mechanism.
11.4 Change Impact Assessment Procedure
Before transmitting a Change Request to the Change Control Board for voting, the Project Manager, supported by the Business Analyst, Technical Lead and Solution Architect, Finance Controller, and Risk Manager, must conduct a formal change impact assessment and document the results in the Change Request record in SharePoint. The change impact assessment must address all of the following dimensions:
Scope Impact: Which Work Breakdown Structure components, deliverables, or acceptance criteria would be added, removed, or modified by this change?
Schedule Impact: How many business days would the project completion date be advanced or delayed by this change? Which milestone dates, if any, would be affected?
Cost Impact: What is the estimated incremental cost (or cost saving) associated with this change in United States dollars? What would be the new Estimate at Completion if the change is approved?
Quality Impact: Would this change affect the defined acceptance criteria for any project deliverable? Would additional testing or quality assurance activities be required?
Risk Impact: Does this change introduce new risks or modify the severity of existing risks in the Risk Register? If so, have these risks been logged and assessed?
Stakeholder Impact: Which stakeholders would be affected by this change? How should they be notified and engaged regarding the change?
Resource Impact: Does this change require additional personnel, skills, technology, or vendor resources not currently available to the project?
11.5 Change Implementation and Baseline Update Procedure
Upon formal approval of a Change Request by the appropriate authority, the Project Manager is responsible for implementing the approved change in an orderly and controlled manner. The following steps must be completed within five business days of the approval decision for all Minor and Moderate changes, and within ten business days for Major changes:
The Project Manager updates the relevant baseline documents — Project Schedule Baseline, Cost Baseline, and Scope Baseline — in SharePoint to reflect the approved change. The updated baseline documents must be version-controlled with a new version number and the Change Request Identifier recorded in the document revision history.
The Project Manager updates the Work Breakdown Structure and Microsoft Planner task board to reflect any new, modified, or removed tasks resulting from the approved change.
The Finance Controller updates the budget tracking records in SharePoint to reflect the approved cost impact of the change.
The Risk Manager reviews the risk register for any risks introduced or modified by the approved change and updates the Risk Register accordingly.
The Communications Manager distributes formal notification of the approved change to all affected stakeholders in accordance with the Communication Plan.
The Change Request record in the SharePoint Change Requests list is updated to a status of "Implemented" with the implementation date recorded.
The automated Power Automate flow defined in Flow 6.3 triggers a Power Business Intelligence dataset refresh to ensure the dashboard reflects the updated baselines.
11.6 Emergency Change Protocol
The Emergency Change Protocol applies when an immediate change is required to prevent imminent project failure, regulatory non-compliance, safety risk, or irreversible harm, and when the standard Change Control Board review cycle cannot be completed within the required timeframe. The following procedure governs Emergency Changes:
The Project Manager contacts the Executive Sponsor directly via Teams direct message or telephone to describe the nature and urgency of the required change and obtain verbal authorization to proceed.
The Project Manager submits the Emergency Change Request Form via Microsoft Forms, selecting "Emergency" as the classification. Flow 6.3 routes the request directly to the Project Manager and Executive Sponsor for immediate decision rather than to the Change Control Board.
Upon receipt of verbal authorization from the Executive Sponsor, the Project Manager may immediately implement the emergency change while simultaneously completing the formal documentation.
Within twenty-four hours of implementing the emergency change, the Project Manager must ensure that the formal Change Request Form is complete and has been digitally approved by both the Project Manager and the Executive Sponsor in the SharePoint system.
Within five business days of implementation, the Change Control Board conducts a retrospective review of the emergency change to assess its impact, confirm its appropriateness, and determine whether any further corrective actions are required. The retrospective review findings are documented in the Change Request record in SharePoint.
All Emergency Changes are subject to the same baseline update procedure defined in Section 11.5, which must be completed within three business days of the Executive Sponsor's formal digital approval.
Section 12: Procurement and Vendor Management
12.1 Procurement Planning
Procurement planning is the process of determining what project needs can best be met by acquiring products, services, or results from external sources, and documenting the approach to sourcing those external resources. During the Planning Phase, the Project Manager and Procurement Officer jointly develop the Procurement Management Plan — a subsidiary plan of the Project Management Plan — which documents all planned procurement activities, identifies the specific goods and services to be procured, defines the contract types and approval thresholds that will apply, and establishes the vendor performance monitoring approach that will be used throughout the project lifecycle.
The Procurement Management Plan must be reviewed and approved by the Finance Controller before it is incorporated into the Project Management Plan baseline. All planned procurements must be budgeted within the approved project budget defined in Section 3.8 of the Project Charter. Any procurement not anticipated in the Procurement Management Plan requires a Change Request submission in accordance with the process defined in Section 11 before a purchase commitment is made.
12.2 Vendor Selection Criteria
All vendor selection activities conducted under this Reference Guide must be governed by the organization's Procurement Policy and must apply objective, documented selection criteria. The following standard vendor selection criteria apply to all procurements unless the Procurement Officer documents a justified deviation in the Procurement Management Plan:
Technical Capability: The vendor's demonstrated ability to deliver the required goods or services to the specified quality standards and acceptance criteria.
Experience and References: The vendor's track record of delivering similar goods or services to organizations of comparable size and complexity, including verifiable references from prior engagements.
Financial Stability: Evidence of the vendor's financial health and organizational stability, including financial statements or third-party credit assessments where appropriate.
Pricing and Value for Money: The total cost of the vendor's offering relative to the value delivered, evaluated on a total cost of ownership basis rather than on initial price alone.
Compliance and Regulatory Standing: The vendor's compliance with all applicable laws, regulations, and organizational policies, including data privacy, labor standards, and environmental requirements.
Delivery Schedule and Capacity: The vendor's ability to deliver within the project's required timeframe and their demonstrated capacity to meet the project's volume and complexity requirements.
12.3 Contract Types and Approval Thresholds
The following contract types are available for use on projects governed by this Reference Guide, subject to the approval thresholds defined below. All contracts must be reviewed by the organization's Legal Counsel before execution and must be filed in the Contracts document library in the project SharePoint site upon execution.
| Contract Type | Description | Best Used When | Approval Threshold |
|---|---|---|---|
| Fixed Price | A firm price is agreed for all work defined in the statement of work; cost risk is borne by the vendor | Scope is well-defined and stable; risk of scope change is low | Up to [threshold]: Procurement Officer; above: Finance Controller plus Executive Sponsor |
| Time and Materials | Payment is based on actual labor hours at agreed rates plus actual material costs; cost risk is shared between the organization and the vendor | Scope is partially defined; flexibility in effort level is required | Procurement Officer plus Finance Controller for all Time and Materials contracts above a specified minimum value |
| Cost Plus Fixed Fee | The organization reimburses the vendor's actual allowable costs plus a fixed fee; cost risk is borne primarily by the organization | Scope is highly uncertain; work is primarily research or development in nature | Finance Controller plus Executive Sponsor for all Cost Plus contracts |
| Not to Exceed | A hybrid Time and Materials contract with a maximum ceiling price; cost risk is capped for the organization | Scope is partially uncertain but a maximum budget commitment is required | Same as Time and Materials |
12.4 Vendor Performance Monitoring
Vendor performance is monitored on an ongoing basis throughout the contract period using a combination of automated Power Business Intelligence reporting and periodic formal performance review meetings. The Procurement Officer is responsible for entering vendor performance data — including delivery milestone completion, quality of deliverables received, responsiveness to issues, and compliance with contract terms — into the Vendor Performance SharePoint list on a monthly basis. This data is integrated into the Power Business Intelligence data model and is displayed on the Individual Project Health Dashboard in a dedicated vendor performance summary section.
Formal vendor performance review meetings are conducted by the Procurement Officer and Project Manager at monthly intervals for contracts exceeding a defined value threshold, and quarterly for smaller contracts. The outcomes of each performance review are documented in the Vendor Performance SharePoint list and any performance concerns are raised as issues in the Issue Log. If a vendor's performance consistently falls below the defined threshold — specifically, if the vendor receives a composite performance rating below three on a five-point scale for two consecutive monthly review periods — the Project Manager and Procurement Officer must initiate a formal vendor performance improvement process and notify the Finance Controller.
12.5 Purchase Order and Invoice Approval Flows
All purchase orders and vendor invoices are processed through an automated approval flow built in Power Automate. The flow is triggered when a purchase order is created or an invoice is submitted to the designated Finance document library in the project SharePoint site. The flow routes the purchase order or invoice to the appropriate approvers based on the monetary value and contract type, as defined in the approval threshold table in Section 12.3. Approvers receive a Teams adaptive card requesting their digital approval or rejection, with the option to include comments.
Upon approval, the flow records the approval in the Financial Tracking SharePoint list, updates the Budget Actuals data model for the Power Business Intelligence dashboard, and sends a confirmation notification to the Procurement Officer and Finance Controller. Upon rejection, the flow notifies the submitter with the rejection reason and creates an action item for the Procurement Officer to address the rejection condition. All purchase order and invoice records, including the complete approval audit trail, are archived in the Finance document library in SharePoint and retained in accordance with the document retention policy defined in Section 13.5.
Section 13: Project Closure and Archival Procedure
13.1 Formal Acceptance and Sign-Off Process
Formal project closure begins with the formal acceptance of all project deliverables by the authorized receiving party — typically the Executive Sponsor or the operational team inheriting the project's outputs. Formal acceptance is evidenced by the completion and digital signature of a Deliverable Acceptance Record for each major deliverable defined in the Project Charter and Project Management Plan. Deliverable Acceptance Records are stored in the Deliverable Acceptance document library in the project SharePoint site and are incorporated by reference into the Project Closure Report.
The Project Manager is responsible for ensuring that all Deliverable Acceptance Records are completed and signed before initiating the project closure activities. If a deliverable is not formally accepted — due to outstanding defects, non-conformances, or stakeholder disagreements — the issue must be resolved through the defect management process defined in Section 8.5 and the change control process defined in Section 11 before the project can advance to formal closure. The Project Manager updates the project status in the Project Registry SharePoint list to "Closing" only after all deliverables have been formally accepted, which triggers the Lessons Learned Collection Flow defined in Flow 6.7.
13.2 Contract Closeout
Contract closeout is the process of verifying that all work performed by vendors and contractors has been completed in accordance with the contract terms, all deliverables have been formally accepted, all invoices have been paid and reconciled, and all contractual obligations on both sides have been fulfilled. The Procurement Officer is responsible for coordinating the contract closeout process for all active contracts. For each contract, the Procurement Officer must complete a Contract Closeout Checklist — maintained in the Project Management Office's contract management document library on SharePoint — confirming that all specified conditions have been met.
Upon completion of the Contract Closeout Checklist, the Procurement Officer notifies the Finance Controller, who confirms that all final payments have been processed and that there are no outstanding financial obligations under the contract. The Finance Controller's confirmation, together with the completed Contract Closeout Checklist, constitutes the formal record of contract closeout and is filed in the Contracts document library in the project SharePoint site. The Procurement Officer sends a formal contract closeout notification to each vendor upon completion of their respective contract closeout process.
13.3 Lessons Learned Facilitation
The lessons learned process is a mandatory component of project closure for all projects governed by this Reference Guide, regardless of project size, duration, or outcome. Lessons learned are systematically collected through the automated survey process defined in Flow 6.7, analyzed by Copilot to identify recurring themes and improvement opportunities, and compiled into the Lessons Learned Register in SharePoint and the Lessons Learned Repository accessible through the Power Business Intelligence Page 6 dashboard. The Project Manager is responsible for facilitating a formal Lessons Learned Workshop — conducted via Teams — at which the project team reviews, discusses, and validates the Copilot-generated lessons learned summary before it is finalized.
Lessons learned identified during the project closure process must be categorized by project phase (Initiating, Planning, Executing, Monitoring and Controlling, or Closing) and by category (People, Process, Technology, or Communication). For each lesson identified, the Lessons Learned Register must capture: the lesson title, description, category, phase, the specific impact the lesson had on the project, the recommended improvement action for future projects, the individual or role responsible for implementing the improvement, and the target implementation date. The Project Management Office Director is responsible for ensuring that high-priority lessons learned are reviewed during the quarterly Project Management Office process improvement review and are incorporated into future versions of this Reference Guide or the associated templates and training materials as appropriate.
13.4 Benefits Realization Measurement
Benefits realization measurement is the process of assessing the extent to which the benefits defined in the Project Charter and Business Case have been achieved as a result of the project. Benefits realization assessment is conducted during project closure and, for projects with benefits that materialize over an extended period post-closure (for example, cost savings or revenue growth), is conducted again at defined intervals after project closure — typically at six months and twelve months post-closure — in accordance with the Benefits Realization Plan developed during the Planning Phase.
The Project Manager, in coordination with the Finance Controller and the Executive Sponsor, completes the Benefits Realization Report template during the Closing Phase. The report assesses each benefit defined in Section 3.2 of the Project Charter against the specific metric and target value defined in Section 3.3, documenting the actual value achieved, the variance from the target, the explanation for any material variance, and any further actions required to realize the full intended benefit. For benefits that are expected to materialize post-closure, the Benefits Realization Report identifies the responsible operational role who will conduct the post-closure benefits tracking and the mechanisms — typically Power Business Intelligence reports connected to operational data systems — through which benefits will be measured and reported.
13.5 Document Archival and Retention Policy
All project documents — including the Project Charter, Project Management Plan and all subsidiary plans, risk register, issue log, change request records, meeting records, status reports, deliverable acceptance records, contract documents, lessons learned records, and the Project Closure Report — must be formally archived in the designated Project Archive folder within the Project Management Office SharePoint archive site upon project closure. The archival process is initiated automatically by the Lessons Learned Collection Flow defined in Flow 6.7 when the project status is set to "Closing." The Microsoft Power Platform Administrator is responsible for ensuring that the archive folder structure is correctly maintained and that all archived documents are properly indexed and searchable.
The following document retention periods apply to all archived project documents and are governed by the organization's Records Management Policy. These retention periods supersede any shorter document retention periods that may be specified in individual project plans:
| Document Category | Minimum Retention Period | Retention Trigger |
|---|---|---|
| Project Charter and Business Case | Seven years | From date of formal project closure |
| Project Management Plan (all versions) | Seven years | From date of formal project closure |
| Financial records (budgets, actuals, invoices, purchase orders) | Seven years | From date of last transaction |
| Contract documents | Ten years | From contract expiration date |
| Deliverable Acceptance Records | Seven years | From date of formal project closure |
| Risk and Issue records | Five years | From date of formal project closure |
| Meeting records and transcripts | Three years | From date of meeting |
| Lessons Learned Register | Permanent (maintained in the organizational Lessons Learned Repository) | Not applicable |
| Project Closure Report | Seven years | From date of formal project closure |
13.6 Transition to Operations
The transition of project outputs to the operational team responsible for their ongoing maintenance, use, and support is a critical final activity of the project lifecycle and must be formally planned and executed to ensure continuity of operations and the sustained realization of project benefits. The Project Manager, in coordination with the Technical Lead and Solution Architect and the relevant operational leadership, must develop a Transition Plan as a component of the Project Management Plan during the Planning Phase, specifying the activities, timeline, resource requirements, and acceptance criteria for the transition of each project deliverable to operations.
The Transition Plan must address, at minimum: the operational readiness criteria that must be met before the transition occurs; the training and knowledge transfer activities required to equip operational staff to manage and support the transitioned deliverables; the documentation — including user manuals, technical specifications, support procedures, and escalation paths — that must be completed and transferred to the operational team; the support model that will govern the project team's availability to assist the operational team during the transition period (typically thirty to ninety days post-closure, depending on the complexity of the deliverables); and the formal handover meeting or ceremony at which the Project Manager formally transfers ownership of all deliverables to the operational team leadership, with both parties signing the Transition Acceptance Record.
Section 14: Governance Framework and Compliance
14.1 Project Management Office Governance Model
The Project Management Office operates under a Controlling Project Management Office model — a Project Management Office governance structure in which the Project Management Office both provides project management support and enforces compliance with organizational project management standards, methodologies, and tools across all governed projects. In this model, the Project Management Office Director has the authority to audit project compliance with this Reference Guide, to require corrective actions when deviations are identified, and to recommend the suspension or termination of projects that persistently fail to meet governance requirements.
The Project Management Office conducts governance activities at three levels: project-level governance (through the quality gates, audits, and automated monitoring defined in this Reference Guide), portfolio-level governance (through the monthly Portfolio Review Briefing and the Power Business Intelligence Executive Portfolio Overview dashboard), and process-level governance (through the quarterly Process Improvement Review at which lessons learned from closed projects are evaluated for incorporation into this Reference Guide and associated standards). All Project Management Office governance activities are documented and maintained in the Project Management Office Governance Log in SharePoint.
14.2 Audit and Compliance Requirements
All projects governed by this Reference Guide are subject to periodic compliance audits conducted by the Project Management Office. The Project Management Office Director schedules at minimum one formal compliance audit for each active project per calendar quarter. The audit reviews the project's adherence to the processes, documentation standards, and automated workflow requirements defined in this Reference Guide and assesses whether the project's automated flows are operating correctly and producing accurate data for the Power Business Intelligence dashboard. Audit findings are classified as Critical (requiring remediation within five business days), Major (requiring remediation within fifteen business days), or Minor (requiring remediation within thirty business days) and are tracked in the Audit Findings SharePoint list until remediated and closed.
In addition to the Project Management Office compliance audits, projects may be subject to internal audit activities conducted by the organization's Internal Audit function, external audits conducted by regulatory bodies or certification authorities, and client audits where contractually required. The Project Manager is responsible for ensuring that all requested audit documentation is available and current in the project SharePoint site at all times, and for coordinating the project team's participation in any audit activities.
14.3 Data Governance for Microsoft Power Platform
All data created, processed, or stored within the Power Platform environment used by this automated project management process — including data in Power Automate flows, Power Business Intelligence datasets, Dataverse tables, and SharePoint lists — is subject to the organization's Data Governance Policy. The Microsoft Power Platform Administrator is responsible for ensuring that all Power Platform resources comply with the applicable data classification, access control, and data lifecycle management requirements defined in the Data Governance Policy.
Data classification for project management data follows the organization's standard data classification scheme: Public (information approved for unrestricted distribution), Public Edition (information intended for use by authorized employees and contractors), Confidential (information that could cause harm to the organization or individuals if disclosed), and Restricted (information subject to the highest level of access control and requiring explicit approval for access). Most project management data falls within the Public Edition classification; financial data and personally identifiable information of project participants may fall within the Confidential classification and must be handled accordingly.
14.4 License and Access Management
Access to all Power Platform and Microsoft 365 resources used in this automated project management process is governed by the principle of least privilege — the principle that each user should be granted only the minimum level of access necessary to perform their defined role and responsibilities. The Microsoft Power Platform Administrator is responsible for maintaining the access control matrix for all Power Platform resources, ensuring that role assignments are current and accurate, and conducting a quarterly access review to identify and revoke any access that is no longer required.
The following license requirements apply to the automated project management process. The Microsoft Power Platform Administrator, in coordination with the organization's IT Licensing Manager, is responsible for ensuring that all required licenses are provisioned and maintained:
Microsoft Copilot License: Required for all roles that use Copilot functionality — specifically, the Project Manager, Deputy Project Manager, Business Analyst, Communications Manager, Risk Manager, and Microsoft Copilot Coordinator, at minimum.
Microsoft Power Automate Per-User or Per-Flow License: Required for the Microsoft Power Platform Administrator and for each automated flow that uses premium connectors. The specific license type is determined by the connector requirements of each flow as documented in the Flow Specifications in Section 6.
Microsoft Power Business Intelligence Pro or Premium License: Required for all users who access the project management dashboard through the Power Business Intelligence service and who are not covered by a Premium capacity workspace allocation. All roles defined in Section 2 that interact with the Power Business Intelligence dashboard require at minimum a Power Business Intelligence Pro license.
Microsoft 365 E3 or E5 License: Required for all project team members to access Teams, SharePoint, Outlook, Planner, and Forms. Roles that require advanced security and compliance features — specifically the Microsoft Power Platform Administrator and Microsoft Copilot Coordinator — require a Microsoft 365 E5 license or equivalent add-on licensing.
14.5 Data Loss Prevention Policies in Microsoft Power Automate
Data loss prevention policies — governance configurations within the Power Platform that restrict which connectors can be used together within a single Power Automate flow, thereby preventing the unintentional transfer of sensitive organizational data to unauthorized external services — are configured and maintained by the Microsoft Power Platform Administrator in the Power Platform Administration Center. These policies are a critical component of the organization's data security posture and must be reviewed and updated whenever new connectors are introduced into the automated project management environment or whenever the organization's data security requirements change.
The following data loss prevention policy rules apply to all Power Automate flows within the project management environment. These rules define which connectors are classified as "Business" (permitted for use with organizational data), "Non-Business" (permitted for personal or non-organizational use only), and "Blocked" (prohibited from use in any flow within the governed environment):
Business (Permitted) Connectors: SharePoint, Microsoft Teams, Microsoft Outlook, Microsoft Planner, Microsoft Forms, Microsoft Graph Application Programming Interface (HTTP with Azure Active Directory — Microsoft's cloud-based identity and access management service), Dataverse, Power Business Intelligence, Microsoft Project Online, and all other Microsoft first-party connectors explicitly approved by the Microsoft Power Platform Administrator.
Non-Business (Restricted) Connectors: Consumer social media connectors, personal email connectors, and any third-party connector not explicitly classified as Business. These connectors may be permitted in non-production environments for testing purposes only, with explicit written authorization from the Project Management Office Director.
Blocked Connectors: All connectors that would transmit organizational data to external, non-approved, or unknown endpoints. The blocked connector list is maintained by the Microsoft Power Platform Administrator and is updated at a minimum on a quarterly basis.
Any request to add a new connector to the Business (Permitted) category must be submitted to the Microsoft Power Platform Administrator as a formal connector approval request. The Microsoft Power Platform Administrator reviews the request with the Data Governance Officer and, if approved, updates the data loss prevention policy within ten business days of approval. All data loss prevention policy changes are logged in the Power Platform Governance Log in SharePoint.
Section 15: Glossary of Terms
The following alphabetical glossary defines all technical terms, acronyms, tool names, and specialized project management terminology used within this Reference Guide. Every acronym is listed with its full expansion. This glossary serves as the authoritative reference for all terminology used in this document and in all associated project management documentation produced under this Reference Guide.
| Term or Acronym | Full Expansion (if acronym) | Definition |
|---|---|---|
| Acceptance Criteria | Not an acronym | The specific conditions or standards that a deliverable must meet in order to be formally accepted by the authorized receiving party. Acceptance criteria are defined in the Project Charter and subsidiary plans and are evaluated during quality control inspections and milestone gate reviews. |
| AC | Actual Cost | See "Actual Cost." |
| Actual Cost | Not an acronym | The realized cost incurred for work accomplished on the project during a specific time period. Actual Cost is one of the three core Earned Value Analysis parameters and is used to calculate Cost Variance and the Cost Performance Index. Abbreviated as "AC." |
| Adaptive Card | Not an acronym | A platform-agnostic UI (User Interface) snippet used within Microsoft Teams that allows automated flows to present interactive forms, approval requests, and information cards directly within the Teams interface, enabling users to respond to automated requests without leaving the Teams environment. |
| Agile | Not an acronym | An iterative and incremental approach to project management and product development that emphasizes flexibility, collaboration, continuous delivery of working increments, and rapid response to change. Agile is one of the three development approaches described in Section 4.8 of this Reference Guide. |
| API | Application Programming Interface | See "Application Programming Interface." |
| Application Programming Interface | Not an acronym | A defined set of rules, protocols, and tools that allows software applications to communicate with each other programmatically. In the context of this Reference Guide, the Microsoft Graph Application Programming Interface is used to enable Power Automate to interact with Microsoft Planner, Microsoft Teams, and Microsoft Outlook calendar data. Abbreviated as "API." |
| Artificial Intelligence | Not an acronym (commonly abbreviated "AI") | The simulation of human intelligence processes — including learning, reasoning, problem-solving, and language understanding — by computer systems. In the context of this Reference Guide, Artificial Intelligence refers specifically to the large language model technology underlying Microsoft Copilot. Commonly abbreviated as "AI." |
| BAC | Budget at Completion | See "Budget at Completion." |
| Budget at Completion | Not an acronym | The total approved budget for the project — the sum of all authorized budget amounts allocated to the project scope. Budget at Completion is used as the denominator in the calculation of the Variance at Completion. Abbreviated as "BAC." |
| Baseline | Not an acronym | An approved plan for the project — encompassing scope, schedule, and/or cost — against which project performance is measured and controlled. Baselines may only be changed through the formal change control process defined in Section 11 of this Reference Guide. |
| Benefits Realization | Not an acronym | The process of ensuring that the benefits defined in the Project Charter and Business Case are actually delivered and sustained following the project's completion. Benefits Realization measurement is a formal closing activity under this Reference Guide, as described in Section 13.4. |
| Business Analyst | Not an acronym | The project role responsible for eliciting, documenting, and validating business and functional requirements, and for translating organizational needs into actionable project scope. Fully defined in Section 2.1 of this Reference Guide. |
| CCB | Change Control Board | See "Change Control Board." |
| Change Control Board | Not an acronym | A formal governance body responsible for reviewing, evaluating, and rendering decisions on all change requests submitted to a project. The composition and voting rules of the Change Control Board are defined in Section 11.3 of this Reference Guide. Abbreviated as "CCB." |
| Change Request | Not an acronym | A formal document submitted through the Microsoft Forms Change Request Form requesting a modification to the project's approved scope, schedule, cost, or quality baseline. All Change Requests are processed through the automated Change Control Board Approval Flow defined in Flow 6.3 of this Reference Guide. |
| Complexity | Not an acronym | In the context of the Project Management Body of Knowledge Seventh Edition and the Uncertainty Performance Domain, complexity refers to the result of human behavior, system interactions, and ambiguity that make projects difficult to manage using linear or reductionist approaches. Complexity is one of four components of the Uncertainty Performance Domain. |
| Copilot | Not an acronym | Microsoft Copilot — the Artificial Intelligence assistant embedded throughout Microsoft 365 applications and the Power Platform that leverages large language model technology to assist project personnel with drafting, summarizing, analyzing, and querying data. Governance standards for Copilot use are defined in Section 5.8 of this Reference Guide. |
| CPI | Cost Performance Index | See "Cost Performance Index." |
| Cost Performance Index | Not an acronym | The ratio of Earned Value to Actual Cost, calculated as Earned Value divided by Actual Cost. The Cost Performance Index indicates cost efficiency: a value greater than one indicates the project is delivering more value per dollar spent than planned (under budget); a value less than one indicates the project is delivering less value per dollar spent than planned (over budget). Abbreviated as "CPI." |
| Cost Variance | Not an acronym | The difference between Earned Value and Actual Cost, calculated as Earned Value minus Actual Cost. A positive Cost Variance indicates the project is under budget; a negative Cost Variance indicates the project is over budget. Abbreviated as "CV." |
| CV | Cost Variance | See "Cost Variance." |
| Dataverse | Not an acronym | Microsoft Dataverse — the enterprise-grade, cloud-based data platform underpinning the Microsoft Power Platform, used in this Reference Guide to store structured project data, team member dimension data, and risk category dimension data. Dataverse provides relational integrity, advanced security controls, and native integration with Power Automate, Power Business Intelligence, and Power Apps. |
| Data Loss Prevention Policy | Not an acronym | A governance configuration within the Microsoft Power Platform Administration Center that restricts which connectors may be used together within a single Power Automate flow, thereby preventing the unintentional transfer of sensitive organizational data to unauthorized external services. Data Loss Prevention Policies are described in Section 14.5 of this Reference Guide. |
| Deliverable | Not an acronym | Any unique and verifiable product, result, or capability produced as a result of executing the project, as defined in the Project Charter and Work Breakdown Structure. Deliverables must be formally inspected against their acceptance criteria before being presented for stakeholder approval at a milestone gate review. |
| DLP | Data Loss Prevention | Commonly used abbreviation for Data Loss Prevention Policy. See "Data Loss Prevention Policy." |
| EAC | Estimate at Completion | See "Estimate at Completion." |
| Earned Value | Not an acronym | The authorized budget associated with scheduled work that has actually been accomplished at a given point in time. Earned Value is one of the three core Earned Value Analysis parameters and is used to calculate Schedule Variance, Cost Variance, the Schedule Performance Index, and the Cost Performance Index. Abbreviated as "EV." |
| Earned Value Analysis | Not an acronym | A methodology that integrates scope, schedule, and cost performance data to provide a comprehensive, objective picture of project performance and to enable forecasting of future performance. Earned Value Analysis metrics are automatically calculated and displayed in the Power Business Intelligence dashboard described in Section 7 of this Reference Guide. Abbreviated as "EVA." |
| Earned Value Management | Not an acronym | The broader project management practice encompassing the planning, measurement, analysis, and management activities that use Earned Value Analysis as the primary performance measurement framework. Abbreviated as "EVM." |
| ETC | Estimate to Complete | See "Estimate to Complete." |
| Estimate at Completion | Not an acronym | The expected total cost of completing all project work, calculated as Actual Cost plus the Estimate to Complete. Estimate at Completion is a forward-looking performance forecast used to predict the final cost of the project based on current performance data. Abbreviated as "EAC." |
| Estimate to Complete | Not an acronym | The expected cost needed to finish all remaining project work. Estimate to Complete is used in the calculation of the Estimate at Completion and represents the Project Manager's best estimate of the resources required to complete all remaining scope. Abbreviated as "ETC." |
| EV | Earned Value | See "Earned Value." |
| EVA | Earned Value Analysis | See "Earned Value Analysis." |
| EVM | Earned Value Management | See "Earned Value Management." |
| Executive Sponsor | Not an acronym | The senior organizational leader who holds ultimate accountability for the strategic outcome and business value of the project. The Executive Sponsor authorizes the Project Charter, secures funding, removes organizational impediments, and provides final approval of the Project Closure Report. Fully defined in Section 2.1 of this Reference Guide. |
| Gate Review | Not an acronym | A formal structured review conducted at the completion of a project milestone, at which the Project Steering Committee evaluates the milestone's deliverables against defined acceptance criteria and renders a formal approval or rejection decision. Gate reviews are automated through the Milestone Completion and Gate Review Flow defined as Flow 6.4 in this Reference Guide. |
| Hybrid Approach | Not an acronym | A project development approach that combines elements of both predictive (waterfall) and agile methodologies, typically applying predictive methods for overall governance, schedule management, and reporting while using agile iterative cycles for specific delivery components. Described in Section 4.8 of this Reference Guide. |
| Issue Log | Not an acronym | The centralized SharePoint list used to record and track all project issues — current conditions or events that are already negatively affecting the project and require resolution — as distinct from risks, which are uncertain future events. The Issue Log is monitored through the Power Business Intelligence Risk and Issue Management View. |
| KPI | Key Performance Indicator | See "Key Performance Indicator." |
| Key Performance Indicator | Not an acronym | A quantifiable measurement used to evaluate the degree to which an individual, project, or organization is achieving a defined objective or target. Key Performance Indicators used in the project management context include the Schedule Performance Index, Cost Performance Index, and milestone completion rate. Abbreviated as "KPI." |
| Large Language Model | Not an acronym | A type of artificial intelligence model trained on vast quantities of text data that is capable of understanding, generating, summarizing, and translating natural human language. Microsoft Copilot is powered by a large language model. Abbreviated as "LLM." |
| Lessons Learned Register | Not an acronym | The centralized SharePoint list in which all lessons learned from project execution are recorded, categorized by phase and category, and preserved for organizational reference. The Lessons Learned Register is populated through the automated Lessons Learned Collection Flow defined as Flow 6.7 in this Reference Guide. |
| LLM | Large Language Model | See "Large Language Model." |
| Microsoft 365 | Not an acronym | Microsoft's comprehensive cloud-based productivity and collaboration suite, encompassing applications including Teams, Outlook, SharePoint, Planner, Forms, Word, Excel, PowerPoint, and Copilot. Microsoft 365 is the primary technology platform underlying all tools described in this Reference Guide. |
| Microsoft Forms | Not an acronym | A Microsoft 365 application used to create surveys, quizzes, and data collection forms. In this Reference Guide, Microsoft Forms is used as the trigger source for the Change Control Board Approval Flow (Flow 6.3) and the Lessons Learned survey distributed through Flow 6.7. |
| Microsoft Graph Application Programming Interface | Not an acronym (commonly abbreviated "Microsoft Graph API") | The Microsoft application programming interface that provides a unified endpoint for accessing data across Microsoft 365 services including Teams, Planner, Outlook, SharePoint, and Dataverse. Power Automate flows use the Microsoft Graph Application Programming Interface to retrieve Planner task data, create Outlook calendar events, and access Teams meeting metadata. |
| Microsoft Planner | Not an acronym | A Microsoft 365 task management application used within this Reference Guide as the primary tool for tracking Work Breakdown Structure tasks, assigning work to project team members, recording task completion percentages, and triggering the Milestone Completion and Gate Review Flow through the automated monitoring of milestone task status. |
| Microsoft Power Platform | Not an acronym | The integrated suite of low-code development, automation, and analytics tools provided by Microsoft, encompassing Power Automate, Power Business Intelligence, Power Apps, and Dataverse. The Power Platform is the foundational automation and analytics technology stack for all automated processes described in this Reference Guide. |
| Microsoft Project Online | Not an acronym | Microsoft's cloud-based enterprise project management solution that provides advanced scheduling, resource management, and portfolio management capabilities. Where applicable, Microsoft Project Online data is connected to the Power Business Intelligence data model described in Section 7.1 of this Reference Guide. |
| Milestone | Not an acronym | A significant point or event in a project schedule, typically representing the completion of a major deliverable or phase. Milestones have zero duration and trigger the automated gate review process defined in Flow 6.4 of this Reference Guide when their associated Microsoft Planner tasks are marked as complete. |
| OData | Open Data Protocol | An open standard data access protocol based on Representational State Transfer (REST) architectural principles, used to enable the querying and manipulation of data from external systems through standardized application programming interfaces. In this Reference Guide, OData feeds are used to connect the Power Business Intelligence data model to the organization's finance system for budget actuals data retrieval. |
| PII | Personally Identifiable Information | See "Personally Identifiable Information." |
| Personally Identifiable Information | Not an acronym | Any information that can be used alone or in combination with other information to identify a specific individual. In the context of this Reference Guide, Personally Identifiable Information must not be included in Microsoft Copilot prompts without explicit authorization from the Data Governance Officer and Privacy Officer, as defined in Section 5.8. Abbreviated as "PII." |
| Planned Value | Not an acronym | The authorized budget assigned to work scheduled to be accomplished by a given point in time. Planned Value represents what the project planned to have accomplished at a specific date, expressed in monetary terms. It is one of the three core Earned Value Analysis parameters. Abbreviated as "PV." |
| PMI | Project Management Institute | See "Project Management Institute." |
| PMO | Project Management Office | See "Project Management Office." |
| PMBOK | Project Management Body of Knowledge | See "Project Management Body of Knowledge Seventh Edition." |
| Power Automate | Not an acronym | Microsoft Power Automate — the cloud-based workflow automation platform used throughout this Reference Guide to build, deploy, and manage all automated flows. Power Automate connects to SharePoint, Teams, Planner, Outlook, Forms, Dataverse, and Power Business Intelligence through certified connectors, enabling event-driven automation across the project management lifecycle. Described in Section 6 of this Reference Guide. |
| Power Business Intelligence | Not an acronym | Microsoft Power Business Intelligence — the data visualization and business analytics platform used throughout this Reference Guide to build and maintain the project management performance dashboards described in Section 7. Power Business Intelligence provides interactive visual reports, natural language query capabilities, automated report distribution, row-level security, and mobile application access to project performance data. |
| Predictive Approach | Not an acronym | A project development approach — also known as a "waterfall" approach — in which the project scope is defined comprehensively upfront and work proceeds sequentially through planned phases (Initiating, Planning, Executing, Monitoring and Controlling, and Closing) with minimal iteration. Described in Section 4.8 of this Reference Guide. |
| Project Charter | Not an acronym | The formal document that officially authorizes the existence of the project and grants the Project Manager the authority to apply organizational resources to project activities. The complete Project Charter template is defined in Section 3 of this Reference Guide. |
| Project Management Body of Knowledge Seventh Edition | Not an acronym (abbreviated "PMBOK Seventh Edition" informally) | The authoritative guide published by the Project Management Institute that defines the knowledge, skills, principles, and performance domains essential for effective project management practice. The Seventh Edition, published in 2021, emphasizes principles-based, outcomes-driven delivery through eight performance domains and twelve guiding principles. This Reference Guide is explicitly aligned with this edition. |
| Project Management Institute | Not an acronym | The globally recognized professional association for project management, headquartered in Newtown Square, Pennsylvania, United States of America, that establishes project management standards, certifications, and best practices. The Project Management Institute publishes the Project Management Body of Knowledge and other standards referenced in this Reference Guide. Abbreviated as "PMI." |
| Project Management Office | Not an acronym | The organizational function responsible for establishing, maintaining, and enforcing project management standards, methodologies, templates, and governance processes. The Project Management Office governs all projects subject to this Reference Guide and conducts periodic compliance audits as described in Section 14. Abbreviated as "PMO." |
| Project Manager | Not an acronym | The individual assigned with the day-to-day responsibility for planning, executing, monitoring, controlling, and closing a specific project. The Project Manager is the primary user of all automated project management tools defined in this Reference Guide. Fully defined in Section 2.1 of this Reference Guide. |
| Project Registry | Not an acronym | The centralized SharePoint list that serves as the master record of all projects governed by this Reference Guide. The Project Registry contains the Project Unique Identifier, project name, current phase, status, Project Manager assignment, and other key metadata for every project. It is the primary trigger source for several Power Automate flows, including the Lessons Learned Collection Flow (Flow 6.7). |
| PV | Planned Value | See "Planned Value." |
| RACI | Responsible, Accountable, Consulted, Informed | A responsibility assignment matrix framework that defines the roles and responsibilities of project participants across key deliverables and process activities. RACI stands for: Responsible (the individual who performs the work), Accountable (the individual who is ultimately answerable for the outcome — only one per activity), Consulted (individuals whose input is sought through two-way communication), and Informed (individuals who receive one-way communication about outcomes). The full RACI matrix for this Reference Guide is defined in Section 2.2. |
| Residual Risk | Not an acronym | The risk that remains after a risk response strategy has been implemented. Residual risks are assessed with their own Residual Probability and Residual Impact ratings and are continuously monitored by the Risk Manager throughout the project lifecycle, as described in Section 10.4 of this Reference Guide. |
| Risk Manager | Not an acronym | The project role responsible for overseeing the comprehensive identification, assessment, response planning, monitoring, and escalation of all project risks. The Risk Manager is the primary maintainer of the SharePoint Risk Register and receives immediate automated notifications for high-severity risk entries through the Risk and Issue Escalation Flow (Flow 6.2). Fully defined in Section 2.1 of this Reference Guide. |
| Risk Register | Not an acronym | The centralized SharePoint list used to record all identified project risks, their probability and impact assessments, response strategies, risk owners, and current statuses. The Risk Register is the primary data source for the Power Business Intelligence Risk and Issue Management View. The complete Risk Register field specification is defined in Section 10.6 of this Reference Guide, and a blank template is provided in Appendix B. |
| Rolling Wave Planning | Not an acronym | A project planning technique in which near-term work is planned in comprehensive detail while future work is planned at a higher level of abstraction, with the level of detail progressively increased as more information becomes available about future work. Rolling Wave Planning is the prescribed planning approach for all projects governed by this Reference Guide, as described in Section 4.9. |
| Row-Level Security | Not an acronym | A Power Business Intelligence feature that restricts which rows of data a given user can access in the data model based on their identity and assigned role. Row-Level Security is configured for the project management dashboard as described in Section 7.4 of this Reference Guide to ensure that users can access only the project data they are authorized to view. |
| Schedule Performance Index | Not an acronym | The ratio of Earned Value to Planned Value, calculated as Earned Value divided by Planned Value. The Schedule Performance Index indicates schedule efficiency: a value greater than one indicates the project is ahead of schedule; a value less than one indicates the project is behind schedule. Abbreviated as "SPI." |
| Schedule Variance | Not an acronym | The difference between Earned Value and Planned Value, calculated as Earned Value minus Planned Value. A positive Schedule Variance indicates the project is ahead of schedule; a negative Schedule Variance indicates the project is behind schedule. Abbreviated as "SV." |
| Scope Creep | Not an acronym | The uncontrolled expansion of project scope without corresponding adjustments to time, cost, and resources, typically resulting from the addition of work that has not been formally authorized through the change control process. Scope Creep is prevented under this Reference Guide through the mandatory change control process defined in Section 11. |
| SharePoint | Not an acronym | Microsoft SharePoint — the collaborative document and list management platform that serves as the primary data repository for all project management data in this Reference Guide. All project lists, document libraries, and automated flow trigger sources described in this Reference Guide are hosted on SharePoint. |
| SMART | Specific, Measurable, Achievable, Relevant, Time-bound | A framework for writing project objectives that ensures each objective is Specific (clearly defined), Measurable (quantifiable), Achievable (realistic within project constraints), Relevant (aligned with organizational strategy), and Time-bound (has a defined due date). All project objectives in the Project Charter must be written in SMART format, as required by Section 3.3 of this Reference Guide. |
| SPI | Schedule Performance Index | See "Schedule Performance Index." |
| Sprint | Not an acronym | A time-boxed iterative cycle — typically one to four weeks in duration — used in agile development approaches during which a defined set of work items is planned, executed, and reviewed. Sprints are the primary planning and delivery unit for projects using an agile or hybrid development approach under this Reference Guide. |
| Stakeholder | Not an acronym | Any individual, group, or organization that may affect, be affected by, or perceive themselves to be affected by a decision, activity, or outcome of the project. Stakeholders are identified, analyzed, and managed through the processes defined in Sections 3.9, 4.6, 6.6, and 9 of this Reference Guide. |
| Stakeholder Register | Not an acronym | The centralized SharePoint list that documents all identified project stakeholders, their interests, influence levels, current and desired engagement classifications, and communication preferences. The Stakeholder Register is populated during the Initiating Phase and maintained throughout the project lifecycle. New entries trigger the automated New Stakeholder Onboarding Flow (Flow 6.6). |
| SV | Schedule Variance | See "Schedule Variance." |
| Teams | Not an acronym | Microsoft Teams — the unified collaboration and communication platform that serves as the primary communication channel for all automated notifications, adaptive card approvals, meeting management, and real-time project collaboration in this Reference Guide. Each project is provisioned with a standardized Teams channel structure as defined in Section 9.5. |
| VAC | Variance at Completion | See "Variance at Completion." |
| Variance at Completion | Not an acronym | The difference between the Budget at Completion and the Estimate at Completion, calculated as Budget at Completion minus Estimate at Completion. A positive Variance at Completion indicates the project is forecast to complete under budget; a negative Variance at Completion indicates the project is forecast to complete over budget. Abbreviated as "VAC." |
| Volatility | Not an acronym | In the context of the Project Management Body of Knowledge Seventh Edition and the Uncertainty Performance Domain, volatility refers to the speed and unpredictability of change in the project environment, including rapid changes in technology, market conditions, regulatory requirements, or organizational priorities. Volatility is one of four components of the Uncertainty Performance Domain addressed in Section 4.13 of this Reference Guide. |
| WBS | Work Breakdown Structure | See "Work Breakdown Structure." |
| Work Breakdown Structure | Not an acronym | The hierarchical decomposition of the total project scope into progressively smaller, manageable components called work packages, each of which represents a discrete, estimable, and assignable unit of work. The Work Breakdown Structure is developed during the Planning Phase with Copilot assistance (as described in Section 5.2) and is implemented as a structured task hierarchy in Microsoft Planner. Abbreviated as "WBS." |
Appendix A: Project Charter Template (Blank — Ready to Complete)
This blank Project Charter template is to be completed by the Project Manager during the Initiating Phase. All shaded fields are mandatory. The completed charter must be submitted for review and approval in accordance with the process defined in Section 3 and Section 4.1 of this Reference Guide. Digital approval is collected through the automated charter approval process in Microsoft Teams.
| PROJECT CHARTER | |||
|---|---|---|---|
| Project Title: | |||
| Project Unique Identifier: | [Auto-generated by Power Automate] | Charter Version: | |
| Charter Date: | Sponsoring Department: | ||
| Proposed Start Date: | Proposed End Date: | ||
| Executive Sponsor: | Project Manager: | ||
| Section 1: Business Purpose and Justification | |||
| Business Problem or Opportunity: | |||
| Strategic Alignment: | |||
| Expected Benefits: | |||
| Section 2: Project Objectives (SMART Format) | |||
| Objective 1: Specific, Measurable, Achievable, Relevant, Time-bound statement: | |||
| Objective 2: | |||
| Objective 3: | |||
| Section 3: Scope Summary | |||
| In-Scope: | Out-of-Scope: | ||
| Section 4: High-Level Milestones | |||
| Milestone | Description | Target Date | Approver |
| Section 5: Budget Authorization | |||
| Total Authorized Budget (United States Dollars): | |||
| Contingency Reserve: | |||
| Section 6: Key Assumptions and Constraints | |||
| Assumptions: | Constraints: | ||
| Section 7: Initial Risk Summary | |||
| Risk Description | Probability (1–5) | Impact (1–5) | Response Strategy |
| Section 8: Approval Sign-off | |||
| Role | Printed Name | Signature | Date |
| Executive Sponsor | |||
| Project Steering Committee Chairperson | |||
| Project Management Office Director | |||
| Project Manager |
Appendix B: Risk Register Template (Blank — Ready to Complete)
The following blank Risk Register template is pre-configured with all mandatory fields as defined in Section 10.6 of this Reference Guide. This template corresponds to the structure of the SharePoint Risk Register list. Each row represents one individual risk record. The Risk Identifier and Severity Score fields are auto-calculated by SharePoint upon record creation and modification respectively and do not require manual entry.
| Risk Identifier | Project Identifier | Risk Title | Risk Description | Category | Probability (1–5) | Impact (1–5) | Severity Score | Response Strategy | Response Description | Risk Owner | Status | Date Identified | Target Resolution Date | Residual Probability | Residual Impact | Last Review Date | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| [Auto] | [Auto] | ||||||||||||||||
| [Auto] | [Auto] | ||||||||||||||||
| [Auto] | [Auto] |
Risk Category Reference Valid category values: Technical | Schedule | Financial | Resource | Stakeholder | External | Regulatory Valid response strategy values: Avoid | Transfer | Mitigate | Accept | Escalate Valid status values: Open | In Progress | Accepted | Closed |
Appendix C: Change Request Form Template (Blank — Ready to Complete)
The following Change Request Form is replicated from the Microsoft Forms source. All fields marked with an asterisk (*) are mandatory. This form is submitted via the Microsoft Forms link pinned in the project Teams Change Control channel and in the project SharePoint site. Submission of this form triggers the automated Change Control Board Approval Flow defined as Flow 6.3 in this Reference Guide.
| CHANGE REQUEST FORM | |
|---|---|
| Change Request Identifier:* | [Auto-generated by Power Automate upon submission] |
| Project Name and Identifier:* | |
| Date of Submission:* | |
| Submitter Name:* | |
| Submitter Role:* | |
| Change Request Title:* | |
| Change Description (full, formal detail required):* | |
| Business Rationale and Justification:* | |
| Change Classification:* | [ ] Minor [ ] Moderate [ ] Major [ ] Emergency |
| Scope Elements Affected:* | |
| Estimated Schedule Impact (in business days — positive = delay; negative = acceleration):* | |
| Estimated Cost Impact (in United States Dollars — positive = increase; negative = decrease):* | |
| Quality Impact (describe any changes to acceptance criteria or testing requirements):* | |
| Risk Impact (list any new risks or changes to existing risks introduced by this change):* | |
| Stakeholders Affected (list names or groups):* | |
| Resource Requirements (additional personnel, technology, or vendor resources required):* | |
| Supporting Documentation (attach or reference relevant documents): | |
| Change Control Board Decision (completed by Change Control Board — do not complete at submission): | |
| Decision: | [ ] Approved [ ] Rejected [ ] Deferred |
| Vote Tally: | Approve: ____ Reject: ____ Defer: ____ Total Votes Cast: ____ |
| Decision Date: | |
| Change Control Board Comments: | |
| Implementation Date (if Approved): |
Appendix D: Status Update Collection Form Fields
The following table defines all fields included in the weekly status update adaptive card delivered via Microsoft Teams through the Weekly Project Status Collection Flow (Flow 6.1). These fields are pre-populated where possible using data from the team member's active Planner task assignments and are presented in a formatted adaptive card interface for efficient data entry. All responses are automatically written to the Status Updates SharePoint list upon submission.
| Field Name | Data Type | Required | Description and Guidance |
|---|---|---|---|
| Project Identifier | Text (pre-populated) | Yes | Auto-populated from the project assignment record. No action required by the respondent. |
| Project Name | Text (pre-populated) | Yes | Auto-populated from the Project Registry. No action required by the respondent. |
| Reporting Week (week ending date) | Date (pre-populated) | Yes | Auto-populated with the date of the Sunday immediately following the Monday trigger date. No action required. |
| Team Member Name | Text (pre-populated) | Yes | Auto-populated from the organizational directory. No action required by the respondent. |
| Task Identifier | Text (pre-populated; one per assigned task) | Yes | Auto-populated from the team member's active Planner task assignments. One status entry is requested per active task. |
| Task Name | Text (pre-populated) | Yes | Auto-populated from the Planner task record. No action required. |
| Percentage Complete | Number (0–100; slider or numeric entry) | Yes | The respondent enters the estimated percentage of the task that has been completed as of the reporting date. This value updates the Planner task completion percentage automatically upon submission. |
| Hours Logged This Week | Number (decimal) | Yes | The total number of hours worked on this task during the reporting week. Used to calculate team utilization in the Power Business Intelligence Resource and Team Utilization dashboard page. |
| Blockers and Impediments | Free text (maximum five hundred characters) | No | A brief description of any blockers, impediments, or dependencies that are currently preventing or slowing progress on this task. If none, the respondent should enter "None." Entries in this field are highlighted in the Project Manager's weekly dashboard review. |
| New Risks Identified | Free text (maximum five hundred characters) | No | A brief description of any new risks identified during the reporting week that have not yet been entered in the Risk Register. The Project Manager reviews all entries in this field and enters confirmed risks into the SharePoint Risk Register within one business day. |
| Overall Project Health Assessment | Choice: Green / Yellow / Red | Yes | The respondent's subjective assessment of the overall health of the project from their perspective: Green (on track, no significant concerns), Yellow (some concerns that require attention but are manageable), or Red (significant issues that require immediate Project Manager intervention). This field is used to calculate the composite health badge on the Power Business Intelligence Individual Project Health Dashboard. |
| Additional Comments | Free text (maximum one thousand characters) | No | Any additional observations, concerns, accomplishments, or information the team member wishes to communicate to the Project Manager beyond what is captured in the structured fields above. |
| Submission Date and Time | Date and Time (auto-recorded) | Yes (auto-recorded) | Automatically recorded by the Power Automate flow at the moment of submission. Used to determine whether the submission was received within the required window or constitutes a late response. |
Appendix E: Lessons Learned Survey Questions
The following survey questions are used in the Microsoft Forms lessons learned survey distributed to all project participants through the Lessons Learned Collection Flow (Flow 6.7) upon the project entering Closing status. The survey is designed to elicit candid, constructive, and structured feedback that can be synthesized by Copilot into a comprehensive Lessons Learned Register. All questions are directed to the individual's personal experience on the project and are treated confidentially in aggregation; individual responses are visible only to the Project Manager and Project Management Office Director.
Overall Experience: On a scale of one to five — where one represents Extremely Dissatisfied and five represents Extremely Satisfied — how would you rate your overall experience of working on this project? Please explain your rating in two to three sentences.
Project Initiation and Charter: Was the project's purpose, scope, and expected outcomes clearly communicated to you at the outset of the project? If not, what information was missing or unclear, and how did this affect your ability to contribute effectively?
Planning Effectiveness: Were the project plan, work breakdown structure, schedule, and individual task assignments clear, reasonable, and well-communicated? What, if anything, would you recommend changing about the planning process for future projects?
Communication Quality: Were you kept adequately informed of project status, decisions, changes, and risks throughout the project? Were the communication channels — including Teams channels, status reports, and meeting records — effective for your needs? What improvements would you suggest?
Risk and Issue Management: Were risks and issues identified, communicated, and addressed in a timely and effective manner? Were there any risks or issues that were not identified early enough? If so, describe the impact and what could have been done differently.
Change Control Process: Were changes to the project scope, schedule, or budget handled in a structured, transparent, and fair manner? Were you adequately informed of approved changes and their impact on your work? What improvements to the change control process would you suggest?
Team Collaboration: How effectively did the project team collaborate — including sharing information, supporting each other, and working toward common goals? Were there any team dynamics or interpersonal issues that negatively affected the project? What could be done to improve team collaboration on future projects?
Automated Tools and Technology: How effective were the automated tools — including the Microsoft Teams status collection cards, Power Business Intelligence dashboard, and action item tracking flows — in supporting your work on this project? What improvements to the automated tools would have made your work easier?
Microsoft Copilot Usage: If you used Microsoft Copilot during this project, how useful did you find it? In which activities did Copilot add the most value? In which activities did Copilot fall short of expectations, and why?
Quality Management: Were the quality standards, acceptance criteria, and quality control processes clearly defined and consistently applied? Were any deliverables rejected at quality gates that, in your view, should not have been? What improvements to the quality management process would you recommend?
Resource Adequacy: Were sufficient personnel, skills, tools, and financial resources available to execute the project as planned? Were there periods of resource constraint that adversely affected the project? What would you recommend to improve resource planning on future projects?
Stakeholder Engagement: Were stakeholders adequately engaged throughout the project? Were there stakeholders whose concerns were not effectively addressed? What improvements to the stakeholder engagement approach would you recommend?
Most Significant Success: In your view, what was the single most significant success of this project — the thing that worked exceptionally well and should be deliberately replicated on future projects? Please describe in as much detail as possible.
Most Significant Improvement Opportunity: In your view, what was the single most important area for improvement on this project — the thing that, if done differently, would have had the greatest positive impact on the project's outcome? Please describe in as much detail as possible and propose a specific improvement action.
Overall Recommendation: Is there anything else you would like to share about your experience on this project that is not captured in the questions above? Any additional lessons, observations, or recommendations for the Project Management Office are welcomed here.
Appendix F: Power Automate Flow Trigger Reference Table
The following table provides a consolidated reference summary of all eight automated Power Automate flows defined in Section 6 of this Reference Guide. This table is maintained by the Microsoft Power Platform Administrator and is updated whenever flows are modified, deactivated, or replaced. The Flow Identifier in the first column corresponds to the subsection number in Section 6 where the full flow specification is documented.
| Flow ID | Flow Name | Trigger Type | Trigger Source | Trigger Condition | Frequency / Timing | Primary Recipients | Owner Role |
|---|---|---|---|---|---|---|---|
| PMO-FLOW-001 | Weekly Project Status Collection | Scheduled Recurrence | Power Automate Recurrence connector | Every Monday at 8:00 in the morning Eastern Time (holiday exclusion applied) | Weekly — every Monday | All active Project Team Members (via Teams adaptive card); Project Manager (escalation) | Microsoft Power Platform Administrator |
| PMO-FLOW-002 | Risk and Issue Escalation | Event-driven (item created or modified) + Scheduled Digest | SharePoint — Risk Register list | New Risk Register item created, OR existing item modified with Severity Rating of four or five; weekly digest every Friday at 4:00 in the afternoon Eastern Daylight Time | Real-time (item trigger); weekly (digest) | Risk Manager, Project Manager (immediate); Risk Manager, Project Manager, Deputy Project Manager (digest) | Microsoft Power Platform Administrator |
| PMO-FLOW-003 | Change Control Board Approval | Event-driven (form submission) | Microsoft Forms — Change Request Form | New response submitted to the Change Request Form | Real-time upon submission | Change Control Board Members (voting adaptive card); submitter and all stakeholders (decision notification) | Microsoft Power Platform Administrator |
| PMO-FLOW-004 | Milestone Completion and Gate Review | Event-driven (Planner task completion) | Microsoft Planner via Microsoft Graph Application Programming Interface | Planner task with "Milestone" category tag marked as 100% complete | Real-time upon milestone completion | Project Steering Committee (gate review adaptive card); all Project Team Members (approval announcement) | Microsoft Power Platform Administrator |
| PMO-FLOW-005 | Budget Variance Alert | Event-driven (SharePoint item created or modified) | SharePoint — Financial Tracking list | Actual Cost to Date exceeds Planned Cost to Date by more than ten percent | Real-time upon financial data entry | Finance Controller, Project Manager (ten percent threshold); Executive Sponsor additionally (twenty-five percent threshold) | Microsoft Power Platform Administrator |
| PMO-FLOW-006 | New Stakeholder Onboarding | Event-driven (SharePoint item created) | SharePoint — Stakeholder Register list | New item created in Stakeholder Register list | Real-time upon new stakeholder record creation | New stakeholder (welcome email via Outlook); Communications Manager (onboarding meeting invitation) | Microsoft Power Platform Administrator |
| PMO-FLOW-007 | Lessons Learned Collection and Project Archival | Event-driven (SharePoint item modified) | SharePoint — Project Registry list | Project Status field modified to value "Closing" | Event-driven; triggered once per project upon Closing status transition | All project participants (survey email via Outlook); Project Manager, Power Platform Administrator (archival confirmation via Teams) | Microsoft Power Platform Administrator |
| PMO-FLOW-008 | Meeting Action Item Tracking | Event-driven (SharePoint file created) | SharePoint — "Meeting Transcripts" document library folder | New Teams meeting transcript file saved to the "Meeting Transcripts" folder | Real-time upon transcript file creation | All meeting attendees (post-meeting summary via Teams); task owners (twenty-four-hour reminder via Teams direct message) | Microsoft Power Platform Administrator |
The following table summarizes the error handling approach common to all flows:
| Error Condition | Retry Logic | Fallback Action | Escalation |
|---|---|---|---|
| Teams adaptive card delivery failure | Retry three times at two-to-five minute intervals | Send equivalent notification via Microsoft Outlook email | Log to Flow Error Log in SharePoint; alert Microsoft Power Platform Administrator via Teams |
| SharePoint list write failure | Retry three times at five-minute intervals | Log failed record to Error Log; send manual action request to Power Platform Administrator | Alert Microsoft Power Platform Administrator via Teams |
| Power Business Intelligence refresh failure | Retry twice at fifteen-minute intervals | Notify recipients that dashboard data may be stale; direct to SharePoint list for raw data | Alert Microsoft Power Platform Administrator via Teams |
| Microsoft Graph Application Programming Interface call failure | Retry twice at five-minute intervals | Send notification via Outlook email; log failure for manual remediation | Alert Microsoft Power Platform Administrator via Teams |
| Flow run timeout (greater than thirty minutes) | Not applicable — flows are designed to complete within ten minutes under normal conditions | Flow run marked as failed; manual restart required by Power Platform Administrator | Automatic failure alert to Power Platform Administrator via Power Automate monitoring |
Appendix G: Microsoft Copilot Approved Prompt Library
The following twenty approved prompts constitute the official Microsoft Copilot prompt library for all recurring, standardized project management activities governed by this Reference Guide. All prompts have been reviewed and approved by the Microsoft Copilot Coordinator and the Data Governance Officer and are published in the Project Management Office SharePoint site for reference by all project personnel. Prompts may be customized to include project-specific details (indicated by square bracket placeholders), but the core structure and intent of each approved prompt must be preserved. Any prompt not included in this library that is intended for a recurring project management use case must be submitted to the Microsoft Copilot Coordinator for review and approval before use.
| Prompt Number | Prompt Name | Approved Prompt Text | Intended Use | Human Review Required |
|---|---|---|---|---|
| COP-001 | Project Charter Draft Generation | "Using the attached business case document and the Project Charter template from the Project Management Office SharePoint site, draft a formal Project Charter for the project titled [Project Title]. Ensure all SMART objectives are clearly stated, all in-scope and out-of-scope items are explicitly listed, and an initial risk summary of at least three risks is included. Use formal, professional language throughout." | Initiating Phase: accelerating the drafting of the Project Charter from the approved business case | Yes — mandatory review by Project Manager and Business Analyst before submission for approval |
| COP-002 | Initial Risk Register Generation | "Analyze the attached Project Charter and business case for [Project Title] and identify at least ten potential project risks. For each risk, provide: a Risk Title, a Risk Description, the Risk Category (Technical, Schedule, Financial, Resource, Stakeholder, External, or Regulatory), a Probability Rating from one to five, an Impact Rating from one to five, and a proposed Response Strategy. Format the output as a table." | Initiating Phase: generating an initial risk register for review by the Risk Manager | Yes — mandatory review and validation by Risk Manager before entry into SharePoint Risk Register |
| COP-003 | Stakeholder Meeting Summary | "Summarize the attached transcript of the stakeholder workshop for [Project Title] held on [Date]. Identify and list: the key stakeholder interests and concerns expressed, any requirements or scope items mentioned, any risks or issues raised, any decisions made, and any action items with owners and due dates. Format the summary in clear, professional language suitable for inclusion in the Stakeholder Register." | Initiating and Executing Phases: synthesizing stakeholder workshop transcripts into structured inputs | Yes — mandatory review by Communications Manager and Business Analyst |
| COP-004 | Work Breakdown Structure Draft Generation | "Based on the approved Project Charter for [Project Title], generate a draft Work Breakdown Structure with at least three levels of decomposition. Organize the Work Breakdown Structure by major project phases and deliverables. For each work package at the lowest level, include an estimated duration in business days and a suggested responsible role from the following list: [list of project roles]. Format the output as a hierarchical numbered list." | Planning Phase: generating an initial Work Breakdown Structure for review and refinement by the Project Manager | Yes — mandatory review by Project Manager, Business Analyst, and Technical Lead and Solution Architect |
| COP-005 | Communication Plan Draft Generation | "Using the attached Stakeholder Register for [Project Title], generate a draft Communication Plan in table format. For each stakeholder group, define the communication type, message content summary, frequency, delivery channel (Teams / Outlook / Power Business Intelligence / meeting), and responsible role. Ensure every stakeholder has at least one regular communication. Use formal language throughout." | Planning Phase: generating the Communication Plan as a subsidiary element of the Project Management Plan | Yes — mandatory review by Communications Manager before inclusion in Project Management Plan |
| COP-006 | Weekly Project Status Report Draft | "Using the attached status update data for [Project Name] for the week of [Week Ending Date], draft a formal weekly project status report. Include the following sections: Executive Summary (two to three sentences), Schedule Status (with Schedule Performance Index value of [SPI value] and commentary), Budget Status (with Cost Performance Index value of [CPI value] and commentary), Risk Summary (top three risks), Key Accomplishments This Week, Planned Activities Next Week, and Open Issues Requiring Attention. Use professional, formal language." | Executing Phase: drafting the weekly status report for review and publication by the Project Manager | Yes — mandatory review by Project Manager before distribution |
| COP-007 | Meeting Action Item Extraction | "Review the attached meeting transcript for the meeting titled [Meeting Title] held on [Date] and extract all action items, commitments, and follow-up tasks mentioned. For each item, provide: the Action Item Description, the Name of the Assigned Owner (as mentioned in the transcript), and the Due Date (as stated in the meeting, or 'Not Specified' if not mentioned). Format the output as a numbered table." | Executing Phase: extracting action items from Teams meeting transcripts for creation in Microsoft Planner | Yes — mandatory review by Deputy Project Manager before Planner tasks are created |
| COP-008 | Post-Meeting Summary Generation | "Using the attached meeting transcript for [Meeting Title] held on [Date] with attendees [Attendee List], generate a formal post-meeting summary. Include: Meeting Overview (two to three sentences), Key Topics Discussed (bulleted list), Decisions Made (bulleted list), Action Items (table with description, owner, and due date), and Open Questions (bulleted list). Use formal, professional language." | Executing Phase: generating post-meeting summaries for distribution to meeting attendees through Flow 6.8 | Yes — review by Deputy Project Manager before distribution via Teams |
| COP-009 | Corrective Action Recommendation | "The project [Project Name] has a current Schedule Performance Index of [SPI value] and a Cost Performance Index of [CPI value]. The primary cause of the variance appears to be [describe cause]. Generate three to five specific, actionable corrective action recommendations to improve performance. For each recommendation, describe: the specific action, the expected impact on Schedule Performance Index or Cost Performance Index, the responsible role, and the estimated implementation timeframe." | Monitoring and Controlling Phase: generating corrective action options for Project Manager review | Yes — mandatory review and decision by Project Manager before any corrective action is implemented |
| COP-010 | Change Impact Analysis Summary | "Based on the attached Change Request [Change Request Identifier] for project [Project Name] and the current Project Management Plan, summarize the potential impact of the proposed change across the following dimensions: Scope, Schedule, Cost, Quality, Risk, Stakeholder, and Resource. Format the output as a table with a brief narrative explanation of each impact dimension. Use formal language." | Monitoring and Controlling Phase: assisting the Project Manager in preparing the change impact assessment for the Change Control Board | Yes — mandatory review by Project Manager, Finance Controller, and Technical Lead before submission to Change Control Board |
| COP-011 | Risk Response Plan Generation | "For the following risk identified on project [Project Name]: Risk Title: [Title], Risk Description: [Description], Probability: [Rating], Impact: [Rating], generate a detailed Risk Response Plan. Include: the recommended Response Strategy (Avoid / Transfer / Mitigate / Accept / Escalate) with justification, at least three specific response actions, the recommended Risk Owner role, and the target resolution date. Use formal language." | Planning and Executing Phases: generating Risk Response Plans for review by the Risk Manager | Yes — mandatory review and approval by Risk Manager |
| COP-012 | Lessons Learned Summary Generation | "The following lessons learned survey responses have been collected from [Number] participants on project [Project Name]. Analyze the responses and generate a structured Lessons Learned Summary organized by project phase (Initiating, Planning, Executing, Monitoring and Controlling, Closing) and category (People, Process, Technology, Communication). For each category and phase combination, identify recurring themes, summarize the key lesson, and propose a specific, actionable improvement recommendation for future projects. Use formal language." | Closing Phase: synthesizing lessons learned survey responses into the formal Lessons Learned document | Yes — mandatory review and validation by Project Manager and Project Management Office Director |
| COP-013 | Project Closure Report Draft | "Using the attached project performance data, final status report, Lessons Learned Summary, and Deliverable Acceptance Records for project [Project Name] (Project Identifier: [ID]), draft a formal Project Closure Report. Include sections covering: Project Overview, Performance Summary against Original Objectives, Schedule and Cost Performance Summary (with final Earned Value Analysis metrics), Quality Summary, Risk Summary, Stakeholder Engagement Summary, Lessons Learned Key Themes, Benefits Realization Assessment, and Formal Acceptance Confirmation. Use professional, authoritative language throughout." | Closing Phase: drafting the Project Closure Report for review by the Project Manager and Executive Sponsor | Yes — mandatory review by Project Manager and approval by Executive Sponsor |
| COP-014 | Power Business Intelligence Natural Language Portfolio Query | "In Power Business Intelligence, navigate to the Questions and Answers feature on the Executive Portfolio Overview page and enter: 'Show me all active projects where the Schedule Performance Index is less than 0.90, ranked by Schedule Performance Index from lowest to highest, including Project Name, Project Manager, current Phase, Schedule Performance Index value, and number of days to planned completion date.'" | Monitoring and Controlling Phase: enabling Portfolio Managers and Executive Sponsors to query portfolio performance data without requiring technical Power Business Intelligence expertise | Yes — results should be cross-referenced against dashboard data before executive decisions are made |
| COP-015 | Stakeholder Communication Draft — Status Update | "Draft a formal project status communication for stakeholder group [Stakeholder Group Name] for project [Project Name] covering the period [Date Range]. This stakeholder group is classified as [Supportive / Neutral / Leading] and their primary interest area is [Interest Area]. The communication should include: a brief executive summary of project status, two to three key accomplishments from the period, any significant risks or issues relevant to this stakeholder group's interests, upcoming milestones, and any decisions or input required from this group. Tone should be [formal and concise / detailed and explanatory]. Maximum length: [number] words." | Executing Phase: drafting tailored stakeholder communications for review by the Communications Manager | Yes — mandatory review by Communications Manager and Project Manager before distribution |
| COP-016 | Power Automate Flow Description Generation | "Generate a comprehensive plain-language description of the Power Automate flow with the following specification: Flow Name: [Name], Trigger: [Trigger Description], Actions: [List of Actions], Conditions: [List of Conditions]. The description should be suitable for inclusion in the flow documentation library and should explain the flow's purpose, when it runs, what it does step by step, who receives notifications, what data it writes, and how errors are handled. Target audience: non-technical project management staff." | Configuration and ongoing maintenance: documenting Power Automate flows in plain language for the Microsoft Power Platform Administrator's documentation library | Yes — mandatory review by Microsoft Power Platform Administrator for technical accuracy |
| COP-017 | Risk Digest Narrative Generation | "Using the attached Risk Register data for project [Project Name] for the week of [Week Ending Date], generate a concise formal narrative Risk Digest suitable for distribution to the Risk Manager, Project Manager, and Deputy Project Manager. The digest should: summarize the total count of open risks by severity category, highlight the top three risks by severity score, describe any new risks added this week, note any risks whose status changed this week, identify any risks overdue for response action, and conclude with a one-paragraph overall risk assessment of the project. Use formal, professional language." | Monitoring and Controlling Phase: generating the weekly Risk Digest narrative component distributed through Flow 6.2 | Yes — review by Risk Manager before distribution |
| COP-018 | Vendor Performance Assessment Summary | "Using the attached vendor performance data for vendor [Vendor Name] on project [Project Name] covering the period [Date Range], generate a formal Vendor Performance Assessment Summary. Include sections covering: Delivery Performance (on-time delivery rate, number of deliverables accepted on first submission versus requiring rework), Quality of Deliverables (average quality rating and notable issues), Responsiveness and Communication (response time to issues and change requests), Contract Compliance, and an Overall Performance Rating on a scale of one to five. Conclude with specific recommendations for the next review period." | Executing and Closing Phases: generating formal vendor performance assessments for review by the Procurement Officer | Yes — mandatory review by Procurement Officer and Finance Controller |
| COP-019 | Transition Plan Summary Generation | "Based on the attached Project Charter, final deliverable list, and operational context for project [Project Name], draft a formal Transition to Operations Summary. Include: a list of all deliverables being transitioned with their operational owners, required training activities and completion status, documentation transferred to the operational team (with SharePoint links), the support model for the thirty-to-ninety-day post-transition period, outstanding items to be resolved by the operational team, and the formal handover confirmation language for the Transition Acceptance Record. Use formal, authoritative language." | Closing Phase: drafting the Transition to Operations summary for review by the Project Manager and operational leadership | Yes — mandatory review by Project Manager and receiving operational team leadership |
| COP-020 | Earned Value Analysis Narrative | "Based on the following Earned Value Analysis data for project [Project Name] as of [Reporting Date]: Planned Value = [PV value], Earned Value = [EV value], Actual Cost = [AC value], Budget at Completion = [BAC value], calculate the Schedule Variance, Cost Variance, Schedule Performance Index, Cost Performance Index, Estimate at Completion (using the formula: Actual Cost plus (Budget at Completion minus Earned Value) divided by Cost Performance Index), and Variance at Completion. Then generate a two-to-three paragraph formal narrative analysis explaining what these metrics indicate about the project's current performance and forecast final outcome, and recommending one to two specific management actions based on the data." | Monitoring and Controlling Phase: generating Earned Value Analysis narratives for inclusion in weekly status reports and the Power Business Intelligence dashboard | Yes — mandatory review by Project Manager and Finance Controller for accuracy before publication |
Important Note Regarding Copilot Prompt Usage All prompts in this library are reviewed quarterly by the Microsoft Copilot Coordinator. Personnel who identify a need for a new recurring prompt should submit the proposed prompt to the Microsoft Copilot Coordinator for review, testing, and approval prior to use. No prompt that involves the input of personally identifiable information, financial account numbers, protected health information, or contractually confidential vendor information may be used without explicit written authorization from the Data Governance Officer. All Copilot-generated content is a draft and requires human review before any official use. |
Document Title: Automated Project Management Process — Complete Formal Reference Guide | Version: 1.0 | Date: August 4, 2026 | Classification: Public Edition | Owner: Project Management Office Director
This document is the property of the Project Management Office. Unauthorized reproduction, distribution, or modification is strictly prohibited. All revisions must follow the change control process defined in Section 11 of this Reference Guide.
© 2026 — Project Management Office — All Rights Reserved — Internal Use Only