How to Post Wrike Standup Summaries to Slack with Power Automate

make.powerautomate.com > My flows > + New flow > Scheduled cloud flow

Create a new Scheduled cloud flow

Go to make.powerautomate.com and sign in with your Microsoft 365 account. From the left sidebar, click 'My flows', then click '+ New flow' at the top of the page. Select 'Scheduled cloud flow' from the dropdown — this is the correct type because the standup summary should fire on a fixed daily schedule, not in response to an event. Give the flow a name like 'Wrike Daily Standup to Slack'.

1. 1Click 'My flows' in the left sidebar
2. 2Click '+ New flow' near the top right of the page
3. 3Select 'Scheduled cloud flow' from the menu
4. 4Enter a name: 'Wrike Daily Standup to Slack'
5. 5Set the start time to your desired first run (e.g., 8:45 AM) and set 'Repeat every' to 1 Day

Flow canvas > + New step > Search 'Wrike' > Get tasks > Sign in

Connect your Wrike account

Click '+ New step' below the Recurrence trigger. In the action search bar, type 'Wrike' and select the Wrike connector. Choose the action 'Get tasks' (or 'Search tasks' depending on your connector version). Power Automate will prompt you to create a new Wrike connection — click 'Sign in' and authenticate with your Wrike credentials in the popup window. The connection is saved globally and reused in future steps.

1. 1Click '+ New step' under the Recurrence trigger
2. 2Type 'Wrike' in the search bar and press Enter
3. 3Select the Wrike connector from the results
4. 4Click 'Get tasks' action
5. 5Click 'Sign in' and complete Wrike OAuth in the popup window

Flow canvas > Get tasks action > Folder ID field / Status field / Due Date field

Filter tasks by folder and due date

Inside the 'Get tasks' action, you need to scope the query so you only pull relevant tasks — not every task in your entire Wrike account. Set the 'Folder ID' field to the ID of your target project or folder (find this in Wrike under the folder's URL). Set 'Status' to 'Active' and configure the due date range to pull tasks due in the next 48 hours. Use Power Automate's expression editor to set the due date dynamically using the formula: addDays(utcNow(), 2).

1. 1Click inside the 'Folder ID' field and paste your Wrike folder ID
2. 2Set the 'Status' dropdown to 'Active'
3. 3Click inside the 'Due Date Before' field and switch to the Expression tab
4. 4Enter: addDays(utcNow(), 2) and click OK
5. 5Leave 'Due Date After' set to utcNow() to capture tasks due between now and 48 hours from now

Flow canvas > + New step > Data Operations > Parse JSON

Parse the Wrike task response

The Wrike 'Get tasks' action returns a JSON array of task objects. You need to parse this so later steps can reference individual fields. Add a new step and search for 'Parse JSON'. In the 'Content' field, insert the 'Body' dynamic value from the Wrike step. Click 'Generate from sample' and paste a sample Wrike task response — this tells Power Automate the schema so it can surface field names like title, status, dueDate, and assignee as dynamic values downstream.

1. 1Click '+ New step'
2. 2Search for 'Parse JSON' under Data Operations
3. 3In the 'Content' field, select 'Body' from the Wrike dynamic values panel
4. 4Click 'Generate from sample'
5. 5Paste a raw Wrike task JSON response and click 'Done'

Flow canvas > + New step > Variables > Initialize variable

Initialize a variable to build the message string

Before looping through tasks, you need a variable to accumulate the message text. Add a new step, search for 'Initialize variable', and create a String variable named 'StandupMessage'. Set its initial value to a header string like '*Daily Standup Summary — @{formatDateTime(utcNow(), 'dddd, MMM d')}*\n'. This gives every Slack message a date-stamped header automatically.

1. 1Click '+ New step'
2. 2Search 'Initialize variable' and select it
3. 3Set Name to: StandupMessage
4. 4Set Type to: String
5. 5In the Value field, type your header using the expression: concat('*Daily Standup — ', formatDateTime(utcNow(), 'dddd, MMM d'), '*', decodeUriComponent('%0A'))

Flow canvas > + New step > Control > Apply to each

Loop through tasks and append each to the message

Add an 'Apply to each' control action. Set the 'Select an output from previous steps' field to the parsed task array from your Parse JSON step — specifically the 'data' array. Inside the loop, add an 'Append to string variable' action targeting StandupMessage. Write a template that formats each task as a single line, e.g.: • [task title] — Due: [dueDate] — Status: [status]. Use dynamic values from the Parse JSON output to fill each field.

1. 1Click '+ New step' and select 'Control' > 'Apply to each'
2. 2In the input field, select the 'data' array from Parse JSON dynamic values
3. 3Click 'Add an action' inside the loop
4. 4Search 'Append to string variable' and select it
5. 5Set Name to StandupMessage and build the Value with task dynamic fields: title, dueDate, status

Flow canvas > + New step > Control > Condition

Add a condition for empty task lists

After the loop, add a 'Condition' control to check whether StandupMessage still only contains the header (meaning no tasks were found). Use the expression length(variables('StandupMessage')) and compare it to the character count of your header string. If true (no tasks), set a separate string like 'No tasks due in the next 48 hours. Great shape!' to post instead. This prevents an empty-looking Slack message on low-activity days.

1. 1Click '+ New step' and select 'Control' > 'Condition'
2. 2In the left field, use Expression: length(variables('StandupMessage'))
3. 3Set the operator to 'is less than or equal to'
4. 4In the right field, enter the character count of your header string only (count the header characters manually)
5. 5In the 'If yes' branch, add 'Set variable' to override StandupMessage with your fallback text

Flow canvas > + New step > Search 'Slack' > Post message > Sign in

Connect your Slack account

After the condition block, add a new step on both branches (or after merging) and search for 'Slack' in the action picker. Select 'Post message' action. Power Automate will prompt you to create a Slack connection — click 'Sign in' and authorize the Power Automate app in your Slack workspace in the OAuth popup. You need to be a Slack admin or have permission to install apps into the workspace.

1. 1Click '+ New step' after the condition block
2. 2Type 'Slack' in the search bar and press Enter
3. 3Select the Slack connector
4. 4Choose 'Post message' action
5. 5Click 'Sign in' and authorize Power Automate in the Slack OAuth popup

Flow canvas > Post message action > Channel Name / Message Text fields

Configure the Slack post with channel and message

In the 'Post message' action, set the 'Channel Name' to your standup channel (e.g., #product-standup). In the 'Message Text' field, select StandupMessage from the dynamic values panel — this inserts the full formatted summary you built in the loop. Do not hardcode the message text here; always reference the variable so the flow is reusable across days.

1. 1Click the 'Channel Name' field and type or select your Slack channel (e.g., product-standup)
2. 2Click the 'Message Text' field
3. 3Open the dynamic values panel on the right
4. 4Select 'StandupMessage' from the Variables section
5. 5Leave all other fields at default unless you need threaded replies

Flow canvas > Save > Test > Manually > Run flow

Test the flow with a manual run

Before enabling the schedule, run the flow manually to validate output. Click 'Save' in the top toolbar, then click 'Test' in the top right and select 'Manually'. Power Automate will execute the flow immediately and show each step's result in a green/red run detail view. Check the Parse JSON output to confirm tasks are being returned, check the StandupMessage variable value after the loop, and verify the Slack post appears in your channel.

1. 1Click 'Save' in the top toolbar
2. 2Click 'Test' in the top right corner
3. 3Select 'Manually' and click 'Run flow'
4. 4Watch each step turn green as it runs
5. 5Check your Slack channel for the posted message within 30 seconds

make.powerautomate.com > My flows > [Flow name] > Run history

Enable the schedule and monitor run history

Once the manual test passes, the Recurrence trigger takes over automatically — no extra toggle is needed. The flow is live the moment it is saved and enabled. To monitor it, go to My flows, click the flow name, and scroll down to the 28-day run history. Check the first two scheduled runs to confirm the Slack messages look correct with real production data. Set up an email notification under 'Run-only users' if you want failure alerts.

1. 1Go to My flows and click your flow name
2. 2Scroll to the '28-day run history' section
3. 3Click into the first scheduled run after it fires
4. 4Confirm all steps show green and Slack message body looks correct
5. 5Optionally click 'Edit' > 'Settings' on the Recurrence trigger to adjust timezone handling

This expression block goes inside the Apply to each loop in the 'Append to string variable' action's Value field. It formats the task title, due date, priority emoji, and a clickable Wrike permalink into a single Slack-compatible line with mrkdwn formatting. Replace 'Apply_to_each' with the exact name Power Automate assigns to your loop action if it differs.

concat(
  if(
    equals(items('Apply_to_each')?['importance'], 'High'),

concat(
  if(
    equals(items('Apply_to_each')?['importance'], 'High'),
    '🔴 ',
    '⚪ '
  ),
  '*',
  items('Apply_to_each')?['title'],
  '*',
  ' — Due: ',
  formatDateTime(items('Apply_to_each')?['dueDate'], 'MMM d'),
  ' — ',
  items('Apply_to_each')?['importance'],
  ' | <',
  items('Apply_to_each')?['permalink'],
  '|View in Wrike>',
  decodeUriComponent('%0A')
)