cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pfarley
Helper I
Helper I

Assigning Planer Labels through Power Automate

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!

4 REPLIES 4
ChristianAbata
Super User II
Super User II

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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

 
bronze.pngcolours.png

 

pmadley
New Member

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

labels correct.png

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

pfarley_0-1620651516146.png


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?

pfarley_1-1620651599174.png

 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (27,752)