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

[GustavoAlves]

Hello all!

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

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?

[Rhiassuring]

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

[GustavoAlves]

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:

Thanks again

[Rhiassuring · Accepted solution]

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:

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]

Thank you very much @Rhiassuring !!

😃