Planner/Tasks - Sort Task Completion from Newest to Oldest for an Employee

Question

Planner/Tasks - Sort Task Completion from Newest to Oldest for an Employee

Kurt 20

I'm transitioning to using MS Planner to help organize my staff. As part of our check-ins, we review what tasks has been completed to verify if we do agree the item is closed.

Is there a way to filter tasks to an individual and sort it by when it was closed?

For context, we plan to have these check-ins weekly. As more tasks get added and are complete, I'm concerned there's no easy way to look at tasks completed in the past week to review them.

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Hi @Kurt,

Welcome to Microsoft Q&A forum.

Thanks for reaching out with your question about tracking completed tasks in Microsoft Planner. I understand how important it is to have clear visibility into what each team member has accomplished - especially when you’re conducting weekly check‑ins and need a reliable way to review recently completed work.

In Microsoft Planner, you can filter tasks assigned to a specific team member and display only the completed items:

Go to your plan’s Board (or List) view
Select Filter > Assignment and choose the staff member
Then select Filter > Progress > Completed

You can also use Group by > Assigned to to visually separate each person’s completed tasks.

However, Planner does not currently support sorting tasks by “date completed”. It allows grouping by Bucket, Assigned to, Progress, Due date, and Labels, but sorting by completion timestamp isn’t available in the UI.

Here are suggestions you can try:

Option A: Quick, no‑code approach: Export & sort in Excel

Since the Planner interface doesn’t sort by completion date, the most reliable approach is:

Apply filters in Planner: Filter > Assignment > choose the person, and Progress > Completed
Select Export plan to Excel at the header of your plans
In the exported file, sort by the column that contains the completedDateTime

Excel displays the actual completion timestamp, allowing you to filter tasks from the last 7 days for your weekly sessions. Many teams use this method specifically for weekly and monthly reviews.

Note: You can create a reusable Excel filter (e.g., “Completed in last 7 days”) and apply it after each weekly export.

User's image

Option B: Automated weekly report using Power Automate

Planner stores a completedDateTime value for each task. With Power Automate, you can create a scheduled weekly flow that:

Pulls all tasks marked complete in the past week
Filters them by assignee
Sorts them by completion date
Emails a clean summary to you (or saves it to Excel/SharePoint)

If you’re interested in the automation approach, you may find more specialized help in the Microsoft Power Platform Community Forum, where members focus on Power Automate scenarios.

I apologize for the redirection, but as moderators of the Microsoft 365 category, our access to deeper developer-level details is limited. We aim to guide you to the resource best positioned to help you implement automation if needed.

Submit feedback to Microsoft:

As a forum moderator, I hope you understand that I don’t have the ability to modify or escalate product issues directly. However, I strongly recommend submitting your feedback through the Microsoft 365 Feedback Hub > Send Feedback > Describe your proposal in detail . This is the most effective way to ensure your partner's voice reaches the product team and can be considered for future improvements.

Once you've submitted your feedback, feel free to share the link here in the comments. I’ll be happy to upvote it to help bring more visibility. If you prefer, I can also submit this great idea on your behalf. Just let me know, and I’ll post it for you and share the link once it’s published. I’m here to help ensure your feedback gets the attention it deserves.

Additionally, as other users have raised similar concerns and may not be aware of where to share their feedback, I hope this response helps clarify the situation and suggests a potential next step. Highlighting this information can make it more visible to others in the community who may be facing the same issue, making it easier for them to find guidance and contribute their feedback as well.

Thank you again for your time and for raising this important usability concern.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Kurt 20 Reputation points

2026-02-10T00:33:42.0466667+00:00

Thank you! The downloadable Excel is a good solution. I hope in the future Teams would allow users to customize the columns and add "date completed" as this would help reduce steps.
Kristen-L 10,585 Reputation points Microsoft External Staff Moderator

2026-02-10T21:12:40.3633333+00:00

Hi @Kurt,

Thank you for your response.

I’m glad to hear that the downloadable Excel file works well for you as a current solution.

If adding customizable columns - such as a “Date completed” field - in Microsoft Teams would help streamline your workflow, I absolutely encourage you to share this suggestion with Microsoft through the Feedback option in Teams. Customer feedback plays a major role in shaping future updates, and submitting it directly ensures it reaches the product team for review.

If you found my answer helpful, I would truly appreciate it if you could mark it as the “Accepted Answer.” Doing so will pin it to the top of the thread, making it easier for others in the community to find the right guidance quickly. Your contribution not only confirms the solution but also helps fellow users who may face the same challenge.

If you have any concerns or questions in the future, please do not hesitate to reach out. I will be happy to assist you, and all moderators in the Q&A forum will also do their best to provide support and guidance.

I value you as a customer and thank you for contacting the Microsoft Q&A forum.

Answer 2

To filter tasks by an individual and sort them by completion date in Microsoft Planner, you can utilize the Planner's built-in features. However, as of now, Microsoft Planner does not provide a direct way to sort completed tasks by their completion date within the app itself.

You can view tasks assigned to an individual and manually check their completion status, but for sorting by completion date, you may need to export the tasks to Excel or use Power Automate to create a more customized report. This way, you can filter tasks completed in the past week and sort them accordingly for your weekly check-ins.

For ongoing task management, consider using the Planner API or Microsoft Graph to programmatically retrieve tasks and their completion dates, which could help in generating reports tailored to your needs.

If you're looking for specific commands or methods to achieve this, please let me know, and I can provide more details on using Power Automate or the Planner API.

Share via

Planner/Tasks - Sort Task Completion from Newest to Oldest for an Employee

1 additional answer

Your answer