cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
David_Diehl

Remove/Delete Completed Tasks in Planner

Submitted by on โ€Ž05-13-2019 07:02 AM

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
See more ideas labeled with:
5 Comments (5 New)
Comments
Amanzi
New Member
โ€Ž09-04-2019 02:00 AM

Would love to know the same!  I don't want to see my completed tasks it is taking up space I focus on what is active the same way that you can change views on Outlook tasks.  I created a flow that:  When a task is assigned to me in 'Planner' create an 'Outlook Task' which works BUT when I complete the task in Outlook it does not complete in Planner - any way around this?

Mike_B
Regular Visitor
โ€Ž12-05-2019 03:02 AM

An action which can be added to a scheduled task which has a few selectable options would be brilliant.

 

  • Team
  • Planner
  • Bucket
  • Age in days since marked completed
David_Nguyen
Microsoft
Microsoft
โ€Ž05-13-2020 04:39 AM

Here are steps to make a Scheduled flow to DELETE completed tasks in a Plan

 

List your Tasks in plan. Then, Apply to each task, get task, then Delete it.

image.png

Use Invoke an HTTP request with resource fields are

https://graph.microsoft.com.

URL: https://graph.microsoft.com/v1.0/planner/tasks/@{items('Apply_to_each')?['id']}

 

Use Parse Json with schema is:

 

{
    "type": "object",
    "properties": {
        "@@odata.context": {
            "type": "string"
        },
        "@@odata.etag": {
            "type": "string"
        },
        "planId": {
            "type": "string"
        },
        "bucketId": {
            "type": "string"
        },
        "title": {
            "type": "string"
        },
        "orderHint": {
            "type": "string"
        },
        "assigneePriority": {
            "type": "string"
        },
        "percentComplete": {
            "type": "integer"
        },
        "startDateTime": {},
        "createdDateTime": {
            "type": "string"
        },
        "dueDateTime": {},
        "hasDescription": {
            "type": "boolean"
        },
        "previewType": {
            "type": "string"
        },
        "completedDateTime": {},
        "completedBy": {},
        "referenceCount": {
            "type": "integer"
        },
        "checklistItemCount": {
            "type": "integer"
        },
        "activeChecklistItemCount": {
            "type": "integer"
        },
        "conversationThreadId": {},
        "id": {
            "type": "string"
        },
        "createdBy": {
            "type": "object",
            "properties": {
                "user": {
                    "type": "object",
                    "properties": {
                        "displayName": {},
                        "id": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "appliedCategories": {
            "type": "object",
            "properties": {}
        },
        "assignments": {
            "type": "object",
            "properties": {}
        }
    }
}
 
Add a new condition control to check if percentComplete is equal to 100
 
image.png
 
Then Delete the task id with the If-Math is from the dynamic content under the Get IF-MATCH action.
image.png
Good Luck!
 
David Nguyen
Hackerman
Regular Visitor
โ€Ž06-16-2020 01:03 PM

Heads up: The approach documented by @David_Nguyen probably works, but you need a Premium license to use the "Invoke an HTTP request" task.

Mike_B
Regular Visitor
โ€Ž06-17-2020 01:24 AM

Yes @Hackerman , I was hoping to get support to get the facility included in the functionality as an inbuilt feature more than 'belt and braces' to be honest.  I would have thought that most users would benefit from a simpler method of achieving this easily.

There is quite a bit lacking in the Planner app, it is not even easy to get the name of the person who completed a task to add for logging, really obvious stuff.

 

Mike.