cancel
Showing results for 
Search instead for 
Did you mean: 

Remove/Delete Completed Tasks in Planner

I use Flow to create tasks on a regular basis, but I have no automated way to remove completed tasks.  I would like to be able to remove completed tasks from a Planner bucket using a Flow.

Status: New
Comments
Hackerman
Regular Visitor

I tested @cleytonp's approach on a Planner with 500 active tasks and around 6000 completed ones.  The "List Tasks" action only processes the first 400 tasks and apparently sorts the active tasks first.  I like the approach but it can't be used on big Planner boards with more than 400 incomplete tasks.

Hackerman
Regular Visitor

Using the new "Delete Task" action, I was able to delete all completed tasks from a large planner board.  It can process 5000 tasks per run but can be run multiple times.  In short:

  1. Export the tasks to Excel and host on OneDrive.
  2. Remove all in-progress tasks and convert data to a table in Excel.
  3. Setup flow to read from Excel table and delete tasks using Task ID.
    1. Important: change pagination on the List Rows action to 5000 or it will only process 256 rows.

Hackerman_0-1611784575466.png

Pagination setting:

Hackerman_1-1611784615645.png

 

Hackerman_2-1611784644272.png

 

ashok6
New Member

@cleytonp 

Can you modify it to delete completed tasks of only particular user...like providing his upn in flow

abbyamante
Helper I

@uvaismohammed  on the "list Task" settings try to turn on the pagination and set the threshold on a higher number. it can be set up to 100,000

 

abbyamante_0-1635857543369.png

 

james3
Advocate I

There is now a (preview) action that deletes a task!

 

https://docs.microsoft.com/en-us/connectors/planner/#delete-a-task-(preview)

cleytonp
Frequent Visitor

This it worked to me.


cleytonp_0-1642079946668.png