Automate Quarterly Tags in Planner with Power Automate: A Step‑by‑Step Guide

Keeping Planner tasks organized can get messy—especially when you’re managing dozens (or hundreds!) of items across a project or operational plan. One simple way to bring clarity is to automatically tag tasks by the quarter in which they are due: Q1, Q2, Q3, Q4, or No Due Date.

In today’s post, I’ll show you how to build a Power Automate flow that loops through all tasks in a Planner plan, checks their due dates, and assigns the correct quarterly label. It’s simple, scalable, and a great example of how you can use automation to bring structure to your team’s work.

⭐ What This Flow Does

This flow:

1. Retrieves all tasks from a Planner plan.
2. Looks at each task's Due Date.
3. Determines the correct quarter:
   • Jan–Mar → Q1
   • Apr–Jun → Q2
   • Jul–Sep → Q3
   • Oct–Dec → Q4
4. If the task has no due date, it assigns the No Due Date label.
5. Updates the task by applying the label.

This automation runs cleanly, requires no premium connectors, and keeps Planner visually organized without manual tagging.

🛠️ How to Build the Flow

1. Create an Automated Cloud Flow

• Go to Power Automate → Create
• Choose Scheduled cloud flow
• Give it a name like “Tag Planner Tasks by Quarter”
• Set it to run daily, weekly, or monthly depending on your use case

This ensures your Planner tasks are always kept up to date.

---

2. Get All Tasks from Your Planner Plan

Add an action:

👉 Planner → List tasks

Select the Planner Group and Plan you want to process.
This becomes the input list the flow will iterate through.

---

🔁 3. Get Details for Each Task (Auto‑looped)

Once you add a Get a task action and connect its Task Id to the id from List tasks, something helpful happens:

⭐ Power Automate automatically inserts an Apply to each loop.

You don’t have to create the loop manually—Power Automate detects that you're referencing an array (value from List tasks), so it wraps the action in a loop automatically.

Inside the loop:

Action:
Planner → Get a task

• Task Id: id (from List tasks → value)

This ensures access to the full metadata of each task—including the due date we need for quarter logic.

---

🧮 4. Calculate the Quarter Using One Powerful Expression

Instead of four conditions—or even four switch cases—we’ll calculate the quarter with a single, elegant formula.

This expression checks whether a due date exists; if so, it extracts the month, uses basic math to convert it to a quarter, and returns Q1–Q4. If the task has no due date, it returns “No Due Date.”

Use this expression directly as the Switch input:

if(

  empty(outputs('Get_a_task')?['body/dueDateTime']),

  'No Due Date',

  concat(

    'Q',

    string(

      add(

        div(

          sub(int(formatDateTime(outputs('Get_a_task')?['body/dueDateTime'], 'MM')), 1),

          3

        ),

        1

      )

    )

  )

)

 What this does:

• If due date is empty → returns “No Due Date”
• Otherwise → computes Q1, Q2, Q3, or Q4
• Works entirely inside one dynamic expression—no extra Compose steps required

---

🎚️ 5. Route Tasks with a Switch Statement

Now add a Switch action and paste the formula above into the On field.

Create cases for:

• Q1
• Q2
• Q3
• Q4
• No Due Date

Each case becomes the place where you apply the correct Planner label.

---

🏷️ 6. Apply the Appropriate Label

Inside each case:

Action:
Planner → Update task details

Switch on the label you’ve assigned to that quarter.
Optionally, turn off any quarter labels that shouldn’t be applied.

By the end:

• Tasks with Jan–Mar due dates get tagged Q1
• Apr–Jun → Q2
• Jul–Sep → Q3
• Oct–Dec → Q4
• And anything without a due date gets clearly marked No Due Date

Your Planner board becomes instantly sortable and visually cleaner.

---

🎉 A Cleaner Planner with Zero Manual Maintenance

Once this flow is saved and running, your Planner board updates itself. Every day (or whatever schedule you’ve set), Power Automate evaluates each task and applies the appropriate label automatically.

This small automation makes quarterly planning easier, meetings faster, and project reviews clearer—without anyone having to remember to manually categorize tasks.