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

(0) Share

Report

Posted on by Community Power Pla...

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.

Label Issue.jpg

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!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Rahber 1,935 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rahber 1,935 on at

Like (0)

Report

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-p/181469
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-into-sharepoint-list/idi-p/277366

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @Rahber

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

Was this reply helpful? Yes No
GregB79 4 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Dubya-eye-el-el 58 on at

Like (1)

Report

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.

Was this reply helpful? Yes No