Delete flow when MS planner task has reached up to 3,000 tasks.

(0) Share

Report

Posted on by adelev125

Hi All,

Is there any way to create a flow when number of planner task is over than 3,000?

Because MS planner has limitation that the number of task is 3,000 then I'd like to create a flow to delete older and completed tasks automatically when the limitations are reached.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-yujincui-msft on at

Like (0)

Report
Hi @adelev125 ,

Do you want to automatically delete expired and completed tasks when the number of planner tasks exceeds 3000?
I have made a test for your reference.
length(outputs('List_tasks')?['body/value'])
@and(less(item()?['dueDateTime'], utcNow()),not(equals(item()?['completedDateTime'], null)))
item()?['Id']
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
adelev125 7 on at

Like (0)

Report

Hi Charlie!
It's really helpful solution for me. Thank you for your effort.

BTW, I have one thing to ask.
In your flow, It seems to correspond to a task within a particular project after specifying a specific group of projects rather than listing the entire planner's task list, but may I modify the flow to correspond to the entire list of planner?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @adelev125 ,

You can try to list all Tasks and count the total number, and then determine if you need to delete them.
I have made a test for you.

1.Create a flow.
add(add(length(outputs('List_tasks')?['body/value']),length(outputs('List_tasks_2')?['body/value'])),length(outputs('List_tasks_3')?['body/value']))
@and(less(item()?['dueDateTime'], utcNow()),not(equals(item()?['completedDateTime'], null)))
item()?['Id']
Details:
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
adelev125 7 on at

Like (0)

Report

YOU ARE THE BEST!

Really appreciate it!

Was this reply helpful? Yes No