Unanswered

Assigning Planer Labels through Power Automate

(4) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (31)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
pmadley 35 on at

Like (4)

Report

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

Was this reply helpful? Yes No
pmadley 35 on at

Like (0)

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

Was this reply helpful? Yes No
pfarley 69 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
Zubaid 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Raj6 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
claus8402 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
pmadley 35 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
claus8402 6 on at

Like (1)

Report

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

Was this reply helpful? Yes No
AllyWard 22 on at

Like (1)

Report

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

Was this reply helpful? Yes No