Assigning Planer Labels through Power Automate

[pfarley]

Hi everyone! First-time poster here.

I am using Power Automate in order to set up Teams -> Planners. I'm using these as task workflows. I set up all of the tasks in an Excel spreadsheet and then feed it into Sharepoint for the population of data in Planner.

Everything is working great except for one thing. After it finishes populating in Planner, I have to go through each task and manually add the Label. The labels are used to differentiate roles... ie. Marketing vs Operations.

The Labels are defined in the spreadsheet I am using. Is there a way to modify the Flow to allow Labels to be assigned through this task population, automation?

I can post pieces of my setup if it will help. Thanks!

[Monsten]

Tried. Still not working.

[paendorrah]

Did you ever find a solution to this? Trying to achieve much the same result here 🙂

[AllyWard]

You can add the labels by colour - you just can't name them through the flow.

So assign colours to match your labels in your source file.

In the flow initialise variables for each of the labels colours you are using and one to check the colour in your source

Set the variable Colour equal to your colour in the source

@{items('Apply_to_each_-_Process_Completed_tasks')?['Colour']}

Then set a condition for whether your label is on or off

Then do a create task using the variables

So the final piece after adding them is to manually name the labels in the plan. You only have to do it once

[Darrylp]

Hi AllyWard,

Can you provide more details on what is needed in the variables below?  I continue to get errors.  Also, can you show the whole flow?

[AllyWard]

Why don't you post your flow it might be easier to see what you are doing and maybe where you are going wrong?

[paendorrah]

This brought me to a solution that worked out for me 🙂 Thanks for the input, it's much appreciated!

[takolota]

Anyone considering more customizations of Planner with things like Power Automate or Teams, I recommend checking this option 1st to get a Planner-like board on a SharePoint list view that can interface with Teams:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Project-Tracker-SharePoint-and-Teams/td-...

It’s often much easier to customize & program things for SharePoint and avoids a lot of syncing efforts.

[pmadley]

Honestly dude, I'm no expert but if you follow my example above it should be a breeze. Hopefully you got it sorted by now, but I'm happy to answer questions.

[richardbourque]

I figured it out a while ago and its amazing! I have a filtering systems based on input from the people requesting projects. Quite useful!

[lhern]

brilliant! this worked!!!

[SusanaMdL]

Is it me or now the Create a Task action doesn't allow to assign labels directly?

I cannot see the label colors as parameters in the form.