cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GustavoAlves
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Rhiassuring
Super User
Super User

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

 

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



View solution in original post

4 REPLIES 4
Rhiassuring
Super User
Super User

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

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



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
Super User
Super User

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

 

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



GustavoAlves
Frequent Visitor

Thank you very much @Rhiassuring !!

 

😃 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,244)