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

[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. 

[v-yujincui-msft]

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

[adelev125]

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?

[v-yujincui-msft · Accepted solution]

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

[adelev125]

YOU ARE THE BEST! 

Really appreciate it!