Others

How to Synchronize Two Microsoft Lists Using Power Automate

Maira Mehtab Sep 22, 2026 871 views

Question details

The user needs to mirror and automatically update specific columns (such as date or choice columns) from one Microsoft List to another list created by a different user within the same organization.

Product: Microsoft Lists
Device & OS: not provided
Scenario: Maintaining synchronized data across two separate Microsoft Lists to ensure that any changes in the source list are immediately reflected in the destination list.
Observed behavior: Microsoft Lists currently lacks a built-in real-time synchronization feature to automatically mirror items between two separate lists.

Before you start

Ensure that the Microsoft account you are using to create the Power Automate flow has Edit permissions for both the source Microsoft List and the destination Microsoft List.

Solution 1Recommended

Create a Power Automate Flow to Sync List Items

Since Microsoft Lists does not offer native list-to-list synchronization, you can build an automated cloud flow in Power Automate to push updates from the source list to the destination list.

Power Automate bridges the gap between disconnected Microsoft Lists. By setting up a flow triggered by modifications, you can ensure data consistency across your organization without manual data entry.

Create a new automated cloud flow

Log into Microsoft Power Automate, navigate to 'Create' on the left sidebar, and select 'Automated cloud flow'. Name your flow to easily identify it later.

Configure the trigger for the source list

Search for SharePoint triggers and select 'When an item is created or modified'. Enter the Site Address and select the List Name for your source list (List A).

Add the update action for the destination list

Click 'New step', search for SharePoint actions, and choose 'Update item'. Input the Site Address and List Name for your destination list (List B).

Map the dynamic content

In the 'Update item' action, map the required fields (like your Date or Choice columns) using the dynamic content generated from the trigger in List A. You will also need to specify the ID of the corresponding item in List B to update.

Save and test the flow

Click 'Save' at the top right. Go to your source Microsoft List, modify an item, and verify that the corresponding item in the destination list updates automatically.

Service Account Recommendation: Because the flow relies on the creator's account connections, it is best practice to use a dedicated service account rather than a personal user account to prevent flow failures if a user leaves the organization.

Free Microsoft Office alternative

Looking for a Lightweight Alternative for Document Management?

While Microsoft Lists handles specialized data tracking, WPS Office is the perfect free alternative for your daily document, spreadsheet, and presentation needs. It offers a lightweight interface, seamless migration, and high compatibility with Microsoft formats.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight and fast installation, saving your computer's system resources.Built-in PDF editing and conversion tools.Familiar tabbed interface that makes switching from Microsoft Office effortless.

Frequently Asked Questions

Can I synchronize two Microsoft Lists natively without Power Automate?

No, Microsoft Lists does not currently provide a built-in feature to natively mirror or synchronize items between two different lists in real-time. Power Automate is the standard Microsoft workaround for this requirement.

Why did my Power Automate list sync flow stop working?

Flows typically fail if the account that created the connections loses permissions to either list, if the account password expires, or if columns in the lists were deleted or renamed. Check the flow's run history in Power Automate to identify the specific error.

Can I sync lists that belong to different Microsoft 365 organizations?

Syncing lists across different tenants is significantly more complex. It requires external sharing configurations, guest access, or premium HTTP connectors in Power Automate, as standard SharePoint connectors default to the home tenant.

Office Quick Solutions