Others

How to Automatically Move Planner Tasks Between Buckets After One Week

Chanuka Geekiyanage Oct 20, 2026 868 views

Question details

The user wants to automate the process of moving a task from one Microsoft Planner bucket to another after exactly seven days.

How to Automatically Move Planner Tasks Between Buckets After One Week

Product: Microsoft Planner and Power Automate
Device & OS: not provided
Scenario: Managing time-sensitive tasks that require follow-up alerts, such as automatically transferring a task from a 'Waiting for Collection' bucket to a 'Second Alert Call' bucket after a week has passed.
Observed behavior: Tasks currently remain in their original bucket and require manual movement; the goal is to implement a fully automated transition based on the task's age.

Before you start

Ensure you have active licenses for both Microsoft Planner and Microsoft Power Automate, and verify that you have the necessary permissions to create and edit cloud flows in your Microsoft 365 environment.

Solution 1Recommended

Create a Scheduled Cloud Flow in Power Automate

Set up a scheduled flow that runs daily to check task creation dates and automatically updates the bucket ID for tasks older than seven days.

Since Microsoft Planner does not have native time-based automation rules for moving tasks between buckets, you need to rely on Microsoft Power Automate. By scheduling a daily flow, you can query all open tasks, calculate their age, and move them accordingly.

Open Power Automate and Create a Flow

Log in to Microsoft Power Automate. Select 'Create' from the left-hand navigation menu, and then choose 'Scheduled cloud flow'.

Define the Schedule

Name your flow (e.g., 'Weekly Planner Bucket Move'). Set the starting date and time, configure the recurrence to run once every 'Day', and click 'Create'.

List Tasks from Planner

Click 'New step' and search for 'List tasks'. Select the Microsoft Planner action and choose the specific 'Group Id' and 'Plan Id' that contain your tasks.

Add a Condition for Task Age

Add a 'Condition' control. Use expressions to check if the task's creation date is seven days old. You can use the expression format `addDays(utcNow(), -7)` to calculate the exact threshold date.

Update the Task Bucket

In the 'If yes' branch of your condition, add the 'Update a task' action. Provide the 'Task Id' using dynamic content from the previous step, and change the 'Bucket Id' field to your target bucket, such as 'Second Alert Call'.

Create a Scheduled Cloud Flow in Power Automate

Seek Community Help for Complex Expressions: Building conditions with date strings in Power Automate can sometimes cause formatting errors. If you encounter issues with date comparisons, posting your flow design screenshots in the Microsoft Power Automate Community is a great way to get tailored troubleshooting assistance.

Free Microsoft Office alternative

Manage Your Projects and Tasks Efficiently with WPS Office

While complex task automations require combining Planner with Power Automate, many teams prefer managing tasks in customizable spreadsheets. WPS Office provides robust, lightweight spreadsheet and document tools that serve as an excellent, cost-effective alternative to Microsoft Office for tracking daily tasks.

1. Download and Install WPS Office: Visit the official WPS Office website to download the free suite and install it on your PC or Mac.
2. Open a Task Management Template: Launch WPS Spreadsheet, go to the template library, and search for 'Task Tracker' to find pre-built, easy-to-use project management sheets.
3. Save in Excel Format: Save your newly created task tracker in .xlsx format to ensure seamless collaboration with team members using Microsoft Excel.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Free, lightweight, and fast installation for all your daily productivity and tracking needs.Create highly customizable task trackers and Gantt charts using built-in spreadsheet templates.Familiar user interface makes switching from Microsoft Office effortless and requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I trigger a Power Automate flow exactly 7 days after a task is created instead of checking daily?

No, Power Automate does not have a native 'Wait 7 days' trigger based specifically on Planner task creation without keeping the flow running continuously, which is generally discouraged due to run limits. A daily scheduled flow that checks for tasks matching the 7-day criteria is the most reliable and efficient method.

Will moving a task between buckets via Power Automate notify the assigned user?

Moving a task to a new bucket using the 'Update a task' action does not automatically trigger an email notification in Planner. If you want the assignee to be notified, you must manually add a 'Send an email (V2)' action in your flow immediately after the bucket update step.

Where can I find the exact Bucket ID for my Power Automate flow?

When configuring the 'Update a task' action, the 'Bucket Id' field usually provides a dropdown list of all available buckets in your selected plan. If you are using custom variables or the dropdown fails to populate, you can add a 'List buckets' action earlier in your flow to dynamically retrieve and match the bucket names and their corresponding IDs.

What happens if the task is already completed before the seven days are up?

To prevent completed tasks from being moved to the alert bucket unnecessarily, you should add an additional rule to your condition in Power Automate. Check that the 'Percent complete' value of the task is less than 100 before allowing the flow to update the task's bucket.

Office Quick Solutions