Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Copy file excel worksheet to another excel

(1) ShareShare
ReportReport
Posted on by 78

How do i copy file excel worksheet to another excel file ??

e.g i have 2 file excel, each contains 1 worksheet. excel_1.xlsx got sheet_1 and excel_2.xlsx got sheet_2.
how to copy the content of sheet_1 from excel_1 and sheet_2 from excel_2 to excel_3.xlsx where excel_3 is a blank excel. (content without any table just text and number)

Can i achieve this with microsoft flow ?


  • Suggested answer
    mathiaskjeldsen Profile Picture
    222 on at
    Copy file excel worksheet to another excel
    Hey
     
    Should be doable. You can use the send keys actions to send ALT E + M, to get the copy worksheet up. Then from there send a few more keys to click create copy and choose the new workbook. If you don't know how to use Send Keys functions and work with Excel using Power Automate, I covered it in this video: https://youtu.be/qdcUYE3swxU
     
    Let me know if you still got issues. 
     
    Best regards
    Mathias Kjeldsen
     
    ---
    If this has helped solve your problem, please mark it as Solution. 

    Connect with me on social platforms by using the links below.
    YouTube: https://www.youtube.com/@matkjeldsen 
    LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/
     
  • v-bacao-msft Profile Picture
    on at
    Re: Copy file excel worksheet to another excel

    Hi @Trinaintynine ,

     

    As far as I know, Excel-related actions can get the properties of worksheet, but they don't have the ability to get the content contained in the worksheet.

    If you want such a feature to be supported by MS Flow, you could post your idea in the Flow Ideas forum, so it might be considered for future releases.

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    Best Regards,

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

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >