ADO Build Duration Trend Monitor

Overview

A scheduled daily flow that monitors Azure DevOps build pipeline durations, logs them to a SharePoint tracking list, calculates a 14-day rolling average, and alerts the DevOps team when any build takes 50%+ longer than the average. Sends a weekly trend report every Monday via Outlook.

Use Case

Build pipelines degrade silently over time — a test suite grows, a dependency mirror slows down, or a cache expires. Without trend monitoring, teams don't notice until builds block the sprint. This flow provides early warning by comparing each build's duration against the historical baseline and alerting when performance degrades beyond a configurable threshold.

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 solution into the target environment, configure connection references for ADO, SharePoint, Teams, and Outlook, update each environment variable, and turn on the flow.

Adjust the alert threshold

Edit the Init_varThresholdPercent action — default is 50, meaning a build 50% above the rolling average triggers an alert. Lower for stricter monitoring, raise for less noise.

Change the report schedule

Modify the Recurrence trigger for different run times, or change dayOfWeek(utcNow()) = 1 in the weekly report condition to a different day (0=Sunday, 6=Saturday).

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.

div(sub(ticks(finishTime), ticks(startTime)), 600000000)

addDays(utcNow(), -1, 'yyyy-MM-ddTHH:mm:ssZ')

addDays(utcNow(), -14, 'yyyy-MM-ddTHH:mm:ssZ')

mul(add(1, div(float(varThresholdPercent), 100)), average)

dayOfWeek(utcNow()) = 1