Unanswered

Log new tasks created in Planner in Excel Online (Business)

(0) Share

Report

Posted on by Community Power Pla...

I have created a flow which logs new tasks created in MS Planner into an Excel spreadsheet, however is there a way that I can pass the 'label' field on the MS Planner into the spreadsheet?

I need this value to differentiate between the tasks as they all have a unique code.

Categories:

Process mining

I have the same question (0)

All responses (3)

Answers (0)

ChrisMendoza 425 on at

Like (0)

Report

Re: Log new tasks created in Planner in Excel Online (Business)

@Anonymous- What is the label field? Do you mean categories? For categories you'll need https://docs.microsoft.com/en-us/connectors/planner/#get-a-task which returns https://docs.microsoft.com/en-us/connectors/planner/#gettask_response_v2 and that includes ['appliedCategories']

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

Like (0)

Report

Re: Log new tasks created in Planner in Excel Online (Business)

Hi @ChrisMendoza The label field is the green label shown in the attachment which you can personalise and apply to each planner task. How would I pass this through a Power Automate flow into an excel file?

Was this reply helpful? Yes No
ChrisMendoza 425 on at

Like (0)

Report

Re: Log new tasks created in Planner in Excel Online (Business)

@Anonymous- 'label' is 'appliedCategories' in Power Automate so you'll use what I suggested → For categories you'll need https://docs.microsoft.com/en-us/connectors/planner/#get-a-task which returns https://docs.microsoft.com/en-us/connectors/planner/#gettask_response_v2 and that includes ['appliedCategories']
Since you can apply multiple you'll end up with an array or values; meaning 'Apply to Each' unless you use a function to get a specific value in that array.

Was this reply helpful? Yes No