Bitbucket Daily Open PR Digest

Overview

A scheduled cloud flow that, every morning, gathers the open pull requests across a configured set of Bitbucket repositories, classifies each one (awaiting review, approved & ready to merge, changes requested, and stale/oldest), and delivers a single readable digest to a Microsoft Teams dev channel plus an HTML email to the dev lead. It replaces the daily ritual of clicking through Bitbucket repos to see "what's waiting on whom."

This is a demo / reference flow. It ships Off; going live requires only authorizing the three connections and setting the six environment-variable values — no logic changes.

Use Case

Teams that spread work across several Bitbucket repositories lose visibility into review state. Reviews stall, PRs rot, and nobody notices the oldest open one. This flow gives the whole team a once-a-day, no-click readout: how many PRs are open, which are blocked on a review, which are ready to merge, which were sent back for changes, and which have been open past the staleness threshold. The email adds a per-PR breakdown of the reviewers who still owe a review.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Bitbucket	shared_bitbucket	ListPullRequests
Microsoft Teams	shared_teams	PostMessageToConversation
Office 365 Outlook	shared_office365	SendEmailV2

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.

Pick the repos

Set flowlibs_BitbucketRepoSlugs to your comma-separated repo slugs and flowlibs_BitbucketWorkspace to your workspace.

Change the schedule

Edit the Recurrence trigger (default daily 08:00 ET).

Tune staleness

Raise/lower flowlibs_StalePrThresholdDays.

Re-target delivery

Update flowlibs_TeamsGroupId / flowlibs_TeamsChannelId / flowlibs_DigestRecipientEmail.

Go live

Authorize the Bitbucket, Teams, and Outlook connections, then turn the flow On.

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(utcNow()), ticks(item()?['created_on'])), 864000000000)

if(greater(length(body('Filter_Changes_Requested')),0), 'Changes Requested', if(greater(length(body('Filter_Reviewer_Approvals')),0), 'Approved & Ready', 'Awaiting Review'))

greaterOrEquals(<ageDays>, variables('varStaleDays'))

join(body('Select_Pending_Reviewer_Names'), ', ')

replace(replace(replace(string(body('Select_PR_Rows')), '"},{"html":"', ''), '[{"html":"', ''), '"}]', '')

Customize & download