SharePoint Document Issues

How to Show Microsoft Planner Label Names in SharePoint with Power Automate

Muhammad Talha Sep 27, 2026 870 views

Question details

The user needs to retrieve the actual text names of Microsoft Planner labels instead of their default category IDs or boolean values, and save them into a SharePoint list item via Power Automate.

How to Show Microsoft Planner Label Names in SharePoint with Power Automate

Product: Power Automate, SharePoint, Microsoft Planner
Device & OS: not provided
Scenario: Building a Power Automate workflow that synchronizes Microsoft Planner task details, specifically custom label names, with a SharePoint list.
Observed behavior: By default, Planner connectors often return label categories as boolean values (true/false) for standard colors rather than the customized text names, requiring connector-specific logic to extract or map the names correctly.

Before you start

Ensure you have active licenses for Microsoft 365, adequate permissions to edit Power Automate flows, manage Planner tasks, and modify the target SharePoint list columns.

Solution 1Recommended

Map Planner Label IDs to Text Names using a Condition or Switch

Since the standard Power Automate Planner connector retrieves applied labels as boolean values for specific colors, you must manually map these true/false values to your custom text names before updating SharePoint.

The standard Planner connector does not natively pull the customized text of a label. Instead, it checks whether 'Category 1' (Pink), 'Category 2' (Red), etc., are applied to the task.

By setting up a string variable and conditional checks, you can translate these boolean values into human-readable text for your SharePoint list.

Retrieve task details

Open your Power Automate flow and add the 'Get task details' action from the Planner connector, specifying the relevant Task ID.

Initialize a variable

Add an 'Initialize variable' action at the start of your flow. Set the Type to 'String' or 'Array' (if allowing multiple labels) to store the mapped label names.

Add conditional logic

Add a 'Condition' control for each category. For example, check if 'Applied Categories Category 1' is equal to 'true'.

Set the label name

Inside the 'If yes' branch of the condition, add an 'Append to string variable' or 'Append to array variable' action, and type in the exact customized name of that label.

Update SharePoint list

Use the 'Update item' or 'Create item' SharePoint action at the end of your flow. Map your populated string or array variable into the desired SharePoint list column.

Map Planner Label IDs to Text Names using a Condition or Switch

Handling Multiple Labels: If tasks frequently have multiple labels applied, using an Array variable followed by a 'Join' data operation is the best way to format them as a comma-separated string for SharePoint.

Solution 2

Consult the Microsoft Power Platform Community

For complex API implementations, fetching label names dynamically via HTTP requests, or troubleshooting specific connector failures, the official Microsoft community is the best resource.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Power Automate and SharePoint manage your complex workflows, consider WPS Office for your everyday document needs. It is a highly compatible, lightweight, and free alternative to Microsoft Office that perfectly handles all standard document formats.

1. Download the installer: Visit the official WPS Office website and download the correct installer for your operating system.
2. Complete installation: Run the downloaded setup file and follow the brief on-screen instructions to install the suite.
3. Edit documents effortlessly: Launch WPS Office to instantly open, edit, and save your Microsoft Office documents with perfect formatting preservation.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design ensuring fast startup times and exceptionally smooth performance.Familiar, intuitive user interface that requires zero learning curve to master.Seamless integration with popular cloud storage options for easily opening and editing documents stored online.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate return true/false for Planner labels instead of text?

The Microsoft Graph API underlying Planner treats the colored labels (Category 1 through Category 25) as boolean properties on a task. The API returns true if a specific color category is applied, rather than returning the customized text name you assigned to that color.

Can I automatically fetch customized label names directly from Planner without manual mapping?

Currently, the standard Power Automate Planner connector does not directly output custom label names. Retrieving them dynamically requires creating an advanced flow that uses the 'Send an HTTP request' action to query the Planner Plan Details API endpoint, parsing the JSON response, and extracting the category names.

How do I write multiple Planner labels to a single SharePoint column?

You can append each mapped label name to an array variable during your condition checks in Power Automate. After all conditions are checked, use the 'Join' data operation to combine the array elements into a single comma-separated string, which you can then pass into your SharePoint 'Update item' action.

Document & File Issues