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?
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']
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
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