Copy Excel table data to another excel table

[Anonymous]

Hi

I have already automated when user emails an excel file to BOX it bounces to Sharepoint. When this new file is created in sharepoint I want to do below:

1. Get all the data from the new excel file table (this will always be Table1, but excel file name is different) so I tried to use file indetifier and file content

2. Open Excel file 2 in another sharepoint, 

3. Delete data from excel file 2 table (table2)

4. Paste all data from the new excel file to excel file 2

I am just not sure how do this in order to apply flow. 

[GeoffRen · Accepted solution]

Look at this question. https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Excel-Rows-Bulk-Process/idc-p/864072#M24727

Basically, you can use the Delete Row and Insert Row connectors to do this, but if you have a good amount of rows, then it will be extremely slow. Otherwise, you'll have to use  Office Scripts (specifically Office Scripts with Power Automate).  

[Anonymous]

@GeoffRen thank you I didn' know I could combine script. I will try this out and come back.