Weekly Flow Health Dashboard Email

Overview

This flow generates a comprehensive weekly health dashboard for all Power Automate cloud flows in your environment. Every Friday at 8:00 AM ET, it inventories every flow, categorizes them by state (Active, Stopped, Suspended), and sends a beautifully formatted HTML email to the CoE (Center of Excellence) team with summary statistics and a complete flow inventory table.

Suspended flows are highlighted in a dedicated alert section so admins can take immediate action on flows that need attention.

> Tip: This flow is delivered in a Stopped (Off) state. Turn it on when you're ready to start receiving weekly reports.

Use Case

IT administrators and CoE teams need visibility into the health of their Power Automate environment. This flow replaces manual checks by automatically delivering a weekly snapshot of every cloud flow's state, flagging anything that needs admin attention, and providing a sortable inventory for review.

The flow is ideal for teams that:

• Counting total, active, stopped, and suspended flows
• Flagging suspended flows that require admin intervention
• Providing a sortable inventory of every flow with its last modified date
• Delivering the report via email on a consistent weekly schedule

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.

Change the recipient

Update the flowlibs_NotificationEmail environment variable value in the solution to any email address or distribution list.

Change the schedule

Edit the Recurrence - Weekly Friday trigger to change the frequency, day of week, or time. The default is every Friday at 8:00 AM Eastern.

Add more columns to the inventory table

Edit the Append Flow Row action inside the loop. Each flow object returned by ListMyFlows exposes properties.displayName, properties.state, properties.lastModifiedTime, properties.createdTime, and properties.createdBy.

Target a different environment

Update the flowlibs_PAEnvironmentName environment variable to the target environment's ID (format: default-{tenant-guid}).

Customize the email styling

Edit the Compose Dashboard HTML action. The entire email is a self-contained HTML document with inline CSS — the stat cards use a flexbox grid and the tables use standard HTML table styling.

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.

items('Loop_Through_Flows')?['properties']?['state']

items('Loop_Through_Flows')?['properties']?['displayName']

formatDateTime(items('Loop_Through_Flows')?['properties']?['lastModifiedTime'], 'yyyy-MM-dd HH:mm')

if(greater(variables('varSuspendedFlows'),0), concat('<section>', variables('varSuspendedFlowsList'), '</section>'), '')

formatDateTime(utcNow(), 'dddd, MMMM d, yyyy h:mm tt')