Get the label description (planner task) and write it in excel report

[Anonymous]

Hello

I've been working on a flow to get the data from a planner board and fill an excel file with that information.

From the dynamic content I took almost all the data that I need.

But I dont know how to take the label description to write that in the spreadsheet.

I tried typing "item()?['appliedCategories']" in the field marked in yellow but that didnt work.
Can anyone help me to know how I could do this?

Thanks!

[Rahber]

Can you show a picture of the planner which field you want in the label?

[Anonymous]

Hello @Rahber 

Im talking about the labels that we can create for the tasks:

What I would like to do is to take that and put the label text into a spreadsheet in the column "Label" of the excel file:

But I dont know how to call for it since the label is not available in the dynamic content list.

Thanks

[Rahber]

Unfortunate this functionality is not supported yet through direct planner action. You can see following Ideas to implement this feature:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Flow-to-update-label-of-task-in-Planner/idi...

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Update-label-of-a-planner-task/idi-p/177656

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Planner-Flow-get-labels-from-planner-task-i...

You can however get the label value through GraphAPI but you would need to write a custom connector.

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

[Anonymous]

Thanks @Rahber 

Im not related with graph API but I will review this option.

Regards

[GregB79]

There is probably a more elegant way to do this but I used a series of expressions to achieve this. This would really only work if you have a finite amount of labels that you have already predefined. 

I have a planner that has three labels for Small, Medium and Large. The expression checks if the label exists (is True) and writes my label name to the field. Create an expression for each label.

if(equals(triggerOutputs()?['body/appliedCategories/category17'],True),'Small','')
if(equals(triggerOutputs()?['body/appliedCategories/category15'],True),'Medium','')
if(equals(triggerOutputs()?['body/appliedCategories/category13'],True),'Large','')

triggerOutputs()?['body/appliedCategories/category17'] is the "Light green" label which has been renamed as "Small" in my planner. 

[Dubya-eye-el-el]

Searching for a similar issue and came across this solution posted last year by @jakemannion (assuming this is the correct Jake Mannion?; both are from Oregon).

Hope it helps anyone else that may run across this while looking for a solution, but realize that "Anonymous" will likely not respond and/or mark as a solution.