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!
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 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?
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks