Answered

copy excel rows from one excel file to another excel file

Like (0) Share

Report

Posted on 20 Aug 2019 11:41:53 by surfer1978

I am looking to find a way when a user updates an excel spreadsheet row, that row is updated on an identical spreadsheet, both which are stored in different document libraries in SharePoint, the solutions I have found include the 'get rows' action which is no longer available. It is a pretty simple proof of concept, I did try creating a table but you cannot overlay a table with another table, it errors out.

Any assistance would be appreciated.

Thanks!

All responses (5)

Answers (1)

jdillonw 2 on 29 Jun 2022 at 21:05:29

Like (0)

Report

Re: copy excel rows from one excel file to another excel file

Hi, I created a flow to copy rows from one excel sheet (in SP) to another in the same folder in SP.
Excel file 1 had 3 rows and the excel file 2 had 1 row. Same headers. So I skipped 1 in 'list rows present in a table' command.
However the flow took over 30 mins to complete, and the data was not copied.
Can the function do the below?
Get rows present in table (from excel file 1)
for each
add a row to table (to excel file 2)?
IndigoFaux 52 on 10 May 2022 at 03:30:04

Like (0)

Report

Re: copy excel rows from one excel file to another excel file

Did you ever find a solution to this? I am having the same issue with only seeing value or body.
ericwychan 63 on 14 Jul 2021 at 10:55:46

Like (0)

Report

Re: copy excel rows from one excel file to another excel file

It seems i only have two options, I tried both but error finally.
ericwychan 63 on 14 Jul 2021 at 10:54:16

Like (0)

Report

Re: copy excel rows from one excel file to another excel file

@v-alzhan-msft
Hi all.
I failed in the last step, to create all the rows in the excel file2 table.
I am moving data from table "Submission" to table "Summary"
I have listed the needed rows from "table "Submission".
However when I add rows to table "Summary"
I don't know how should I input for "Row" inside "Add a row into a table (Summary)"
Please advice, thanks a lot.
Verified answer

v-alzhan-msft on 21 Aug 2019 at 06:51:39

Like (2)

Report

Re: copy excel rows from one excel file to another excel file

Hi @surfer1978 ,

Where are the both files be saved in?

Microsoft flow could check if the excel file1 is modified, however it couldn't know which row is updated.

I suggest that you could create a flow to do the steps below:

1. The flow would trigger when the excel file1 is modified.

2. Get all rows from the another excel file2 table and delete all the rows.

3. Get all rows from the excel file1 table, and create all the rows in the excel file2 table.

And if you save the file in the onedrive for business, the flow should as below:

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.