How to Send Unplanned Microsoft To Do Tasks by Email Daily
Question details
The user wants to set up a daily automated email digest containing their unplanned tasks from Microsoft To Do.

- 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.
Ensure you have an active Microsoft 365 subscription with access to Power Automate, Microsoft To Do, and Outlook.
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.
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'.
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.
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).
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.
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.

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. Download the software: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install and launch: Run the downloaded installer and follow the quick setup instructions to install the suite.
- 3. Manage your tasks: Open WPS Spreadsheet to easily track your daily to-dos, unassigned tasks, and project timelines.

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.




