Others

How to Fix Microsoft Lists Due-Date Reminder Failing for Multiple Owners

Camila Milosovich Oct 15, 2026 871 views

Question details

The user needs to resolve an issue where a due-date reminder flow in Microsoft Lists throws an error when multiple users are assigned to a single item.

How to Fix Microsoft Lists Due-Date Reminder Failing for Multiple Owners

Product: Microsoft Lists and Power Automate
Device & OS: not provided
Scenario: Setting up an automated due-date reminder flow to notify item owners in Microsoft Lists.
Observed behavior: The flow succeeds when an item has only one owner but fails when multiple owners are assigned, because the flow incorrectly processes the 'AssignedTo' field as a single object rather than an array of users.

Before you start

Ensure you have edit permissions for the Power Automate flow associated with your Microsoft List and verify whether your 'Owner' or 'AssignedTo' column allows multiple selections in the list settings.

Solution 1Recommended

Update Power Automate Flow to Handle Multiple Owners as an Array

Modify your Power Automate flow by adding an 'Apply to each' loop to correctly process the AssignedTo field as an array.

When a Person column in Microsoft Lists allows multiple selections, the data is returned as an array (a list of multiple user objects) rather than a single user object. Standard email actions will fail if they try to read an array directly. Wrapping the action in a loop resolves this issue.

Edit the Flow

Open Power Automate, locate your due-date reminder flow under 'My flows', and click 'Edit'.

Add an Apply to Each Loop

In the flow editor, locate the action where the 'AssignedTo' or 'Owner' field is being referenced. Click 'Add an action' and search for the 'Apply to each' control.

Select the Array Output

Click inside the 'Select an output from previous steps' box in the 'Apply to each' action. From the dynamic content menu, select your 'AssignedTo' or 'Owner' array.

Move the Notification Action

Drag your 'Send an email' or notification action inside the 'Apply to each' loop. In the 'To' field of the email, select the 'Email' property from the dynamic content.

Save and Test

Save your flow. Run a manual test using a list item that has multiple owners assigned to confirm the loop works without errors.

Update Power Automate Flow to Handle Multiple Owners as an Array

Alternative: Single Email for All Owners: If you prefer to send one single email to all owners instead of individual emails per owner, use the 'Select' and 'Join' data operations to combine the email addresses into a semicolon-separated string before the email action.

Solution 2

Verify List Column Settings for Multiple Selections

Check the Microsoft Lists column configuration to ensure the field is properly set up to store multiple user accounts without causing data conflicts.

Free Microsoft Office alternative

Manage Data and Tasks Effortlessly with WPS Office

If you encounter frequent complications with complex automated workflows, consider simplifying your task management. WPS Office provides a robust, lightweight alternative to Microsoft Office for managing tabular data, tracking tasks, and handling everyday office work with seamless compatibility.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open WPS Spreadsheet: Launch the application and open WPS Spreadsheet to create a new task tracker or open an existing Excel workbook.
3. Organize Task Owners: Use Data Validation tools and built-in templates to easily track due dates, task statuses, and multiple assignees.

100% compatible with Microsoft Excel (.xlsx) files for seamless spreadsheet trackingLightweight design ensures fast loading of large datasets and task listsAbundant free built-in templates for project management, Gantt charts, and task trackingFree to use with a familiar, intuitive tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate throw an error when multiple users are in a Person column?

When multiple users are selected in a Microsoft List, the Person column outputs an array (a list) of user objects. If your flow is programmed to handle a single text string (like an email address), it will fail. You must use an 'Apply to each' loop or a data operation to extract the emails from the array.

Can I send one reminder email to all owners instead of individual emails?

Yes. You can avoid sending separate emails by using the 'Select' action to extract only the email addresses from the AssignedTo array, followed by a 'Join' action using a semicolon (;) as the delimiter. You then insert the output of the Join action into the 'To' field of your email.

How do I fix the 'Property Email cannot be evaluated' error in Power Automate?

This error occurs when the flow tries to retrieve an 'Email' property from an empty field or a mismatched object structure. Ensure that the 'AssignedTo' field is not blank before sending the email by adding a 'Condition' action (e.g., 'AssignedTo is not equal to null') before your loop.

Office Quick Solutions