COE Weekly Admin Digest

Overview

The COE Weekly Admin Digest is the flagship Center of Excellence reporting flow. It aggregates key Power Platform metrics from Dataverse inventory tables — total canvas apps, total cloud flows, active makers, new environments, and DLP violations — and delivers a polished HTML email to the admin group every Monday morning.

This flow is designed to be the single weekly pulse check for COE administrators and executives, providing at-a-glance KPIs with conditional alerts for DLP violations and new environment creation.

Use Case

IT Admins and Executives need a consolidated weekly view of their Power Platform tenant health without logging into multiple admin portals. This flow queries four Dataverse inventory tables (populated by COE Kit sync flows or custom inventory flows), computes summary statistics, and delivers a styled HTML digest email with stat cards, conditional alert banners, and actionable recommendations.

The flow is ideal for teams that:

• IT Admins who need a weekly tenant health pulse check without logging into multiple admin portals
• Executives who want at-a-glance Power Platform KPIs delivered to their inbox
• COE teams running the standard COE Kit (or custom inventory flows) and looking for an out-of-the-box weekly digest
• Organizations that need conditional alerting on DLP violations and new environment creation

Flow Architecture

Environment Variables

Connectors & Connections

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Update environment variable values

Set flowlibs_AdminNotificationEmail to your admin group email or distribution list. Set the four table-name variables (flowlibs_COEAppInventoryTable, flowlibs_COEFlowInventoryTable, flowlibs_COEEnvironmentTable, flowlibs_COEDLPViolationTable) to match your COE Kit or custom inventory table names — the defaults match standard COE Kit table names.

Authorize connections

Dataverse: authorize with a service account that has read access to the inventory tables. Outlook: authorize with the account that should send the digest email.

Turn on the flow

After importing and configuring the solution, turn the flow on. It will then fire every Monday at 8:00 AM EST.

Change the recurrence schedule

Edit the trigger to run on a different cadence (e.g., daily, biweekly) by adjusting the Recurrence frequency and interval.

Add additional Dataverse queries for custom metrics

Extend the flow with more ListRecords actions for metrics such as connector usage, flow run counts, or any other inventory table you maintain.

Modify the HTML template

Edit Compose Digest Report to match your organization's branding — adjust colors, logos, CSS, and section copy in the HTML.

Add CC/BCC recipients

Modify the SendEmailV2 parameters in Send Weekly Digest Email to include CC or BCC addresses (or a wider distribution list).

Adjust the lookback window

Change the -7 in Compute Week Start Date (addDays(utcNow(), -7, ...)) to a different number of days to widen or shorten the weekly window.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

addDays(utcNow(), -7, 'yyyy-MM-ddTHH:mm:ssZ')

concat('createdon ge ', outputs('Compute_Week_Start_Date'))

greaterOrEquals(item()?['createdon'], outputs('Compute_Week_Start_Date'))

concat('Power Platform COE Weekly Digest - ', formatDateTime(utcNow(), 'MMMM dd, yyyy'))

if(greater(length(body('List_DLP_Violation_Records')?['value']), 0), alertHtml, cleanHtml)

length(union(body('List_App_Inventory_Records')?['value'], body('List_App_Inventory_Records')?['value']))