Mandatory Metadata Compliance Checker

Overview

This scheduled Power Automate Cloud Flow audits all canvas apps and cloud flows in your Power Platform environment's Dataverse inventory tables for missing required metadata. It checks for empty descriptions and missing owner information, then posts a compliance summary to a Teams channel when non-compliant resources are found. Designed for COE (Center of Excellence) governance teams to enforce metadata hygiene across the tenant.

Use Case

Organizations scaling Power Platform adoption often struggle with "maker sprawl" — hundreds of apps and flows with no descriptions, no documented owners, and no business justification. This makes it impossible to govern, audit, or transfer resources when makers leave. This flow automates the weekly metadata audit, replacing manual spreadsheet reviews with an automated compliance pipeline that flags gaps and notifies admins.

The flow is ideal for teams that:

• IT Admins
• COE Leads
• Power Platform Governance Teams

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.

Import the solution

Import the solution into your target Power Platform environment.

Set environment variable values

Configure flowlibs_TeamsGroupId (your Teams team's Group ID — find via Teams admin or Graph API), flowlibs_TeamsChannelId (the channel ID for compliance alerts), flowlibs_COEAppInventoryTable (your Dataverse app inventory table — default admin_app for COE Kit), flowlibs_COEFlowInventoryTable (your Dataverse flow inventory table — default admin_flow), flowlibs_AdminNotificationEmail (admin or DL to receive reports), and flowlibs_TargetEnvironmentName (environment name for the Flow Management connector).

Authorize connections

Open the flow in the designer, click each connection reference, and sign in to authorize Dataverse, Teams, and Power Automate Management.

Adjust the schedule

Default is weekly Monday at 8:00 AM EST. Edit the Recurrence trigger to change frequency, day, or time as needed.

Extend metadata checks

Edit the If conditions inside each Foreach to add checks for additional fields (e.g., business justification, department tag, last-modified date).

Turn on the flow

After configuring and authorizing, turn the flow on. It will run on the next scheduled occurrence.

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.

coalesce(items('For_Each_App_Record')?['admin_appdescription'], '')

if(equals(coalesce(field, ''), ''), '❌ Missing', '✅')

add(variables('varNonCompliantAppCount'), variables('varNonCompliantFlowCount'))

if(greater(variables('varNonCompliantAppCount'), 0), concat('<div>...table...</div>'), '')