Others

How to Send Unplanned Microsoft To Do Tasks by Email Daily

Emma BrownEmma Brown Oct 22, 2026 873 views

Question details

The user wants to set up a daily automated email digest containing their unplanned tasks from Microsoft To Do.

How to Send Unplanned Microsoft To Do Tasks by Email Daily
Product
Power Automate
Device & OS
not provided
Scenario
Automating daily task management workflows and email reporting.
Observed behavior
The user needs a structured method to filter tasks without a due date in Power Automate and email the compiled list automatically each morning.
Before you start

Ensure you have an active Microsoft 365 subscription with access to Power Automate, Microsoft To Do, and Outlook.

Solution 1Recommended

Create a Scheduled Cloud Flow in Power Automate

Set up a daily scheduled trigger to fetch your Microsoft To Do tasks, filter out the planned ones, and email the remaining unplanned tasks.

Power Automate allows you to connect Microsoft To Do with Outlook seamlessly. By scheduling a daily flow, you can stay on top of tasks that haven't been assigned a specific due date yet.

1
Set up the scheduled trigger

Log in to Power Automate, click on 'Create', and select 'Scheduled cloud flow'. Name your flow, set the starting date and time, and configure it to repeat every '1 Day'.

2
Retrieve Microsoft To Do tasks

Click 'New step', search for 'Microsoft To Do', and choose the 'List tasks' action. Select the specific To Do list you want to monitor from the drop-down menu.

3
Filter for unplanned tasks

Add a 'Filter array' action. Set the 'From' field to the dynamic content 'value' from the previous step. Configure the condition to check where 'Due Date' is equal to 'null' (leave the value field completely empty or use the null expression).

4
Format the task list

Add a 'Create HTML table' action. Use the 'Body' output from your Filter array step. This will format your unassigned tasks into a clean, readable table structure.

5
Configure the automated email

Add the 'Send an email (V2)' action under Office 365 Outlook. Enter your email address in the 'To' field, add a subject like 'Daily Unplanned Tasks', and insert the output from the HTML table into the email body. Save and test your flow.

Create a Scheduled Cloud Flow in Power Automate
Community Support: For complex OData filter queries or advanced flow design, consult the Microsoft Power Automate Community forums where specialists provide detailed guidance.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Power Automate manages your task alerts, WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for all your document, spreadsheet, and presentation needs.

  1. 1. Download the software: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install and launch: Run the downloaded installer and follow the quick setup instructions to install the suite.
  3. 3. Manage your tasks: Open WPS Spreadsheet to easily track your daily to-dos, unassigned tasks, and project timelines.
Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Create and manage complex daily task trackers using built-in spreadsheet templates.Lightweight installation that runs smoothly on almost any device.Familiar user interface ensuring a seamless migration with zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Can I send the unplanned tasks to Microsoft Teams instead of Outlook?

Yes, instead of adding the Outlook 'Send an email' action at the end of your flow, search for Microsoft Teams and select the 'Post message in a chat or channel' action to deliver your task list there.

Why is my 'Filter array' step failing to catch unplanned tasks?

Ensure that the condition is strictly checking for empty due dates. Sometimes, setting the condition to check if 'Due Date' is equal to the expression 'null' (typed in the Expression tab, not as plain text) resolves this issue.

Does Power Automate allow me to pull tasks from multiple To Do lists at once?

The 'List tasks' action typically targets one specific list at a time. To pull from multiple lists, you will need to add multiple 'List tasks' actions and combine their outputs using an 'Append to array variable' action before filtering.