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!

[ChristianAbata]

no @pfarley  friend unfortunally is not possible this change needs to be manual

[pmadley]

Heh @pfarley  Somehow, I made it work. Newbie luck 😎

if(equals(item()?['CategoryColour'],'Pink'), True, False)

Hi there, I found this to work. I suppose you can then go into Planner and change the label name from 'Pink' to 'Name' once your flow has completed. Obviously I made a new column in the Excel table called 'Category Colour'. Unfortunately, Flow can't do the new colours, such as 'Bronze'.

[pmadley]

Success:

1. I went into Planner and set up the 6 possible labels
2. I added a new column 'Label' to the Excel table
3. For 'Pink' I did: if(equals(item()?['Label'],'Moderate'), True, False)
   (Red = 'Critical or Serious', Yellow = 'Minor' etc...)

[pfarley]

@pmadley Thanks! Below is the general makeup of my flow.

Where would you recommend placing the conditions? My excel sheet that is inserted into Sharepoint only has values in it. 

Would it be best to place the conditions here? If so, how?

[Zubaid]

@pmadley If I already have labels created ie. each label is created for a specific team how do i assign my flow to that label without having to add the label manually to the team. I tried the above, but this does not add the label.

[Raj6]

I tried this but somehow I cannot see the desired result like yours on the right hand side. It's blank for me 😞

[claus8402]

Any chance someone was able to get this working?  I tried the above, but I can't get it to create labels on the new task

[pmadley]

Woah it feels like an eternity since I did this.

I recall that I had to set up the labels beforehand, then have a column in my excel file that had the label name (instead of colour). At the time it was restricted to the initial 6 colours Planner initially provided.

I'm currently doing a massive piece of ElasticSearch work so I can't commit to help atm I'm afraid.

Also... DISCLAIMER: I am not a 365 or Flow or Planner expert. I was just playing around. Don't rely on anything I say!

[claus8402]

Thanks for the reply.  It sounds like the integration between power automate and planner is still relatively new/underdevelopment.  

[AllyWard]

I've got this working - though I only setup up coloured labels - doesn't change the name of them. But you only have to do that once, when the planner is complete.

I use excel as a source with boolean columns for each label I want to create. 

I initialise boolean variables first

then create conditions looking at the columns in my excel spreadsheet for whether each of the labels conditions is true or false and setting my variable true or false accordingly

Note that you need to look for True (not true or TRUE) in order for it to check it properly but set the variables with lower case

Conditions to set variables

then finally when I create the task I use the variable

Add the task using the variables for the labels

[AllyWard]

I've posted what I do - it's working for the 25 labels available now

[FatherJB]

While you can't programmatically change the label names, assigning them is pretty easy.  For each object, you just have to do whatever logic you want to determine the label(s) color and then do one of these in each of the color options:

equals(variables('Label'), 'Pink')

If you want a list of labels, just make the variable an array, append each colors, and use:

contains(variables('Labels'), 'Pink')

Works like a charm. 

[pmadley]

Yeah... that's basically what I did a year ago 😉

That said. It's useful to have consensus.

[richardbourque]

Is there a walk-through for this method somewhere? I'm a total noob trying to automate this on my own for my design department.

[Monsten]

Your result is good, my I know more about your flow? I'm trying to set up a flow in which tags will be added to the planner task if the value of a certain column is for e.g. "USA". I used your formula and replace the parameters but it did not work.

[AllyWard]

What do you want to know? What didn't work?

[Monsten]

I have been working on a flow which creates a planner task for a selected table row.

I attached a screenshot of my table as well

I want the planner task to have red tag if the value in the country column is colombia, so I put this in

The expression is as follow: if(equals(item()?['Country'],'Colombia'),True,False)

how ever when I run it with corresponding rows, the expression returns false even if the row I selected has 'colombia' in 'country' column. I don't know what I have done wrong.

[Monsten]

when I look into the run history, i cant see why false is return from the expression

[AllyWard]

try setting your variable for country to 'true' or 'false' - lowercase. (if(equals(item()?['Country'],'Colombia'),true,false) I seem to remember it was very case sensitive. You're not doing things quite the same way I did - but this is a fairly quick thing to try