Premium Connector License Audit

Overview

This governance flow performs a weekly automated audit of all cloud flows in the target Power Platform environment, identifying flows that use premium connectors and cross-referencing the flow owners via the Office 365 Users connector. Flagged flows are exported to an Excel workbook on SharePoint and a formatted HTML email report is sent to the admin team.

Use Case

Organizations with mixed licensing need visibility into which flows consume premium connectors (Dataverse, SQL Server, Azure Blob, Key Vault, HTTP, Dynamics 365, Salesforce, SAP). Without this audit, unlicensed premium usage can go undetected, risking compliance violations and unexpected license costs. This flow automates the detection and reporting cycle.

The flow is ideal for teams that:

• IT admins managing mixed Power Platform licensing models
• Governance teams that need recurring visibility into premium connector usage
• Compliance owners tracking unlicensed premium consumption across makers
• Center of Excellence (CoE) teams running periodic license audits

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 FlowLibs Premium Connector License Audit solution into your target Power Platform environment.

Update environment variables

Set flowlibs_TargetEnvironmentName to your environment ID, flowlibs_AdminNotificationEmail to your admin distribution list, flowlibs_SharePointSiteURL to your SharePoint root, flowlibs_ROIExcelDrive to your Graph drive ID (get from GET /sites/{siteId}/drives), flowlibs_PremiumAuditExcelFile to the path of your audit workbook, and flowlibs_PremiumAuditExcelTable to match your Excel table name.

Create the audit Excel workbook

On SharePoint, create an Excel workbook with columns FlowName, FlowId, OwnerEmail, OwnerDisplayName, PremiumConnectors, LicenseStatus, AuditDate and format them as a named table that matches flowlibs_PremiumAuditExcelTable.

Authorize all four connections

Authorize the Power Automate Management, Office 365 Users, Excel Online (Business), and Office 365 Outlook connections with an account that has tenant admin or Power Platform admin rights for the target environment.

Customize the premium connector list

Edit Init_varPremiumConnectorList to add or remove connector API names (for example shared_sql, shared_commondataserviceforapps, shared_azureblob, shared_keyvault, shared_http, shared_dynamicscrmonline, shared_salesforce, shared_sap) to match your organization's license model.

Turn on the flow

After authorizing connections and configuring environment variables, turn the flow on so the weekly recurrence trigger begins running.

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.

contains(outputs('Extract_Connection_Refs'), 'shared_sql')

coalesce(outputs('Get_Flow_Details')?['body/properties/creator/userId'], outputs('Get_Flow_Details')?['body/properties/creator/objectId'], 'unknown')

replace(replace(outputs('Extract_Premium_Connectors_Found'), 'shared_commondataserviceforapps', 'Dataverse'), 'shared_sql', 'SQL Server')

utcNow('yyyy-MM-dd')

concat('Premium Connector Audit: ', string(variables('varFlaggedCount')), ' Flow(s) Flagged - ', utcNow('yyyy-MM-dd'))