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

[milo1234]

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. 

[ChrisMendoza]

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

[milo1234]

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? 

[ChrisMendoza]

@milo1234- '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.