Daily Unresolved Azure DevOps Bugs Digest

Overview

This scheduled flow runs every morning at 8:00 AM UTC and queries Azure DevOps for unresolved bugs that have been open longer than a configurable threshold (default: 7 days). If any bugs are found, it compiles a prioritized HTML table showing each bug's ID, title, assigned developer, priority, state, creation date, and age in days, then sends a formatted digest email to configured recipients via Outlook 365.

Use Case

Development and project management teams need visibility into aging bugs that risk slipping through the cracks. This flow eliminates the need for manual Azure DevOps queries by delivering a daily prioritized digest directly to the team's inbox. Managers can immediately spot bugs that need escalation, and developers can see their unresolved assignments at a glance.

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 schedule

Edit the Recurrence trigger to adjust frequency (e.g., weekdays only, twice daily).

Filter by area path

Modify the WIQL query in the 'Query Unresolved Bugs via WIQL' action to add AND [System.AreaPath] UNDER 'Project\\Team'.

Add more fields

Extend the Select Bug Summary mapping and the batch GET fields parameter to include additional work item fields like Severity or Area Path.

Send to Teams instead

Replace the Send Email action with a Teams Post Message action for channel-based delivery.

Adjust priority sorting

The WIQL query orders by Priority ASC then Created ASC; modify the ORDER BY clause to change sort behavior.

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.

formatDateTime(addDays(utcNow(), mul(-1, int(variables('varThresholdDays')))), 'yyyy-MM-dd')

div(sub(ticks(utcNow()), ticks(item()?['fields']?['System.CreatedDate'])), 864000000000)

coalesce(item()?['fields']?['System.AssignedTo']?['displayName'], 'Unassigned')

join(body('Select_Bug_IDs'), ',')