Skip to content

Using Microsoft Planner Efficiently with Templates

A practical way to create recurring tasks in Microsoft Planner with templates and Power Automate — ideal for onboarding, accounting, and scheduled reviews.

Updated

Update 2026: This post shows the Power Automate approach. For project teams, we now create the Planner plan automatically from a template plan when the project workspace is provisioned. The post Teams template with Planner describes how it works. The corresponding offering is Smarter Project Portal.

We already showed you in a previous post how to create recurring tasks in Microsoft Planner with Power Automate. In this article, we present an alternative approach: how to achieve the same outcome using Microsoft Planner together with reusable templates.

Introduction

Using a simple example, I’ll walk through how to combine Microsoft Planner with templates.

The scenario: onboarding a new employee. With Microsoft Planner and templates, I define the tasks that must be completed whenever someone joins the company.

Define a template

In Microsoft Planner, I create a new plan and define all tasks that need to be done.

Create Microsoft Planner templates

As you can see, I also create checklist items (subtasks), which you can use without any issues.

Implement in Microsoft Planner

First, I manually trigger the flow to capture the name of the new employee.

Start the flow

I then use that value to create a new bucket.

Create a bucket

Next, I fetch the list of tasks to be created.

List tasks

With all information in place, I iterate over the tasks and create them for the appropriate assignees.

Iterate over tasks

Based on the template’s items, I now create the actual tasks for the relevant employee(s).

Create task

As mentioned earlier, you can also define checklist items. Since this can’t be done at creation time, you must update the newly created task afterwards. Detailing that process would go beyond the scope of this post.

Start the workflow

We can now start the workflow. Go to “My flows”, select the new flow, click “Run” and the task creation begins.

Run the flow

Finally, enter the new employee’s name and start the flow.

The result

Once the flow finishes successfully, you’ll see the newly created tasks.

Result

Opening a task shows additional details, including the checklist items.

Task details

We’re happy to help

Templates are a great fit for any recurring process — onboarding new employees, monthly accounting, or quarterly reviews. You can start the process manually via a form, with Power Apps, or on a schedule. Power Apps can also capture additional information, for example: who should complete which task? Setting a due date is straightforward as well.

Need help implementing this? We’ve supported many clients quickly and pragmatically in short Microsoft Teams sessions.

Get in touch

Related articles

Managing SharePoint permissions in Excel: the
Diagram: worksheet with libraries and folders in rows, roles in columns and the cell values R, W and D, next to it the pane for applying changes

Managing SharePoint permissions in Excel: the permission matrix of a project workspace

Read, change and apply the permission matrix of a project workspace in Excel: libraries in rows, roles in columns, a log entry per change.

Read more
Drawing management in SharePoint: drawing code, index
Diagram: a file name is broken down into project, trade, drawing type, number, index and status, with the versions of a drawing with index A to C below

Drawing management in SharePoint: drawing code, index and versions

Managing drawings in SharePoint via a drawing code in the file name: metadata from the name, every index a version and where the limits lie.

Read more
SharePoint permission concept for projects: roles, not
Permission matrix: six libraries in the rows, five roles in the columns, with write, read or no access in each cell

SharePoint permission concept for projects: roles, not names

Three role models for project workspaces in SharePoint, from five roles to 26 groups per project, and the rules that keep permissions manageable.

Read more

Questions about this topic?

We are happy to help you put this into practice in your environment.