Unanswered

Filtering Completed Tasks to the last 30 days

(0) Share

Report

Posted on by GazNicki

I am trying to create a scheduled flow which lists all tasks in a Planner Bucket which are completed.

I can filter the results to only show those which are 100% complete, and I can get that to send a table via email in HTML.

However, I cannot seem to be able to filter the list to show only the last 30 days.

I have tried to filter with Less Than or Equal to "addDays(utcNow(),-30)" but this doesn't work.

Can someone please guide me to how I can filter results into the last 30 days please?

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 32,852 Most Valuable Professional on at

Like (0)

Report
Re: Filtering Completed Tasks to the last 30 days

Hi @GazNicki,

I think you are pretty close to the solution. However, how are you filtering your tasks? Are you using a condition action?

If so, I would add an additional check if the completedDateTime is not empty. Otherwise your filter will fail for the tasks which haven't completed yet. I would also change the less than or equal to, to greater than or equal to.

Example with a task which is completed on the 12th of January:

12-01-2021 is greater than or equal to 02-01-2021 (utcnow() - 30 days)

Try the below approach if possible.

1. Add a condition within an apply to each action. Use the following two conditions with AND.

empty(items('Apply_to_each')?['completedDateTime'])

is not equal to true

AND

items('Apply_to_each')?['completedDateTime']

is greater than or equal to

addDays(utcNow(), -30)

Hope this helps a bit?

Was this reply helpful? Yes No
GazNicki 7 on at

Like (0)

Report

Re: Filtering Completed Tasks to the last 30 days

Hi @Expiscornovus

I was using Filter Array, and can't seem get the conditional to work. Unfortunately my skills in this are very very basic. I'm sorry 😞

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

Like (0)

Report

Re: Filtering Completed Tasks to the last 30 days

Hi @GazNicki,

Can you share a couple of screenshots of your current flow setup? I can adapt my example to that setup to help you out.

Was this reply helpful? Yes No