Answered

Copy Excel worksheet from SharePoint to another Excel file

(0) Share

Report

Posted on by angelrodriguez

I have two Excel workbooks in SharePoint where I'm trying to copy an entire worksheet (Worksheet 2) from an Excel file named "MasterTest" to another worksheet of the same name, with the same columns named "MasterCopy".

I've built a Flow to Get worksheets and an Apply to each loop to Get a row, but this continues to fail, stating there's no table found with the name Worksheet 2. These have not been converted to tables. My question is, can a SharePoint Excel worksheet from one Excel file be copied to another worksheet from another Excel file in the same folder?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @angelrodriguez
Do the excel files you speak of have tables defined in the sheets?

Excel connector in Flow requires tables to be defined.
Could you also share a picture of your flow

Thanks

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
angelrodriguez 52 on at

Like (0)

Report
Copy link

Link copied!

Hi Josh,

I did see that I needed to convert them to tables. I did and was able to copy the worksheet. Now, I'm stuck trying to iterate through a list of subfolders to get to each Excel file. I will need to post a new discussion if I can't figure it out.

Thanks.

Was this reply helpful? Yes No