Create an condition with start date from planner

(0) Share

Report

Posted on by Community Power Pla...

Hey,

Taking tasks from planner an in to Excel to with start and due date to make a chart with average time and more....

But when a project is completed without the start and due date filled out the Excel table does not work as it should.

I want to Isolate out the tasks that is missing the start or due date in an Condition

I have tried using the empty function to check if the start and due date was empty.

But it dint seam to work properly because every thing came out empty...

I have also tried saying that the the start and due date needs to contain 20 as in the 20 in 2022 ore 2023

Do any of you have a better way I can isolate the tasks missing the start or due date?

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 32,891 Most Valuable Professional on at

Like (0)

Report
Re: Create an condition with start date from planner

Hi @Anonymous,

You want to ignore the ones without dates correct? In that case I would also have expected a not function in your expression.

You can check both dates in one single expression with an and. I would use this expression in a Filter array action.

Below is an example of that approach:

@and(not(equals(empty(item()?['startDateTime']), true)),not(equals(empty(item()?['dueDateTime']), true)))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Create an condition with start date from planner

That is exactly what I mean!
But how can I reed the outcome of the filter array?
Thanks! @Expiscornovus

Was this reply helpful? Yes No
Expiscornovus 32,891 Most Valuable Professional on at

Like (0)

Report

Re: Create an condition with start date from planner

Hi @Anonymous,

You can for example loop through the body field of the filter array and use the dynamic content fields of that action instead of the List tasks (which isn't filtered).

Below is an example screenshot. As you can see in the outputs of the filter array you should also be able to access the fields of the tasks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Create an condition with start date from planner

Hey!
Tanks for the helped I got it to work now!!

Was this reply helpful? Yes No
Expiscornovus 32,891 Most Valuable Professional on at

Like (1)

Report

Re: Create an condition with start date from planner

Hi @Anonymous,

Great to hear you got it working 🙂

Was this reply helpful? Yes No