web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Changing planner label...
Power Automate
Suggested Answer

Changing planner labels based on the start date of a task

(1) ShareShare
ReportReport
Posted on by 4
Hi,
I would like to be able to check the tasks in my planner each day and if the start date is today or in the past, assign the green label (named Current), if the start date is yet to happen, I would like to assign the silver label (name Future). So I would need to switch tasks from future to current as the start date arrives.
I am a completely newbie to this and have had a go - but I am clearly not understanding something really basic!
This is the overview of what I have tried to do, but it doesn't work:
 
When I run it I manage to get through the this first filter stage ok:
 
 
but this one doesn't work- is it because I have chosen the start date field from the previous filtered list?
 
 
The the 'for each' was inserted automatically and I'm not sure it is the correct approach?
I then had the following condition:
and if true, I tried to update the task to have a silver label and not a green one:
 
Any help would be really appreciated as what I have done just does not work!
 
Many thanks!
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,978 Moderator on at
    Hi
     
    So, for filters, its a little weird when you start using them. Instead of putting in the Dynamic Property that you did, Filters work like this.
     
    When you put a Value in the From (or whatever Array you have), in the back end it creates a loop for you BUT does not make you use an Apply to each
     
    so in the left side instead you put something like this
     
    item()['ColumnNameFromPlanner'] // if you are not sure, in a Run download the Raw OUTPUT from listing you tasks, so that you have it. 
     
    In an Apply to Each(the UI you are using calls it For each), you access via item() or items()
    in Filter Array you access via item()['ColumnNameFromPlanner']
     
    So change that first.
     
     
  • NV-13081500-0 Profile Picture
    4 on at
    Hiya,
     
    Thank you  - I have tried to make edits today but I am getting absoltely nowhere! :(
     
    I wanted 2 filters, is there a way to just combine filter conditions into a single filter array expression to ensure my output has excluded tasks that are either completed or don't have a start date?
     
    I tried this and it didn't work:
    @or(not(equals(item()?['percentComplete'],100)),greater(item()?['startDateTime'],@{utcNow()}))
     
    Then I get stuck again with the condition - I have deleted it all and rebuilt it several times.
    When I add the conditon,  the loop is created automatically - but it doesn't work? 
     
     
     
     
    When I try to add in the output manually and look at my available options, body isn't one of them! But Item doesn't work either?
     
     
    Any help would be greatly appreciated! 
     
    I can't believe how unintuitive this is!
     
    Thanks!
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 957

#2
Valantis Profile Picture

Valantis 847

#3
Haque Profile Picture

Haque 609

Last 30 days Overall leaderboard