Get Started with Power Platform Center Of Excellence (CoE) – Part 2

by | Dec 21, 2025 | Power Apps, Power Automate, Power Platform

In the second part, I will outline the installation steps for the Power Platform Center of Excellence (CoE).

Navigate to Install the Creator Kit and tap on the Download the CreatorKitCore solution link. This will download the CreatorkitCore_#_#_########_#_managed.zip.

Step 1. Import CoE Creator Kit Solution

Navigate to the makers portal at https://make.powerapps.com/.
In the left-hand menu, select Solutions, then click Import solution to add the creator kit.

Select  CreatorkitCore_#_#_########_#_managed.zip, then click Open.

Click the Next button.

Finally, press Import.

Step 2. Import CoE Core Components

I will install the Centre of Excellence Core Components.

Download the latest CoE Starter Kit version, extract the files and choose to import the CenterofExcellenceCoreComponents_#.##.#_managed zip file into your environment.

Go to the Connections section in PowerApps. Set up the following connections:

Connection Name
Office 365 Outlook
Power Apps for Makers
Microsoft Teams
Power Automate Management
Power Platform for Admins
Office 365 Groups
Office 365 Users
Dataverse
HTTP with Microsoft Entra ID (preauthorized)
HTTP with Azure AD
Power Apps for Admins
Microsoft Dataverse
Power Automate for Admins
Power Query Dataflows

During the import process, you will be prompted to enter values for environment variables. The table below provides the values you will be asked to enter.

Environment variable Value
https://apps.powerapps.com/
The Client Secret value has been obtained from the prerequisites.
https://graph.microsoft.com/
CoE Admin Email: This address sends notifications to admins. Use your email or a distribution list.
The Application (client) ID value has been obtained from the prerequisites.
https://login.windows.net
The app registration client secret is stored as plain text.
Azure Tenant ID
Obtain the ID of the Microsoft 365 group with your Power Platform users. Use this ID to share apps with them.
The company name will appear in different apps and emails.
Power Platform Environment ID
https://flow.microsoft.com/manage/environments/
Get the ID of the Microsoft 365 group with your Power Platform makers to share apps and communicate with them.
In the maker table, we store a user ID for each system for easy reference.
https://make.powerapps.com/
All communications in the starter kit will be sent to this email address. You cannot send messages to a group.
To connect to Microsoft Graph, you need the application client ID from the “Create a Microsoft Entra app registration” step. If you prefer to use Azure Key Vault for your client ID and secret, you can leave this ID blank.
Audit Logs – Audience https://manage.office.com

To obtain the CoE System User ID, please follow these steps:

1. Start by using advanced filters.
2. Navigate to the search bar at the top of the page.
3. Click on the search box and select “Search for rows in a table using advanced filters” to see the available tables.

I will select “Switch to Classic” on the “Select a table to search” blade.

In the Dynamics 365 portal, use Advanced Find to select Users and search for the full name “SYSTEM,” as shown in the image below.

Click the option labelled “SYSTEM.”

To grab the GUID from the URL, in the address bar, go to the “?id=” section and copy it.

After you enter the environment variable values above, start the import process and let it run until it finishes.

Note : Admin | Sync Template v4 (Driver) may delay the start of inventory collection by a few hours, depending on how much data there is. This helps balance the number of queries sent to Dataverse. Because of this, the flow might seem to run longer than expected.

Step 3. Setup Wizard

Once the import is complete, go to the maker portal and start the CoE Setup and Upgrade Wizard.
Setup flows
Setup flows help with the initial installation, configuration, and setting up environment variables.
  • Admin | Sync Template v3 CoE Solution Metadata
  • Admin | Sync Template v3 Configure Emails
  • Admin | Sync Template v3 (Connectors)
  • Admin | Sync Template v3 (Call Updates)
  • Admin | Add Maker to Group
  • Admin | Excuse Non-Inventoried Envts from Governance Flows
  • Admin | Excuse Support Envts from Governance Flows
  • Command Center App > Get M365 Service Messages
  • Command Center App > Initially Populate Bookmarks
  • Command Center App > Set CoE Flows State
  • DLP Editor > Parse impacted resources into CSV

 

Inventory flows
Inventory flows review the tenant to gather app and flow details. These details are then added to Dataverse to help create dashboards.
  • Admin | Sync Template v3 (Flow Action Details)
  • Admin | Sync Template v3 (Sync Flow Errors)
  • Admin | Sync Template v4 (Ai Models)
  • Admin | Sync Template v4 (Al Usage)
  • Admin | Sync Template v4 (Apps)
  • Admin | Sync Template v4 (Business Process FIows)
  • Admin | Sync Template v4 (Connection Identities)
  • Admin | Sync Template v4 (Custom Connectors)
  • Admin | Sync Template v4 (Desktop Flow – Runs)
  • Admin | Sync Template v4 (Desktop flows)
  • Admin | Sync Template v4 (Driver)
  • Admin | Sync Template v4 (Flows)
  • Admin | Sync Template v4 (Model Driven Apps)
  • Admin | Sync Template v4 (Portals)
  • Admin | Sync Template v4 (PVA Usage)
  • Admin | Sync Template v4 (PVA)
  • Admin | Sync Template v4 (Security Roles)
  • Admin | Sync Template v4 (Solutions)
  • CLEANUP – Admin | Sync Template v3 (App Shared With)
  • CLEANUP – Admin | Sync Template v3 (Delete Bad Data)
  • CLEANUP – Admin | Sync Template v3 (Flow Shared With)
  • CLEANUP – Admin | Sync Template v3 (Orphaned Makers)
  • CLEANUP – Admin | Sync Template v3 (Orphaned Users)
  • CLEANUP – Admin | Sync Template v3 (PVA Usage)
  • CLEANUP – Admin | Sync Template v4 (Check Deleted)
  • CLEANUP – Admin | Sync Template v4 (Other Objects)

 

Child flows

Child flows are smaller tasks that parent flows use to perform specific actions, such as cleaning up a resource.

  • CLEANUP HELPER – Check Deleted v4 (Ai Models)
  • CLEANUP HELPER – Check Deleted v4 (Business Process Flows)
  • CLEANUP HELPER – Check Deleted v4 (Canvas Apps)
  • CLEANUP HELPER – Check Deleted v4 (Cloud Flows)
  • CLEANUP HELPER – Check Deleted v4 (Custom Connectors)
  • CLEANUP HELPER – Check Deleted v4 (Desktop flows)
  • CLEANUP HELPER – Check Deleted v4 (Model Driven Apps)
  • CLEANUP HELPER – Check Deleted v4 (Portals)
  • CLEANUP HELPER – Check Deleted v4 (PVA)
  • CLEANUP HELPER – Check Deleted v4 (Solutions)
  • CLEANUP HELPER – Cloud Flow User Shared With

 

Step 4. Setup Power BI Dashboard

Download Power BI Desktop from https://www.microsoft.com/en-us/download/details.aspx?id=58494

Open the Production_CoEDashboard .pbit file from the folder you extracted earlier. When asked, enter the Power Platform Environment URL.

Start by adding https:// to the beginning of the URL, as shown in the image below.

Save your dashboard and publish it to the correct workspace.

Go to https://app.powerbi.com/ and set up a scheduled refresh for your dataset.

Step 5. Initiate the subscription for the Audit Log content.

  1. Open your browser and go to make.powerapps.com.
  2. Click on Solutions.
  3. Open the Center of Excellence – Core Components solution.
  4. Turn on the Admin | Audit Logs | Office 365 Management API Subscription flow. To run the flow, enter start as the operation.

 

Related links

 

 

468
Share This