How to Send Sprint Summaries from ClickUp to Slack with Power Automate

My flows > New flow > Automated cloud flow

Create New Automated Flow

Open make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then 'New flow' at the top. Select 'Automated cloud flow' from the dropdown menu. Name your flow 'ClickUp Sprint Summary to Slack'.

1. 1Click 'My flows' in the left navigation
2. 2Click 'New flow' button at the top
3. 3Select 'Automated cloud flow'
4. 4Enter flow name: ClickUp Sprint Summary to Slack

Choose your flow's trigger > HTTP

Configure ClickUp Webhook Trigger

Search for 'HTTP' in the trigger list and select 'When an HTTP request is received'. This creates a webhook endpoint that ClickUp will call when a sprint completes. Power Automate will generate a unique URL after you save the flow. Leave the JSON schema blank for now.

1. 1Type 'HTTP' in the trigger search box
2. 2Select 'When an HTTP request is received'
3. 3Leave Request Body JSON Schema empty
4. 4Click 'Create' to proceed

New step > Data Operations > Parse JSON

Add Parse JSON Action

Click 'New step' and search for 'Parse JSON'. Select 'Parse JSON' from Data Operations. This will extract the sprint data from ClickUp's webhook payload. In the Content field, select 'body' from the dynamic content menu. Leave the Schema field empty for now - we'll populate it after testing.

1. 1Click 'New step' below the HTTP trigger
2. 2Search for 'Parse JSON' in actions
3. 3Select 'Parse JSON' from Data Operations
4. 4Click Content field and select 'body' from dynamic content

New step > Variables > Initialize variable

Initialize Variables for Task Counting

Add 'Initialize variable' action and create three integer variables: CompletedTasks, IncompleteTasks, and TotalTasks. Set all initial values to 0. These will store the task counts we calculate from the sprint data. You'll need to add this action three times, once for each variable.

1. 1Click 'New step' and search for 'Initialize variable'
2. 2Set Name to 'CompletedTasks', Type to 'Integer', Value to 0
3. 3Add another Initialize variable for 'IncompleteTasks'
4. 4Add a third Initialize variable for 'TotalTasks'

New step > Control > Apply to each

Add Apply to Each Loop

Add 'Apply to each' action to loop through tasks in the sprint. In the 'Select an output from previous steps' field, you'll reference the tasks array from the parsed JSON. Since we don't have the schema yet, type this expression manually: body('Parse_JSON')?['tasks']. This loops through each task to count completed vs incomplete.

1. 1Click 'New step' and search for 'Apply to each'
2. 2Click the output field and select 'Expression' tab
3. 3Type: body('Parse_JSON')?['tasks']
4. 4Click OK to confirm the expression

Inside Apply to each > Control > Condition

Add Task Status Condition

Inside the Apply to each loop, add a Condition action. Configure it to check if the current task status equals 'Complete' or 'Done'. In the left side, select 'items()?['status']' from dynamic content. Set the operator to 'is equal to' and enter 'Complete' in the right field. This separates completed from incomplete tasks.

1. 1Click 'Add an action' inside the Apply to each loop
2. 2Search for and select 'Condition'
3. 3Set left value to items()?['status'] using expression
4. 4Set condition to 'is equal to' and value to 'Complete'

Condition branches > Variables > Increment variable

Increment Task Counters

In the 'Yes' branch of the condition, add 'Increment variable' and select CompletedTasks. In the 'No' branch, increment IncompleteTasks. After the Apply to each loop, add a 'Set variable' action to calculate TotalTasks by adding CompletedTasks and IncompleteTasks using the expression add(variables('CompletedTasks'), variables('IncompleteTasks')).

1. 1In 'Yes' branch, add 'Increment variable' for CompletedTasks
2. 2In 'No' branch, add 'Increment variable' for IncompleteTasks
3. 3After the loop, add 'Set variable' for TotalTasks
4. 4Use expression: add(variables('CompletedTasks'), variables('IncompleteTasks'))

New step > Slack > Post message

Connect to Slack

Add 'Post message' action and search for Slack. Select 'Post message' from the Slack connector. Power Automate will prompt you to sign in to Slack and authorize access. Choose the workspace where you want to post sprint summaries. You'll need admin permissions to add the Power Automate app to your Slack workspace.

1. 1Click 'New step' and search for 'Slack'
2. 2Select 'Post message' from Slack actions
3. 3Click 'Sign in' when prompted for connection
4. 4Authorize Power Automate in your Slack workspace

Slack Post message > Channel and Message

Configure Slack Message

Select your target channel from the dropdown (like #dev-updates or #sprint-reports). In the message field, build a summary using dynamic content and expressions. Include the sprint name, completion date, and task statistics. Format it like: 'Sprint @{body('Parse_JSON')?['sprint_name']} completed! ✅ @{variables('CompletedTasks')} tasks done ❌ @{variables('IncompleteTasks')} incomplete (@{variables('TotalTasks')} total)'.

1. 1Select target channel from Channel dropdown
2. 2Click in Message field and select 'Expression' tab
3. 3Build message with sprint name and task counts
4. 4Include emojis and formatting for readability

Top toolbar > Save > Test

Save and Test Flow

Click 'Save' at the top to save your flow. Power Automate will generate the webhook URL in the HTTP trigger. Copy this URL - you'll need it for ClickUp webhook configuration. Test the flow by clicking 'Test' and selecting 'Manually'. The flow will wait for a webhook call from ClickUp.

1. 1Click 'Save' button in the top toolbar
2. 2Copy the webhook URL from HTTP trigger
3. 3Click 'Test' and select 'I'll perform the trigger action'
4. 4Click 'Save & Test' to start listening

ClickUp Settings > Integrations > Webhooks

Configure ClickUp Webhook

In ClickUp, go to your workspace settings and find Webhooks. Create a new webhook pointing to your Power Automate URL. Set the event to trigger when a List (sprint) status changes to 'Complete' or 'Done'. Include task data in the payload by checking the appropriate boxes. Test the webhook by completing a test sprint in ClickUp.

1. 1Open ClickUp workspace settings
2. 2Navigate to Integrations > Webhooks
3. 3Click 'Create Webhook' and paste Power Automate URL
4. 4Select 'List updated' event and set status filter to 'Complete'

Add this expression to the Slack message field to calculate completion percentage and format a more detailed summary with sprint metrics.

concat(
  'Sprint ', body('Parse_JSON')?['name'], ' completed! 📊\n',
  '✅ Completed: ', variables('CompletedTasks'), '\n',

concat(
  'Sprint ', body('Parse_JSON')?['name'], ' completed! 📊\n',
  '✅ Completed: ', variables('CompletedTasks'), '\n',
  '❌ Incomplete: ', variables('IncompleteTasks'), '\n',
  '📈 Success Rate: ', 
  if(equals(variables('TotalTasks'), 0), '0%', 
    concat(string(div(mul(variables('CompletedTasks'), 100), variables('TotalTasks'))), '%')
  )
)