PMO implementation package

Charter and approval implementation package

A charter approval portal that captures scope, objectives, success measures, stakeholders, assumptions, and formal sponsor approval.

Tables

Screens

Power Fx snippets

Flow recipes

Downloadable guideCharter and approval build guideDownloadable implementation guide for charter drafting, sponsor approval, revision loops, and reporting.

Build checklist

Create charter schema and required fields.
Build the charter draft/edit experience.
Add sponsor approval and revision paths.
Generate a printable charter summary.
Track cycle time and approval backlog.

Workflow map

Draft charter from approved intake

PMO completeness review

Revision loop if incomplete

Sponsor approval request

Sponsor approves or requests revision

Create project record

Open initial lifecycle stage

Data model package

EitherProject Charters

Formal definition of approved work before planning begins.

Column	Type	Required	Notes
Project Name	Single line text	Yes	Use consistent naming because it becomes the reporting label.
Linked Intake Request	Lookup	No	Connects the charter to original demand.
Sponsor	Person or lookup	Yes	Approver and accountable business owner.
Project Manager	Person	Yes	Delivery owner for planning and execution.
Objectives	Multiple lines text	Yes	Business outcomes, not just deliverables.
In Scope	Multiple lines text	Yes	What the project will deliver.
Out of Scope	Multiple lines text	Yes	Prevents expectation drift.
Estimated Budget	Currency	No	Use range if exact estimate is not available.
Charter Status	Choice	Yes	Draft, PMO Review, Sponsor Review, Revision Requested, Approved, Cancelled.
Approval Date	Date	No	Stamped by workflow.

Relationships

One Project Charter creates one Project.
Many Stakeholders can relate to one Charter.
Many Approval History rows can relate to one Charter.

Indexes

Charter Status
Sponsor
Project Manager
Approval Date

EitherSuccess Measures

Defines how the PMO will know whether the project created value.

Column	Type	Required	Notes
Metric	Single line text	Yes	Cycle time, cost reduction, adoption, compliance, satisfaction.
Baseline	Number or text	No	Current-state value before project.
Target	Number or text	Yes	Desired future-state value.
Measurement Method	Multiple lines text	Yes	Where the number comes from and how often it is reviewed.

Relationships

Many Success Measures relate to one Project Charter.

Indexes

Charter
Review Date

Power Apps screen package

Project manager or requesterCharter Draft Screen

Build the charter from an approved intake request with scope, objectives, risks, and value.

Layout

Charter progress tabs
Business case section
Scope and out-of-scope section
Stakeholders subgrid
Success measures subgrid

Controls

frmProjectCharter
txtObjectives
txtInScope
txtOutOfScope
galStakeholders
galSuccessMeasures
btnSubmitForPmoReview

Formula notes

Submit disabled until objectives, scope, sponsor, and success measures exist
Patch stakeholder child rows before status changes
Notify author when PMO review starts

Data sources

Project Charters
Stakeholders
Success Measures
Approval History

PMO reviewerPMO Charter Review Screen

Validate charter quality before sponsor approval.

Layout

Read-only charter summary
Completeness checklist
Reviewer comments
Request revision or send to sponsor actions

Controls

frmCharterReadOnly
galCompletenessChecklist
txtReviewComments
btnRequestRevision
btnSendSponsorApproval

Formula notes

Checklist must be complete before sponsor approval
Revision action sets status and sends comments
Sponsor approval action starts approval flow

Data sources

Project Charters
Approval History
Communication Log

Business sponsorSponsor Approval Screen

Approve, reject, or request revisions with minimal friction.

Layout

Charter one-page summary
Risk and investment highlights
Approval decision panel
Comments and attachments

Controls

cntCharterSummary
galSuccessMeasureSummary
cmbSponsorDecision
txtSponsorComments
btnSubmitDecision

Formula notes

Approval creates Project record and initial lifecycle stage
Revision reopens charter for author
Reject requires rationale

Data sources

Project Charters
Projects
Approval History
Lifecycle Stages

Power Fx package

btnSubmitForPmoReview.OnSelectSubmit charter for PMO review

Formula / code

If(
    CountRows(galSuccessMeasures.AllItems) = 0 || IsBlank(Trim(txtObjectives.Text)) || IsBlank(Trim(txtInScope.Text)),
    Notify("Add objectives, scope, and at least one success measure before PMO review.", NotificationType.Warning),
    IfError(
        Patch(
            'Project Charters',
            varCurrentCharter,
            {
                Objectives: txtObjectives.Text,
                'In Scope': txtInScope.Text,
                'Out of Scope': txtOutOfScope.Text,
                'Charter Status': { Value: "PMO Review" }
            }
        ),
        Notify("Charter could not be submitted.", NotificationType.Error),
        Notify("Charter sent to PMO review.", NotificationType.Success)
    )
);

Notes

Require success measures before approval so value tracking is not an afterthought.
Lock major charter fields after sponsor approval.

Sponsor approval success actionCreate project after sponsor approval

Formula / code

Set(
    varProject,
    Patch(
        Projects,
        Defaults(Projects),
        {
            'Project Name': varCurrentCharter.'Project Name',
            Sponsor: varCurrentCharter.Sponsor,
            'Project Manager': varCurrentCharter.'Project Manager',
            'Current Stage': { Value: "Initiation" },
            'Overall Health': { Value: "Not Rated" }
        }
    )
);

Notes

Create the Project record once, from the approved charter.
Use the created project ID to generate initial stage gate checklist rows.

Power Automate package

FlowCharter - Sponsor Approval

Trigger: When Charter Status changes to Sponsor Review.

Get charter and stakeholder details.

Start and wait for approval assigned to Sponsor.

If approved, update Charter Status to Approved.

Create Project record and first lifecycle stage.

If rejected or revision requested, update status and send comments to author.

Expressions

@equals(triggerOutputs()?['body/CharterStatus/Value'], 'Sponsor Review')
outputs('Start_and_wait_for_an_approval')?['body/outcome']

Dataverse solution package

Create solution BV PMO Charter with publisher prefix bvpmocrt.

Tables

bv_projectcharter
bv_stakeholder
bv_successmeasure
bv_approvalhistory
bv_project

Choices

bv_charterstatus
bv_stakeholderrole
bv_approvaldecision
bv_measuretype

Apps

Charter Draft App
Sponsor Approval Portal
PMO Charter Review

Cloud flows

Charter - Submit PMO Review
Charter - Sponsor Approval
Charter - Request Revision
Charter - Create Project

Security roles

Charter Author
Charter PMO Reviewer
Charter Sponsor Approver
Portfolio Viewer

Environment variables

Charter Approval Timeout Days
Sponsor Approval Email Template
Project Site Base URL
PMO Charter Support Email

Dashboards

Charter Approval Backlog
Sponsor Queue
Approved Value Pipeline
Revision Rate

Deployment checklist

Create development, test, and production environments or sites before build-out.
Create publisher prefix, solution shell, environment variables, and connection references first.
Build tables and choices before apps and flows.
Import sample template rows, then test with non-admin users.
Run approval, rejection, revision, escalation, and overdue scenarios before release.
Publish Power BI pages after validating relationships, date fields, status definitions, and security trimming.
Document owners, support mailbox, release notes, and rollback steps.

Starter files

Intake requests CSVStarter columns for demand intake, scoring, ownership, and triage decisions.Project charters CSVStarter charter fields for scope, sponsors, success measures, approvals, and assumptions.Stage gates CSVStarter criteria and review fields for stage movement and gate decisions.RAID and change control CSVStarter fields for risks, issues, actions, decisions, and change requests.Status reporting CSVStarter fields for weekly project health, milestones, benefits, and decision requests.PMO build roadmapA plain-language build order for rolling out the PMO system one tool at a time.