Others

Fix Power Automate Copying Incorrect Excel Rows in SharePoint

Maira Mehtab Sep 20, 2026 869 views

Question details

The user needs to troubleshoot a Power Automate flow that copies new rows from one Excel table to another in SharePoint but results in incorrect data mapping or formatting errors.

Product: Power Automate, Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Automating data transfer between two separate Excel workbooks stored on SharePoint using Power Automate.
Observed behavior: The flow runs but copies incorrect data, adds unwanted quotation marks to the output, or fails due to an incorrect Condition action.

Before you start

Before modifying your flow, ensure that both Excel workbooks are saved in SharePoint with properly defined Table ranges, and verify that columns in both tables have corresponding data types.

Solution 1Recommended

Verify Field Mapping and Clean Up Data Inputs

Check the dynamic content mapping in your flow to resolve incorrect data placements and unwanted quotation marks.

When Power Automate passes data between Excel tables, incorrect field mapping or hidden formatting characters can cause data mismatch and unexpected quotation marks.

Edit the Flow

Open your flow in edit mode within Power Automate and locate the 'Add a row into a table' action designated for Table 2.

Review Dynamic Content

Review each field to ensure the dynamic content strictly matches the corresponding column from Table 1.

Remove Quotation Marks

Check the flow run history outputs. If quotation marks appear, edit the dynamic expression using the replace() function to strip out double quotes.

Test the Output

Remove any private or sensitive information from your tables, then test the flow manually to observe the newly mapped outputs.

Review Run History: Checking the raw JSON outputs in your flow's run history is the fastest way to identify exactly where quotation marks are being injected.

Solution 2

Reconfigure the Condition Action Logic

Identify and resolve logic failures within the flow's Condition steps to ensure rows copy accurately.

Free Microsoft Office alternative

Manage Your Spreadsheets Efficiently with WPS Office

If you are tired of complex troubleshooting in Microsoft's ecosystem, consider WPS Office. It is a lightweight, free alternative that offers full compatibility with Excel formats and provides intuitive tools for data management without the heavy overhead.

1. Download and Install: Visit the official WPS website to download the free version of WPS Office.
2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbooks directly without formatting loss.
3. Manage Data Easily: Use built-in data tools to manage, filter, and organize your spreadsheet data efficiently.

100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Lightweight software with fast installation and loading times.Familiar user interface requiring zero learning curve for Excel users.Built-in tools for advanced data processing and local automation.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate add quotation marks when copying Excel rows?

Quotation marks often appear when data is passed as a string literal instead of being parsed correctly, or if the source cell contains hidden JSON-breaking formatting. Using the replace() function in your flow expression can safely remove these.

How do I fix a failing Condition action in Power Automate?

Check your flow run history to see the exact values being compared. Ensure the dynamic content matches the expected data type (e.g., string vs. integer), and that empty cells aren't causing evaluation errors.

Can I use WPS Office to automate spreadsheet tasks?

Yes, WPS Office includes a robust macro recording feature and supports VBA in its premium versions, allowing you to automate repetitive tasks seamlessly directly within your spreadsheets.

Office Quick Solutions