Canvas App Inventory Sync to Dataverse

Overview

This flow provides a foundation pattern for Center of Excellence (COE) reporting by automatically syncing canvas app metadata from the Power Apps for Admins connector into a Dataverse custom table. Running on a daily schedule, it captures every canvas app in the target environment — including display name, app ID, owner details, and creation/modification timestamps — and writes each record to a dedicated inventory table. This data layer enables Power BI dashboards, compliance audits, and governance automation.

Use Case

IT Admins and platform governance teams need a reliable, up-to-date inventory of all canvas apps in their tenant. Manual inventories drift within days. This flow automates the collection so that downstream reporting (adoption dashboards, orphaned app detection, license auditing) always has fresh data.

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.

Deploy in your environment

Import the FlowLibsCanvasAppInventorySync solution into the target environment, update the flowlibs_PAEnvironmentName environment variable current value to your environment's ID (format: default-{tenant-guid}), authorize both connection references (Power Apps for Admins and Dataverse — the authorizing user needs System Administrator or Power Platform Admin role), and turn on the flow.

Add pagination

The $top parameter is set to 250. For environments with more apps, add a Do Until loop with nextLink handling to page through all results.

Add upsert logic

Create an alternate key on flowlibs_appid and switch the CreateRecord action to UpdateRecord (Upsert) to avoid duplicate rows on re-runs.

Add email summary

After the Apply to Each, add an Outlook SendEmailV2 action that uses varAppCount to report how many apps were synced.

Multi-environment scan

Wrap the entire flow in another Apply to Each that iterates over a list of environment IDs to sync inventory across multiple environments in one run.

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.

@parameters('flowlibs_PAEnvironmentName')

@{utcNow()}

@outputs('Get_All_Canvas_Apps_as_Admin')?['body/value']

@{items('Apply_to_Each_App')?['properties/displayName']}

@{items('Apply_to_Each_App')?['name']}

@{items('Apply_to_Each_App')?['properties/owner/displayName']}

@{items('Apply_to_Each_App')?['properties/owner/email']}

@{items('Apply_to_Each_App')?['properties/createdTime']}