Showing results for 
Search instead for 
Did you mean: 
New Member

Copy Table from Excel attachment and paste in existing excel file



I have a SharePoint list where new items are created with mandatory attached excel file.

So, I want to copy a table from a predefined Tab "Summary2" in the attached excel file to an existing excel file (single sheet) accumulating the data - meaning every Paste should be below the last pasted range.


Unfortunately I am not really sure which functions of the FLOW to use in order to deal with the Copy and paste actions.


In VBA it normally looks like the below - In case it is helping at all:


shSource.Cells(Rows.Count, "A").End(xlUp).Row
lRow = lRow + 1
LastRow = shTarget.Cells(Rows.Count, "A").End(xlUp).Row
LastRow = LastRow + 1
shSource.Range("A3:C" & lRow).Copy
shTarget.Range("A" & LastRow).PasteSpecial Paste:=xlPasteValues


Thank you in advance




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,902)