Trello Daily Board Digest

Overview

This flow posts a daily summary of a Trello board to a Microsoft Teams channel and emails it to the board owner. Each morning before standup it reads the board with the Trello connector and reports total open cards, cards due today, cards completed yesterday, blocked cards, and a per-list breakdown.

Why it matters: standup prep is repetitive. An automatic board readout gives the whole team one shared picture each morning with zero effort, so standups focus on hotspots instead of reading status aloud.

The solution ships Off — turn it on after authorizing the connections and setting the environment variable values.

Use Case

A team running its work on a Trello board wants a consistent morning summary delivered to Teams and email, so the daily standup can focus on what's due, what's blocked, and what moved — not on reading the board aloud.

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 Daily 08:45 recurrence (hour/minute/timezone) to match your team's standup.

Tune blocked detection

flowlibs_TrelloBlockedLabel matches by list name (case-insensitive contains). Set it to whatever your board calls its blocked column, or filter on each card's labels array to match by Trello label instead.

List cards per list

The breakdown table gives one row per list. To list individual card titles per list, extend the per-list loop to append card rows the same way the Due Today and Completed sections do.

Store a trend

Log the daily counts to a Dataverse table (one row per day) to drive a Power BI trend chart.

Add recipients

flowlibs_OwnerEmail drives the email; the Teams target is set by flowlibs_TeamsGroupId and flowlibs_TeamsChannelId. Add more channels by duplicating the Post to Teams action.

Report cards added yesterday

Trello encodes a card's creation time in the first 8 hex characters of its id. Convert that to a date and compare to varYesterday to report cards added yesterday.

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(utcNow(),'yyyy-MM-dd')   |   formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')

@and(not(equals(coalesce(item()?['due'], ''), '')), equals(formatDateTime(coalesce(item()?['due'], '2000-01-01T00:00:00.000Z'),'yyyy-MM-dd'), variables('varToday')))

@and(equals(item()?['dueComplete'], true), equals(formatDateTime(coalesce(item()?['dateLastActivity'], '2000-01-01T00:00:00.000Z'),'yyyy-MM-dd'), variables('varYesterday')))

@contains(toLower(item()?['name']), toLower(variables('varBlockedLabel')))

@contains(body('Select_Blocked_List_Ids'), item()?['idList'])

@concat('<tr><td>', items('Apply_to_each_List')?['name'], '</td><td>', string(length(body('Filter_Cards_For_List'))), '</td></tr>')

if(empty(variables('varDueTodayHtml')), '<li>None</li>', variables('varDueTodayHtml'))