Can this work with multiple Trello boards for different squads?

Yes, but you need separate flows for each board or add a loop to process multiple boards. The latter gets complex fast with message formatting.

What happens if someone deletes a card after the flow runs?

The report shows the card state at runtime. Deleted cards won't cause errors but won't appear in future reports either.

How do I handle cards without due dates in the overdue section?

Add a condition checking 'not(empty(due))' before your overdue logic. Cards without dates will skip the overdue check entirely.

Can I customize the report format for different team preferences?

Absolutely. Modify the Compose actions to change formatting, add sections, or include different card fields based on your standup style.

Intermediate~15 min setupCommunication & Project ManagementVerified April 2026

How to Automate Sprint Planning and Daily Standups with Power Automate

Automatically generate daily Slack summaries of Trello board activity including completed tasks, overdue cards, and upcoming deadlines for standup meetings.

Steps and UI details are based on platform versions at time of writing — check each platform for the latest interface.

Power Automate

Also on:Make Zapier N8n Pipedream

Best for

Development teams running 1-2 week sprints who need automated status reports without manually checking Trello boards.

Not ideal for

Teams using complex project management tools like Jira or Azure DevOps where native reporting already exists.

Sync type

scheduled

Use case type

reporting

Real-World Example

💡

A 12-person development team runs 2-week sprints with 40+ Trello cards per sprint. Before automation, the scrum master spent 15 minutes each morning manually checking boards and writing standup summaries. Now Power Automate generates daily 9 AM Slack reports showing completed tasks from yesterday, overdue cards, and items due today.

What Will This Cost?

Drag the slider to your expected monthly volume.

Monthly workflow runs

/mo

505005K50K

Each platform counts differently — Zapier: 1 task per trigger. Make: 1 operation per module per record. n8n: 1 execution per run.

cheapest

Power Automatethis guide

$30/mo if billed monthly

Pipedream

$29/mo

Basic plan

Prices shown for annual billing. Based on published pricing as of April 2026.

Estimated ROI

1000

min saved/mo

$583

labor value/mo

Free

no platform cost

Based on ~2 min manual effort per operation at $35/hr fully loaded labor cost.

Implementation

Skip the setup

Import this workflow directly into Power Automate

Copy the pre-built Power Automate blueprint and paste it straight into Power Automate. All modules, filters, and field mappings are already configured — you just need to connect your accounts.

Before You Start

Make sure you have everything ready.

Admin or member access to the Trello board containing your sprint cards

Permission to add apps and post messages in the target Slack channel

Microsoft 365 account with Power Automate access (included in most business plans)

Trello cards with consistent due dates and list names for accurate reporting

Optional

Slack workspace admin approval if your org requires app authorization

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Card Name	`name`	The title of each Trello card for easy identification in standup reports
List Name	`list.name`	Which column the card is in (To Do, In Progress, Done) to show status
Last Activity Date	`dateLastActivity`	When the card was last modified to filter for recent changes

5 optional fields▸ show

Due Date	`due`	When the card is due to identify overdue items and today's deadlines
Assigned Members	`members`	Who is responsible for each card to tag them in standup updates
Card Description	`desc`	Brief context about the task for more detailed standup reports
Labels	`labels`	Card categories like 'bug', 'feature', 'urgent' for priority context
Card URL	`url`	Direct link to the Trello card so team members can click for details

Step-by-Step Setup

My flows > + New flow > Scheduled cloud flow

Create scheduled cloud flow

Navigate to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then click '+ New flow' at the top. Select 'Scheduled cloud flow' from the dropdown menu. Name your flow 'Daily Trello Sprint Report' and set it to run every day at 9:00 AM.

1Click 'My flows' in the left sidebar
2Click the '+ New flow' button at the top
3Select 'Scheduled cloud flow' from the options
4Enter 'Daily Trello Sprint Report' as the flow name
5Set recurrence to 'Daily' at 9:00 AM

✓ What you should see: You should see the flow designer with a 'Recurrence' trigger set to daily at 9:00 AM.

⚠

Common mistake — The timezone defaults to UTC. Change it to your team's timezone in the recurrence settings.

Flow designer > + New step > Trello

Connect to Trello

Click '+ New step' below the recurrence trigger. Search for 'Trello' in the connector search box and select it. Choose 'Get cards on a board' as your action. You'll need to authenticate with Trello by clicking 'Sign in' and authorizing Power Automate access to your Trello account.

1Click '+ New step' button
2Type 'Trello' in the search box
3Select the Trello connector
4Choose 'Get cards on a board' action
5Click 'Sign in' and authorize Trello access

✓ What you should see: You should see the Trello action with a dropdown to select your board.

⚠

Common mistake — You need admin or member access to the Trello board. Read-only access won't work for this connector.

Trello action > Board dropdown

Select your sprint board

In the 'Get cards on a board' action, click the Board dropdown and select your active sprint board. If you don't see your board listed, refresh the page and try again. The connector pulls all boards where you have member access. Choose the board that contains your current sprint cards.

1Click the Board dropdown in the Trello action
2Select your active sprint board from the list
3Leave other fields at default values

✓ What you should see: The board name should appear in the dropdown field, and you should see no error messages.

Flow designer > + New step > Trello > Get cards on a board

Filter for completed cards

Add another Trello action by clicking '+ New step'. Search for Trello again and select 'Get cards on a board'. This time, select the same board but we'll use this to get cards from your 'Done' or 'Completed' list. You'll filter these in the next step to show only cards completed since yesterday.

1Click '+ New step' below the first Trello action
2Search for and select Trello connector again
3Choose 'Get cards on a board' action
4Select the same board from the dropdown

✓ What you should see: You now have two identical Trello 'Get cards on a board' actions in your flow.

⚠

Common mistake — Don't rename these actions yet - we'll configure them differently in the following steps.

Slack

trigger

filter

Condition

matches criteria?

yes — passes through

no — skipped

Trello

notified

Flow designer > + New step > Condition

Add filter for recent activity

Click '+ New step' and search for 'Condition'. Select the 'Condition' control from the results. We'll use this to filter cards that were modified in the last 24 hours. In the condition, select 'dateLastActivity' from the dynamic content (from the Trello cards), set the operator to 'is greater than', and use the expression 'addDays(utcnow(), -1)' for the value.

1Click '+ New step' and search for 'Condition'
2Select the Condition control
3Click in the left field and choose 'dateLastActivity' from dynamic content
4Set the operator to 'is greater than'
5Click the right field and enter expression 'addDays(utcnow(), -1)'

✓ What you should see: You should see a condition box with 'If yes' and 'If no' branches below it.

⚠

Common mistake — Make sure to select the expression tab when entering the date formula, not the dynamic content tab.

Condition > If yes > Add an action > Compose

Create completed tasks summary

In the 'If yes' branch of the condition, click 'Add an action'. Search for 'Compose' and select the Data Operation 'Compose' action. This will build your completed tasks summary. In the Inputs field, create a formatted string that shows the card name, list name, and who completed it using dynamic content from the Trello cards.

1Click 'Add an action' in the 'If yes' branch
2Search for and select 'Compose' from Data Operations
3Click in the Inputs field
4Build a formatted string using card name, list, and member info from dynamic content

✓ What you should see: The Compose action should show your formatted template with dynamic content tokens highlighted in blue.

⚠

Common mistake — The Compose action will automatically wrap in an 'Apply to each' loop since you're processing multiple cards.

Flow designer > Add an action > Condition

Identify overdue cards

Add another condition after the Compose action to check for overdue cards. Click 'Add an action' in the main flow (outside the existing condition). Add another Condition control that compares the card's 'due' date with 'utcnow()' using 'is less than' operator. This identifies cards where the due date has passed.

1Click 'Add an action' in the main flow area
2Add another Condition control
3Select 'due' from the Trello card dynamic content
4Set operator to 'is less than'
5Use 'utcnow()' expression for current time

✓ What you should see: You now have a second condition that will identify overdue cards with past due dates.

⚠

Common mistake — Cards without due dates will cause this condition to fail. Add a nested condition to check if due date exists first.

Overdue condition > If yes > Add an action > Compose

Format overdue cards list

In the overdue condition's 'If yes' branch, add another Compose action. Format the overdue cards with their names, due dates, and assigned members. Use the formatDateTime() function to make due dates readable. This creates a formatted list of all overdue items for your standup report.

1Click 'Add an action' in the overdue condition's 'If yes' branch
2Select Compose from Data Operations
3Format card details with formatDateTime(due, 'MM/dd/yyyy') for readable dates
4Include card name and assigned members

✓ What you should see: Another Compose action wrapped in 'Apply to each' that formats overdue card details.

⚠

Common mistake — Map fields using the variable picker — don't type field names manually. Hand-typed variable names often have invisible spacing errors that produce blank output.

Flow designer > + New step > Slack > Post message

Connect to Slack

Add a final action to send the report to Slack. Click '+ New step' and search for 'Slack'. Select the Slack connector and choose 'Post message' action. Sign in to your Slack workspace when prompted. Select your target channel (like #standup or #dev-updates) and build your message using the outputs from your Compose actions.

1Click '+ New step' at the bottom of your flow
2Search for and select Slack connector
3Choose 'Post message' action
4Sign in to your Slack workspace
5Select your target channel from the dropdown

✓ What you should see: Slack action configured with your workspace and channel selected.

⚠

Common mistake — You need permission to add apps to the Slack channel. Private channels require explicit invitation.

Slack action > Message field

Build the final report message

In the Slack message field, create your daily standup report format. Include sections for 'Completed Yesterday', 'Overdue Items', and 'Due Today'. Use the join() function to combine your Compose outputs into readable lists. Add emoji and formatting to make the report scannable. Test your flow by clicking 'Test' in the top menu.

1Click in the Message field of the Slack action
2Create formatted sections with headers and emoji
3Use join() function to combine Compose outputs
4Add line breaks and formatting for readability
5Click 'Test' to run the flow manually

✓ What you should see: A formatted message template that will post a structured standup report to your Slack channel.

⚠

Common mistake — The join() function needs a delimiter parameter. Use '\n' for line breaks between cards.

Add this expression in a Compose action to create smart priority indicators based on due dates and card labels. Paste this formula in the Inputs field of a Compose action after your Trello data.

JavaScript — Code Stepif(

▸ Show code

if(
  contains(string(item()?['labels']), 'urgent'),
  concat('🚨 URGENT: ', item()?['name']),

... expand to see full code

if(
  contains(string(item()?['labels']), 'urgent'),
  concat('🚨 URGENT: ', item()?['name']),
  if(
    and(
      not(empty(item()?['due'])),
      less(ticks(item()?['due']), ticks(addDays(utcnow(), 1)))
    ),
    concat('⚠️ DUE SOON: ', item()?['name']),
    concat('• ', item()?['name'])
  )
)

Scaling Beyond 100+ cards per sprint board+ Records

If your volume exceeds 100+ cards per sprint board records, apply these adjustments.

Batch card processing

Use 'Apply to each' concurrency settings to process cards in parallel. Set concurrency to 20 for faster execution on large boards.

Split reports by priority

Create separate Slack messages for high/low priority items instead of one massive report. Use card labels to filter and group intelligently.

Implement message truncation

Add length checking and truncate reports over 3500 characters. Include a 'See more in Trello' link when truncating occurs.

Going live

Production Checklist

Before you turn this on for real, confirm each item.

Set flow to run Monday-Friday only if you don't want weekend reports

Add error handling to continue running if one Trello board is temporarily unavailable

Configure run after settings to send alerts even if some cards have missing data

Test with a sprint that has 50+ cards to verify message doesn't exceed Slack limits

Applies when: bulk

Set up a backup notification method if Slack connector fails during critical sprint periods

Document which Trello lists count as 'completed' for consistent team interpretation

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy n8n for this workflow

Use Power Automate for this if your team is already in the Microsoft ecosystem and wants dead-simple scheduled reporting. The Trello connector handles authentication smoothly and the expression language works well for date filtering. Skip it if you need real-time updates when cards move - Power Automate's scheduled triggers mean reports always run at fixed times, not when activity happens.

Tradeoffs

Real math: Each flow run counts as 1 action, plus 1 action per Trello API call, plus 1 per Slack message. With 50 cards per sprint board, expect 55 actions per daily run. At 20 workdays per month, that's 1,100 actions monthly. Power Automate includes 2,000 actions free with most Microsoft 365 plans, so you're covered. Zapier's free tier caps at 100 tasks monthly - you'd hit that in 2 days.

Make handles complex conditional logic better with its visual branching and has tighter error handling when Trello boards change. Zapier's Formatter tools make message formatting cleaner than Power Automate's expression syntax. n8n gives you more control over API rate limiting and can batch requests efficiently. Pipedream's code-first approach lets you build smarter filtering logic for large boards. But Power Automate wins on authentication simplicity and Microsoft integration if you're using Teams alongside Slack.

You'll hit timezone confusion when comparing due dates - Power Automate defaults everything to UTC but your team thinks in local time. Cards without due dates break overdue logic unless you add null checks. The 'Apply to each' loops can make message formatting weird until you master the join() function. Slack's 4000 character limit cuts off reports when sprints get busy, so build truncation logic before you need it.

Ideas for what to build next

→
Add burndown metrics — Extend the flow to calculate story points completed vs. remaining and include velocity tracking in your daily reports.
→
Create sprint retrospective automation — Build a weekly flow that summarizes the full sprint with completion rates, blocker analysis, and team performance metrics.
→
Integrate with calendar — Connect to Outlook or Google Calendar to automatically schedule standup meetings and attach the Trello report as context.