SharePoint Document Issues

How to Automatically Update One Excel Workbook from Another with Power Automate

Steven ParkerSteven Parker Nov 13, 2026 870 views

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.

How to Automatically Update One Excel Workbook from Another with Power Automate
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.
Before you start

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.

Solution 1Recommended

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.

1
Store both workbooks in SharePoint and format data as tables

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.

2
Create an automated cloud flow in Power Automate

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.

3
List rows from the source table

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.

4
Find the matching destination row by unique ID

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.

5
Update only the synchronized columns

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.

6
Save and test the flow

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.

Create a Power Automate flow that updates matching rows without changing the notes column
Permissions and table setup: If the flow cannot find or update the destination file, check that both workbooks are in SharePoint or OneDrive for Business, the tables have a reliable key column, and the Power Automate account has edit permission to both files.
Free Microsoft Office alternative

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.

Opens and edits .xlsx Excel workbooks without conversion, maintaining Microsoft Excel format compatibility.Familiar ribbon UI makes it easy to switch from Microsoft Excel.Free and lightweight installation with no subscription required.Lets you manually update and review shared workbook data even when Power Automate is not available.Supports common spreadsheet formulas, formatting, and charting for everyday Excel tasks.
microsoft office alternative - wps office

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.