Answered

Using Filter Array with Planner Dates and UTC(now)

(0) Share

Report

Posted on by augustine2

Hello,

I have a flow that will periodically that is supposed to filter for Planner tasks that have due dates more than 30 days from today.

We are initializing today's date as string as 'TestDate'. The value for TestDate is

formatDateTime(addDays(utcNow(),-30),'yyyy-MM-ddThh:mm:ssZ').

We use a filter array where due date is less than TestDate which should bring tasks that have due dates more than 30 days from today. However, we are getting the error "The execution of template action 'Filter_array_3' failed: The evaluation of 'query' action 'where' expression '@less(items('Apply_to_each_2')?['dueDateTime'], variables('TestDate'))' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

We want to ultimately use the "Delete a Task" Planner action to bulk delete these tasks. But we can't get past this stage.

Any help will be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Ellis Karim 11,994 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

This error is due to the fact that some of your tasks do not have due dates. It fails because it is trying to compare a null value with a date-time variables('TestDate').

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @augustine2 ,

move the 'Filter array' out of the 'Apply to each', you don't need to process the tasks one by one, Filter array will take the whole array and filter it.

The 'Apply to each' and the error was caused because you entered the 'value Due Date' first in the 'Filter array', you should enter the From 'value' first and only then the 'value Due Date', that way it won't add the loop.

Was this reply helpful? Yes No
augustine2 44 on at

Like (0)

Report
Copy link

Link copied!

thank you much. I filtered out the nulls and still had the same error.

Was this reply helpful? Yes No
augustine2 44 on at

Like (0)

Report
Copy link

Link copied!

Let me try this and will let you know.

Was this reply helpful? Yes No
augustine2 44 on at

Like (0)

Report
Copy link

Link copied!

I can't really take move the filter array out of the "Apply to Each" because of the List Tasks action.
So, I tried this:

But, I'm getting this error:
The 'from' property value in the 'query' action inputs is of type 'Object'. The value must be an array.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,994 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@tom_rihasuggestion is for the flow to look something like this:

Ellis

Was this reply helpful? Yes No
augustine2 44 on at

Like (0)

Report
Copy link

Link copied!

Got it! Thank you

Was this reply helpful? Yes No