n8n-nodes-microsoft-planner

This is an n8n community node that allows you to interact with Microsoft Planner in your n8n workflows.

n8n is a fair-code licensed workflow automation platform.

Microsoft Planner is a task management tool that helps teams organize, assign, and collaborate on tasks.

Installation

Follow the installation guide in the n8n community nodes documentation.

Community Node

1. Go to Settings > Community Nodes in your n8n instance
2. Select Install
3. Enter @blickwerk/n8n-nodes-microsoft-planner in Enter npm package name
4. Agree to the risks of using community nodes
5. Select Install

After installing the node, you can use it like any other node in your workflows.

Manual Installation

To install manually:

npm install @blickwerk/n8n-nodes-microsoft-planner

Prerequisites

You need to have:

• An active Microsoft 365 subscription
• A Microsoft Planner plan created
• Azure AD App Registration with the following API permissions:
  • Tasks.ReadWrite - Read and write tasks
  • Group.ReadWrite.All - Read and write all groups (required for Planner)
  • User.Read.All - Read all users (required for user assignment by email)

Setting up Azure AD App

1. Go to Azure Portal
2. Navigate to Azure Active Directory > App registrations
3. Click New registration
4. Give it a name (e.g., "n8n Microsoft Planner Integration")
5. Select Accounts in this organizational directory only
6. Add redirect URI: https://your-n8n-instance.com/rest/oauth2-credential/callback
7. Click Register

Configure API Permissions

1. Go to API permissions
2. Click Add a permission
3. Select Microsoft Graph
4. Select Delegated permissions
5. Add the following permissions:
   • Tasks.ReadWrite - Read and write tasks
   • Group.ReadWrite.All - Read and write all groups (required for Planner)
   • User.Read.All - Read all users' basic profiles (required for user assignment)
6. Click Grant admin consent

Note: The User.Read.All permission is required if you want to assign tasks to users by email address.

Create Client Secret

1. Go to Certificates & secrets
2. Click New client secret
3. Add a description and select expiration
4. Copy the Value (you won't see it again!)

Get Application Details

• Client ID: Found on the app overview page
• Client Secret: The value you copied in the previous step

Credentials

Configure the Microsoft Planner OAuth2 API credentials in n8n:

1. In n8n, go to Credentials > New
2. Search for Microsoft Planner OAuth2 API
3. Enter your Client ID and Client Secret
4. Click Connect my account
5. Complete the OAuth flow

Features

• Resource Locator UI: Choose between "From List" (dropdown) or "By ID" (manual input) for Buckets
• User Assignment: Assign tasks to users by email address
• Priority Management: Easy-to-use priority dropdown (Urgent, Important, Medium, Low)
• Full CRUD Operations: Create, Read, Update, and Delete tasks

Operations

Task

• Create - Create a new task
• Get - Get a task by ID
• Get Many - Get multiple tasks from a plan or bucket
• Update - Update an existing task
• Delete - Delete a task
• Get Files - Get all files attached to a task

Usage

Creating a Task

To create a task:

1. Enter the Plan ID (you can find this in Microsoft Planner URL or via Graph Explorer)
2. Select a Bucket from the dropdown (loads automatically based on the Plan ID)
3. Enter the Title of the task

Optional fields:

• Description: Detailed task description
• Priority: Select from dropdown
  • Urgent (highest priority)
  • Important
  • Medium (default)
  • Low
• Assigned To: Comma-separated list of user emails (e.g., user1@domain.com, user2@domain.com)
• Due Date Time: When the task should be completed
• Start Date Time: When work on the task should begin
• Percent Complete: Task completion percentage (0-100)

Getting Tasks

Get a single task:

• Enter the Task ID manually (no dropdown available for single task lookups)

Get many tasks:

• Choose filter type: Plan or Bucket
• Enter the Plan ID
• If filtering by Bucket: Select bucket from dropdown or enter Bucket ID manually
• Set a limit or return all tasks

Updating a Task

To update a task:

1. Enter the Task ID manually
2. Update any of these fields:

• Title
• Description
• Priority (via dropdown)
• Assigned users (via email list)
• Due Date Time
• Start Date Time
• Percent Complete
• Move to different bucket

Getting Files from a Task

To get all files attached to a task:

1. Enter the Task ID manually
2. The operation returns:
   • taskId: The task ID
   • fileCount: Number of attached files
   • files: Array of file objects with:
     • url: Decoded SharePoint URL (ready to use)
     • alias: Display name of the file
     • type: File type (e.g., PowerPoint, Word, Excel, PDF, Other)
     • previewPriority: Priority for preview display
     • lastModifiedDateTime: When the file reference was last modified
     • lastModifiedBy: Who last modified the reference

How to Find Plan IDs

You can find your Plan ID in several ways:

1. From Planner URL: Open Microsoft Planner in browser, the URL contains the Plan ID:

   https://tasks.office.com/.../ planId=YOUR_PLAN_ID_HERE /...
   

2. Via Microsoft Graph Explorer:

   • Go to https://developer.microsoft.com/graph/graph-explorer
   • Sign in
   • Run: GET /me/planner/plans
   • Copy the id field from the plan you want

Resource Locator (From List / By ID)

When creating tasks or filtering by bucket:

• From List: Select from dropdown (automatically loads based on Plan ID)
• By ID: Manually enter the ID if you already know it

For Get/Update/Delete operations, you need to manually enter the Task ID.

Compatibility

Tested with n8n version 1.0.0 and above.

Resources

• n8n community nodes documentation
• Microsoft Graph Planner API documentation
• Microsoft Graph Explorer

Version History

1.4.0

• Updated branding
• New Planner icon/logo
• Added About Blickwerk Media section with company info and social links

1.3.9

• Added Get Files operation
• Retrieve all files attached to a task
• URLs are properly decoded for direct use
• Returns file metadata including alias, type, and last modified info

1.3.8

• Fixed priority values
• Corrected priority mapping: Urgent (1), Important (3), Medium (5), Low (9)
• Priority values now match Microsoft Planner API specifications

1.3.7

• Fixed Update Task response handling
• Fetch complete updated task data after PATCH operation
• Always returns full task object with all current values
• Fixes empty array and undefined description issues

1.3.6

• Improved Update Task response
• Update Task now returns complete task data including description
• Better user experience with full task details in response

1.3.5

• Documentation update
• Synced README with npm package (no code changes)

1.3.4

• Fixed "Empty Payload" error in Update Task
• Update Task now works correctly even when no fields are selected
• Only sends PATCH request when there are actual fields to update
• Improved error handling for update operations

1.3.3

• Restructured Get Many Tasks for better UX
• Added "Filter By" dropdown to choose between Plan or Bucket filtering
• Plan ID and Bucket are now separate fields (not in collection)
• Bucket dropdown now properly loads when Plan ID is entered
• Simplified Get/Update/Delete Task to use "By ID" only (no dropdown)
• Resource Locator UI for buckets with "From List" / "By ID" toggle

1.3.0 - 1.3.2

• Added resource locator UI for Buckets and Tasks
• Converted from loadOptions to listSearch methods
• Various fixes for dropdown loading issues

1.2.4

• Fixed Bucket and Task dropdowns not showing!
• Changed field type from 'string' back to 'options' for proper dropdown display
• Buckets now load correctly when Plan ID is entered
• Tasks dropdown now works properly

1.2.3

• Improved error handling for Buckets and Tasks loading
• Better fallback values when data cannot be loaded
• Added console logging for debugging dropdown issues

1.2.2

• Removed Plan dropdown (Plans cannot be loaded via API)
• Plan ID is now manual input only
• Buckets and Tasks still have dynamic dropdowns
• Simplified and more reliable plan selection

1.2.1

• Fixed Plans not loading (improved API endpoint to fetch from groups)
• Allow manual ID input in all dropdown fields
• You can now choose from dropdown OR paste IDs manually
• Added placeholders and better descriptions for all ID fields
• Improved error handling for plans loading

1.2.0

• Major UX Improvement: Added dynamic dropdowns for Plans, Buckets, and Tasks
• No more manual ID lookup - select from dropdown menus
• Plans load automatically from your Microsoft 365 account
• Buckets load dynamically based on selected Plan
• Tasks load from selected Plan or Bucket
• Improved user experience with clearer field labels

1.1.1

• Fixed startDateTime not being set (was returning null)
• Fixed user assignment by adding User.Read.All permission requirement
• Added error logging for failed user lookups
• Improved README documentation with all required permissions

1.1.0

• Added priority dropdown (Urgent, Important, Medium, Low) instead of number input
• Added user assignment functionality (assign tasks by email)
• Improved user experience with better field descriptions

1.0.1

• Fixed DateTime format handling (automatic conversion to ISO 8601)
• Improved error handling for invalid date formats

1.0.0

• Initial release
• Support for creating and retrieving Planner tasks
• OAuth2 authentication
• CRUD operations (Create, Read, Update, Delete)

License

MIT

Author

Developed by Blickwerk Media UG

About Blickwerk Media

We're a digital agency based in Germany, building automation, design, and web solutions for clients across industries.

Our focus is on efficient workflows, strong brand experiences, and open-source contributions that make digital tools more connected.

• Web: blickwerk.media
• LinkedIn: linkedin.com/company/blickwerkmedia
• Instagram: instagram.com/blickwerk.media

Support

For issues, questions, or contributions, please visit the GitHub repository.