web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Transferring Unique La...
Power Automate
Suggested Answer

Transferring Unique Labels from Planner to Excel via Power Automate

(0) ShareShare
ReportReport
Posted on by 3
I am new to power automate and am trying to get the labels from my planner into my excel spreadshet via the power automate flow. Right now I only see I've googled and looked through youtube for tutorials there aren't really any clear instructions for a beginner on how to complete this. Any advice?
Test Flow.png
Test Excel spreadsheet .png
Test Planner.png
I have the same question (0)
  • Suggested answer
    Inogic Profile Picture
    1,291 Moderator on at
    Hi,
     
    This is actually expected behavior when working with Planner labels, and it can be confusing at first because of how the data is structured internally.
    In Planner, labels are not stored as simple text on each task. Instead, Microsoft has designed this in two separate layers:
    • The label names (like “Urgent”, “Testing”, etc.) are defined at the plan level under CategoryDescriptions.
    • The labels applied to a task are stored in appliedCategories as boolean values (for example: category1 = true, category2 = false).
    Because of this design, when you retrieve a task using Power Automate or Graph API, you only get which categories are marked as true — not the actual label names.
    From Microsoft’s documentation:
    • CategoryDescriptions defines the label text for a plan ()
    • appliedCategories only indicates which labels are applied to a task ()
    Why your issue happens
    When exporting or reading task data:
    • You get something like → category1 = true
    • But you don’t directly get → “Urgent”
    So it looks like labels are missing, but actually they are just split across two different sources.
    How to handle this properly
    To get the actual label names, you need to combine both pieces:
    1. Retrieve Plan Details (to get CategoryDescriptions → actual label names)
    2. Retrieve Task Details (to get appliedCategories → true/false values)
    3. Match them:
      • If category1 = true → map it to CategoryDescriptions.category1
    4. Combine all matched labels into a readable format (e.g., comma-separated)
    5. Store that result in Excel or wherever needed
    Simple example
    • category1 = true
    • category2 = true
    From plan:
    • category1 = “Urgent”
    • category2 = “Client Work”
    Final result:
     “Urgent, Client Work”




    Reference
    Microsoft Docs:
    https://learn.microsoft.com/en-us/graph/api/resources/plannercategorydescriptions?view=graph-rest-1.0


    Hope this helps.


    Thanks!
    Inogic

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard