Weekly digest email of all Planner tasks due in the next 2 weeks

(0) Share

Report

Posted on by CiaraPollen

I'm trying to create a flow based on this template: Send a digest email of all outstanding Planner tasks

However, rather than listing all outstanding tasks, I'd like it to only list tasks due in the next 2 weeks.

Does anyone have any ideas?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @CiaraPollen ,

Please refer to the following expression to filter tasks:

@and(not(equals(item()?['percentComplete'], int(100))), less(item()?['dueDateTime'], addDays(utcNow(), 14, 'yyyy-MM-dd')))

Best Regards,

Was this reply helpful? Yes No
CiaraPollen 6 on at

Like (0)

Report
Copy link

Link copied!
@v-bacao-msft Thank you for the suggestion.

This is very similar to a fix I already attempted, and returned the error below:

InvalidTemplate
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@and(not(equals(item()?['percentComplete'], int(100))), less(item()?['dueDateTime'], addDays(utcNow(), 14, 'yyyy-MM-dd')))' 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.'.

I have seen another template which uses the term 'coalesce' rather than asking for a date 'less than' 14 days from now, but my coding skill is not good enough to understand why and how to resolve the above error!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @CiaraPollen ,

Because you have not set due date for some tasks, this error will appear.

You can first filter out tasks whose due date is not empty.

Best Regards,

Was this reply helpful? Yes No
johnnybirdman 2 on at

Like (0)

Report
Copy link

Link copied!

I was able to get the output I wanted with this solution, thank you! A follow-up question: my output now only shows the following 2 weeks, but the output is not in order by due date. Any way to solve this?

Was this reply helpful? Yes No
trishmalloy 415 on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft

Knowing how to sort ascending by due date would be most helpful. Are you able to help with this?

Was this reply helpful? Yes No
qopwer12 46 on at

Like (0)

Report
Copy link

Link copied!

Hi everyone, new user here

When I put this into my filter array,

@And(not(equals(item()?['percentComplete'], int(100))), less(item()?['dueDateTime'], addDays(utcNow(), 14, 'yyyy-MM-dd')))

This format does work for my build but when I run it, no tasks appear at all.

Is it because I converted my HTML table to show Eastern Standard Time?

Also is there a way to sort the due date as previously asked by my fellow powerautomaters above?

EDIT: The formula worked for me. Also the due dates came out in ascending order automatically

Was this reply helpful? Yes No