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

(1) Share

Report

Posted on by 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?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GustavoAlves 12 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,692 Moderator on at

Like (3)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GustavoAlves 12 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much @Rhiassuring !!

😃

Was this reply helpful? Yes No