Trello Checklist Completion to Next Action

Overview

This flow advances Trello cards automatically when their checklists are complete. On a schedule it scans the monitored board, and for any card sitting in the source list whose checklist is 100% complete it: moves the card to the next list, posts an audit comment on the card, notifies the next owner in a Teams channel, and sends an optional downstream email.

Why it matters: Manual stage moves get forgotten. Checklist-driven transitions keep work flowing and trigger the next step the moment a card is ready - no one has to watch the board.

Status: Built. Ships Off (demo). Going live requires only connection authorization + setting the environment variable values.

Use Case

A team runs a checklist-gated Trello board (e.g. In Progress -> Review -> Done). Each card in the working list carries a checklist of exit criteria. When every item is ticked, the card should advance to the next stage and the next owner should be told. This flow makes that transition automatic and auditable.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Trello	shared_trello	ListCards UpdateCard_V2 AddCommentToCard
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.

Named-checklist gate

Advance only when a specific checklist completes rather than all items. Call GetCard with checklists=all and inspect the named checklist's items instead of the aggregate badge.

Multi-stage map

Replace the single source/next pair with a JSON stage-map env var ({ "<listId>": "<nextListId>" }) and look up the next list per card to support a whole pipeline in one flow.

Swap the downstream action

Replace Send Downstream Email with Word/Adobe document generation, an Approval, or a Planner/DevOps task to fire a real next step.

Rollback

Add a branch that moves a card back a stage if its checklist becomes incomplete again.

Tighten the poll

Change the Recurrence to minutes for near-real-time advancement, or switch to a Trello OnNewCardInList / change-subscription trigger if a push trigger fits your board.

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.

@and(equals(items('Apply_to_each_Card')?['idList'], variables('varSourceListId')), and(greater(items('Apply_to_each_Card')?['badges']?['checkItems'], 0), equals(items('Apply_to_each_Card')?['badges']?['checkItems'], items('Apply_to_each_Card')?['badges']?['checkItemsChecked'])))

updateCard/idList = @variables('varNextListId')

@outputs('List_Cards_On_Board')?['body']

@items('Apply_to_each_Card')?['id']

@{concat('Checklist complete - card "', items('Apply_to_each_Card')?['name'], '" was automatically advanced to the next stage by FlowLibs.')}

Customize & download