SharePoint Document Issues

How to Sync SharePoint Library Metadata with a List Using Power Automate

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to automatically synchronize metadata changes from a SharePoint document library to a corresponding SharePoint list item.

Product: SharePoint and Power Automate
Device & OS: not provided
Scenario: Automating data entry by linking document library metadata properties to a separate list within SharePoint.
Observed behavior: The user wants a setup where any modification to a file's metadata in the library automatically finds and updates the matching fields in a separate list item.

Before you start

Ensure you have Edit permissions for both the source SharePoint document library and the target SharePoint list, as well as access to create automated cloud flows in Power Automate.

Solution 1Recommended

Create a Custom Power Automate Flow for Metadata Synchronization

Use an automated cloud flow triggered by file property changes to query the target list and update the corresponding item with the new metadata.

Since SharePoint does not natively synchronize library metadata with separate lists out-of-the-box, a custom Power Automate flow is required. This approach uses standard SharePoint connectors to detect changes, locate the corresponding list record, and overwrite its fields with the updated file properties.

Create the Automated Cloud Flow

Log into Power Automate, click 'Create' on the left sidebar, and select 'Automated cloud flow'. Give your flow a descriptive name.

Configure the Trigger

Search for and select the SharePoint trigger 'When a file is created or modified (properties only)'. Connect it to your site address and select your source document library.

Retrieve the Matching List Item

Add a new step and choose the SharePoint 'Get items' action. Select your target list, and in the advanced options, configure an OData Filter Query (e.g., Title eq 'triggerBody()?['Title']') to find the exact list item matching the library file's unique identifier.

Update the List Item Fields

Add the SharePoint 'Update item' action. Power Automate will automatically place this inside an 'Apply to each' loop. Map the dynamic content from the library trigger to the corresponding fields in the list to complete the synchronization.

Complex Implementations: For detailed implementation guidance on complex field types (like Person or Choice columns), ask in the Power Automate section of the Power Platform Community.

Free Microsoft Office alternative

Enhance Your Document Editing Workflow with WPS Office

While Power Automate handles your complex SharePoint metadata synchronizations, WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for creating and editing the actual documents stored within your libraries.

1. Download WPS Office: Get the free installation package directly from the official WPS website.
2. Open Synced Documents: Access your SharePoint library files locally via OneDrive sync and open them instantly in WPS Office.
3. Edit and Save Seamlessly: Edit your documents and save them back in standard Microsoft formats to trigger your Power Automate flows.

Fully compatible with Microsoft Office formats (DOCX, XLSX, PPTX) for seamless SharePoint file editing.Lightweight application that opens large documents instantly without system lag.Familiar tabbed user interface ensuring a zero-learning-curve migration.Easily manage document properties and metadata prior to uploading files to SharePoint.

microsoft office alternative - wps office

Frequently Asked Questions

Can Power Automate sync metadata from a SharePoint list back to a document library?

Yes, you can create a reverse flow using the 'When an item is created or modified' trigger on the list, and use the 'Update file properties' action to sync data back to the document library. Ensure you add conditional logic to prevent infinite trigger loops.

How do I handle empty metadata fields during synchronization?

You can use Power Automate expressions like coalesce() or add a 'Condition' block to check if a metadata field is empty before attempting to update the corresponding list item, which prevents accidental data overwrites.

Does this Power Automate flow require a premium license for SharePoint integration?

No, the standard SharePoint connectors required to sync document libraries and lists are included in basic Microsoft 365 licensing and do not require a premium Power Automate subscription.

What is the most reliable way to match a library file to a list item?

It is highly recommended to use a unique identifier column, such as a custom Project ID or Employee ID, rather than the file name. File names are subject to change and can break the OData filter query during synchronization.

Document & File Issues