cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
surfer1978
Helper I
Helper I

copy excel rows from one excel file to another excel file

Hi


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.

 

excel.PNG

 

Any assistance would be appreciated.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

 

View solution in original post

3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

 

View solution in original post

ericwychan
Helper II
Helper II

@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.

 

ericwychan_0-1626259951886.png

 

ericwychan
Helper II
Helper II

It seems i only have two options, I tried both but error finally.

 

ericwychan_1-1626260110442.png

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,196)