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.
@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']
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?
@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.