web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Copy Excel worksheet f...
Power Automate - Building Flows
Answered

Copy Excel worksheet from SharePoint to another Excel file

(0) ShareShare
ReportReport
Posted on by angelrodriguez 52

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?

I have the same question (0)
  • Verified answer
    Jcook Profile Picture
    Jcook 7,779 Most Valuable Professional on at
    Re: Copy Excel worksheet from SharePoint to another Excel file

    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

     

     

  • angelrodriguez Profile Picture
    angelrodriguez 52 on at
    Re: Copy Excel worksheet from SharePoint to another Excel file

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans