How to Automatically Update One Excel Workbook from Another with Power Automate
Question details
The user wants to automatically synchronize data from one SharePoint-hosted Excel workbook into another workbook while keeping manually entered notes in the destination table unchanged.

- Product
- Microsoft Power Automate, Excel for the web, and SharePoint Online
- Device & OS
- not provided
- Scenario
- The user has a source workbook that receives data changes and a destination workbook that also contains manual notes. They need the synchronized columns to update automatically without overwriting the notes column.
- Observed behavior
- The goal state is for Power Automate to update only the mapped synchronized columns in matching destination rows and leave all manually entered notes intact.
Store both workbooks in SharePoint and format the relevant data ranges as Excel tables with the same column names and a shared unique ID column. Confirm that the Power Automate connection account has edit access to both workbooks before creating the flow.
Create a Power Automate flow that updates matching rows without changing the notes column
Use this when you want changes in a source SharePoint workbook to flow into a destination workbook automatically while preserving manually entered notes.
The flow can be triggered when the source file is modified, or it can run on a Recurrence schedule. The key is to use a unique identifier to locate the matching destination row and to update only the columns that should be synchronized.
Upload the source and destination workbooks to SharePoint Online. Open each file in Excel for the web, select the data range, and choose Insert > Table to create a named Excel table with headers.
Sign in to Power Automate, select Create > Automated cloud flow, and choose the SharePoint trigger "When a file is created or modified (properties only)" or "When a file is modified". Set the site address and library to the source workbook location.
Add the Excel Online (Business) action "List rows present in a table". Select the source workbook and table, and use the Filter Query field if you want to limit the rows that are processed.
Add an "Apply to each" action around the source rows. Inside it, add a second "List rows present in a table" action for the destination workbook, and use a Filter Query that matches the destination ID column to the source row's unique ID dynamic content.
Inside the apply to each, add the Excel Online (Business) action "Update a row". Map the key column to the unique ID, and map only the data columns that need to be synchronized. Do not map the notes column so its current value remains unchanged.
Select Save, then select Test and modify a source row. Verify that the destination row receives the updated values and the notes column still contains its original manual entry.

Use WPS Office as a Free Excel-Compatible Alternative for Workbook Editing
When the Power Automate and SharePoint workflow is not available or is more automation than you need, WPS Office is a free, lightweight Office alternative. It opens .xlsx workbooks, preserves familiar formatting and formulas, and provides a Microsoft Office-like ribbon interface for seamless editing and migration.

Frequently Asked Questions
Do both Excel workbooks have to be stored in SharePoint for Power Automate to update them?
The standard Excel Online (Business) Power Automate actions require the workbooks to be stored in SharePoint or OneDrive for Business. The account that runs the flow also needs at least edit access to both files.
How do I stop Power Automate from overwriting the notes column?
In the "Update a row" action, do not map the notes column. Map only the key column and the synchronized data columns, and Power Automate will leave the existing notes value untouched.
Can I run this update on a schedule instead of only when the source file changes?
Yes. Create a flow with the Recurrence trigger, then add the same "List rows present in a table" and "Update a row" actions. A scheduled flow is useful for daily or hourly synchronization.
What should I do if the matching destination row is not found?
Verify that the unique ID values match exactly and are stored in the same format in both tables. If the row should be added, add a separate "Add a row" action; otherwise configure the flow to skip or notify you.
Does WPS Office include Power Automate?
WPS Office does not include Microsoft Power Automate. However, you can open and manually edit Excel workbooks in WPS Office, including .xlsx files downloaded from SharePoint, while keeping the existing workbook structure intact.




