App Session Trend Analyzer

Overview

The App Session Trend Analyzer is a weekly scheduled Power Automate Cloud Flow that monitors canvas app adoption health across a Power Platform tenant. It reads app session telemetry from a Dataverse table, computes a 30-day rolling session count for the current and prior periods, calculates the percentage change, and flags any significant decline. When sessions drop by more than the configurable threshold (default 50%), it sends a high-importance alert email to the COE admin. When sessions are healthy, it sends a normal-priority summary report.

Use Case

Center of Excellence (COE) teams need early warning when apps are losing adoption. A sustained session decline often signals an app heading toward abandonment — catching it early allows the COE to reach out to users, investigate UX issues, or plan retirement before the app becomes fully orphaned.

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 a new environment

Import the managed solution into the target environment, update the three environment variable current values for your tenant, authorize the Microsoft Dataverse and Office 365 Outlook connections, then turn the flow On.

Adjust alert sensitivity

Change the varDeclineThresholdPct variable default value inside the flow. Lower values (e.g. 25) will trigger alerts on smaller declines; higher values (e.g. 75) only flag severe drops.

Change the schedule

Edit the Weekly Recurrence trigger to adjust the day, time, or frequency the analysis runs.

Add per-app breakdown

Extend the Select actions to group by app name, then use an Apply to Each loop to build individual rows in the HTML report table for each app.

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.

createdon ge @{addDays(utcNow(), -30, 'yyyy-MM-dd')}

createdon ge @{addDays(utcNow(), -60, 'yyyy-MM-dd')} and createdon lt @{addDays(utcNow(), -30, 'yyyy-MM-dd')}

if(equals(priorCount, 0), 0, div(mul(sub(priorCount, currentCount), 100), priorCount))

greaterOrEquals(declinePercentage, thresholdVariable)