Skip to main content

Notifications

Power Automate - Using Flows
Answered

Adding a line in a table(excel) for each category in a task(Planner) - it is possible?

(1) ShareShare
ReportReport
Posted on by 12

Hello all!

 

I am trying to register every label on my tasks in a excel table:

 

GustavoAlves_0-1656710779585.png

Sorry about the Portugueses i dont know how to change it..

 

This model is returning a error "ExpressionEvaluationFailed" Appliedcategories is a object, and it should be a valid matrix...

 

Can somebody help me?

  • GustavoAlves Profile Picture
    GustavoAlves 12 on at
    Re: Adding a line in a table(excel) for each category in a task(Planner) - it is possible?

    Thank you very much @Rhiassuring !!

     

    😃 

  • Verified answer
    Rhiassuring Profile Picture
    Rhiassuring 8,688 on at
    Re: Adding a line in a table(excel) for each category in a task(Planner) - it is possible?

    Gotcha. Okay, so, we know that the info comes back as an object with only the "true" categories in it. And we know there are 23 categories. (Unless they've changed that again .... I remember when there were only 6...)

    So you could do something like this as you loop through each of your items:

     

    Rhiassuring_0-1656917600305.png


    That means you'll get a hit if there's a matching category, and then you can also get the actual name from your own array.

    The condition is "appliedConditions" contains items('Apply_to_each')?['label']

     

  • GustavoAlves Profile Picture
    GustavoAlves 12 on at
    Re: Adding a line in a table(excel) for each category in a task(Planner) - it is possible?

    Hi @Rhiassuring !

     

    Thanks for the response!

     

    Yes for the first question. I need to register a line in a excel table for each category that returns "true".

     

    Something like:

    Plan ID | Bucket ID | Task ID | "Category 3"

    Plan ID | Bucket ID | Task ID | "Category 9"

     

    Following the output:

    GustavoAlves_0-1656867538332.png

     

    Thanks again

     

  • Rhiassuring Profile Picture
    Rhiassuring 8,688 on at
    Re: Adding a line in a table(excel) for each category in a task(Planner) - it is possible?

    Hi there, 

     

    Are you using the Get Task Details to get the AppliedCategories? And then you're trying to loop through each category it brings back, and create a new entry in your Excel sheet?

    Based on this, it looks like the categories will come back with a true / false next to them -- are you able to show us some example outputs with what you have so far?

     

    https://docs.microsoft.com/en-us/graph/api/resources/plannerappliedcategories?view=graph-rest-1.0

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics

Restore a deleted flow