Others

How to Include Overdue Tasks in Microsoft Planner Daily Emails

Steve K Oct 10, 2026 868 views

Question details

The user needs to ensure that all overdue tasks, including those past due for several days, are included in Microsoft Planner's daily notification emails.

How to Include Overdue Tasks in Microsoft Planner Daily Emails

Product: Microsoft Planner
Device & OS: not provided
Scenario: Tracking task deadlines and ensuring team members are reliably notified about older overdue items.
Observed behavior: Microsoft Planner daily emails list tasks due today and upcoming tasks, but stop including tasks that have been overdue for several days due to standard notification limitations.

Before you start

Ensure you have an active Microsoft 365 subscription with access to both Microsoft Planner and Power Automate. You will need sufficient permissions to create and manage automated cloud flows within your workspace.

Solution 1Recommended

Create a Scheduled Power Automate Flow

Since Planner's default daily emails limit the history of overdue tasks, building a custom Power Automate flow is the recommended way to consistently notify users of all overdue items.

Power Automate can run a daily schedule to scan your Microsoft Planner board, filter out tasks that are past their due date and remain incomplete, and send a consolidated email to the assignees.

Open Power Automate

Log into your Microsoft 365 account, open the App Launcher, and select Power Automate.

Create a Scheduled Cloud Flow

Click on 'Create' from the left menu, select 'Scheduled cloud flow', name your flow, and set it to run daily at your preferred time.

Add the Planner Action

Click 'New step', search for the Planner connector, and select the 'List tasks' action. Choose the Group Id and Plan Id from the dropdown menus.

Filter the Overdue Tasks

Add a 'Filter array' action to evaluate the tasks. Set the condition so that the 'Due Date' is less than the current date and time (using the utcNow expression), and the 'Percent Complete' is less than 100.

Send the Email Notification

Add a 'Send an email (V2)' action. Format the body of the email to include dynamic content like the Task Title, Assignee, and a link to the Planner board, then save and test your flow.

Use Community Templates: To save time, check the Microsoft Power Automate Community for pre-built flow templates designed specifically for emailing Planner overdue tasks.

Solution 2

Contact Your Microsoft 365 Administrator

If you do not have access to Power Automate or believe the omission of overdue tasks is a service malfunction, escalate the issue to your IT administration.

Free Microsoft Office alternative

Manage Your Projects and Documents Efficiently with WPS Office

If you are frustrated with the limitations of web-based task managers like Microsoft Planner, consider tracking your detailed project timelines locally. WPS Office is a lightweight, full-featured suite that lets you create powerful tracking spreadsheets without requiring an expensive Microsoft 365 subscription.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install the Software: Run the downloaded installation file and follow the simple on-screen instructions to set up the suite.
3. Create a Tracking Sheet: Open WPS Spreadsheet, use one of the many free project management templates, and start tracking your tasks immediately.

Create detailed project tracking spreadsheets to manually monitor overdue tasks and deadlines.Fully compatible with Microsoft Word (.docx), Excel (.xlsx), and PowerPoint (.pptx) formats.Free, lightweight, and requires minimal system resources compared to heavy cloud applications.Features a familiar user interface, ensuring a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Planner daily emails stop showing older overdue tasks?

Microsoft Planner intentionally limits the age of tasks included in standard notifications to prevent inbox clutter. Tasks that have been overdue for several days are automatically omitted from the automated daily digest.

Do I need a premium license to use Power Automate for Planner tasks?

No. Standard Microsoft 365 business licenses typically include basic Power Automate capabilities. Querying Planner tasks and sending emails via Office 365 Outlook use standard connectors, which do not require a premium license.

Can I format the custom Power Automate email to look like a chart?

Yes. In Power Automate, you can use the 'Create HTML table' data operation action after filtering your overdue tasks. This allows you to output a clean, formatted grid of tasks inside your email body.

Office Quick Solutions