cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GeorgiH
New Member

Copy Table from Excel attachment and paste in existing excel file

Hello

 

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

 

 

0 REPLIES 0

Helpful resources

Announcements
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)