Changing planner labels based on the start date of a task

(1) Share

Report

Posted on by NV-13081500-0

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
NV-13081500-0 4 on at

Like (0)

Report

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!

Was this reply helpful? Yes No