Others

How to Send Microsoft Lists Due-Date Reminders to Assigned Users

Partner Editor Sep 25, 2026 868 views

Question details

The user needs to set up automated email reminders for items in a Microsoft List one day before and on the due date.

How to Send Microsoft Lists Due-Date Reminders to Assigned Users

Product: Microsoft Lists / Power Automate
Device & OS: not provided
Scenario: Automating due-date notifications for assigned team members based on list data.
Observed behavior: A workflow must be configured to retrieve list items dynamically and send scheduled emails using the Assigned To and Due Date columns.

Before you start

Ensure you have active Microsoft 365 credentials with access to Power Automate and edit permissions for the target Microsoft List.

Solution 1Recommended

Create a Scheduled Power Automate Flow for Email Reminders

Set up a daily scheduled workflow to check due dates and email assigned users.

By using Power Automate, you can schedule a background flow that runs every day, checks your Microsoft List for upcoming due dates, and automatically notifies the assigned personnel.

Create a Scheduled Flow

Log into Power Automate, select 'Create', and choose 'Scheduled cloud flow'. Set the flow to run daily at your preferred time.

Retrieve List Items

Add a SharePoint 'Get items' action. Connect it to your Site Address and select your target Microsoft List.

Filter by Due Date

In the 'Get items' advanced options, configure an OData filter query to retrieve only the items where the 'Due Date' equals today or tomorrow.

Configure the Email Action

Add a 'Send an email (V2)' action. In the 'To' field, use the dynamic content menu to select the 'Assigned To Email' field.

Test the Workflow

Save your flow and run a manual test. Review the run history to confirm the emails are triggered and sent successfully.

Create a Scheduled Power Automate Flow for Email Reminders

Dynamic Content Loop: If you select 'Assigned To Email' and the flow automatically wraps your action in an 'Apply to each' loop, this is normal behavior for handling lists of items.

Solution 2

Format Email Addresses for Multiple Assigned Users

Use an expression to handle multiple recipients if your Person column allows multiple selections.

Free Microsoft Office alternative

Try WPS Office for Efficient Project Tracking

While Microsoft Lists handles complex automation, WPS Office provides a free, lightweight suite that includes powerful Spreadsheet tools for tracking project deadlines, milestones, and assignments offline or via the cloud.

Fully compatible with Microsoft Excel (.xlsx) formats.Free and lightweight alternative to Microsoft 365.Easily track due dates and assigned tasks with familiar spreadsheet features.Cross-platform support for seamless productivity anywhere.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select the Person column in the email 'To' field?

Ensure your column in Microsoft Lists is strictly defined as a 'Person or Group' column type. If it is configured as a standard text column, Power Automate cannot automatically extract the email addresses.

How do I trigger an email exactly one day before the due date?

You can use a date expression in Power Automate, such as addDays(utcNow(), 1, 'yyyy-MM-dd'), to calculate tomorrow's date. Compare this dynamically generated date against the Due Date column in your 'Get items' filter query.

Can I customize the automated email reminder's content?

Yes. In the 'Send an email (V2)' action, you can use dynamic content from your Microsoft List, such as item titles, descriptions, and direct URLs, to create a personalized and informative HTML email body.

Office Quick Solutions