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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (4,079)