Skip to main content

Notifications

Community site session details

Community site session details

Session Id : G1ga9X//JX7v7Ls6jk06RA
Power Automate - Building Flows
Suggested answer

Copy excel sheet to another workbook

Like (0) ShareShare
ReportReport
Posted on 18 Jan 2024 21:37:38 by 32

Hi,

 

Is it possible to just copy one Excel sheet to another workbook?

I have built some basic workflows in the online version, but this is my first time with Power Automate Desktop.

Why am I thinking about this option? because I need the whole sheet, not just a selection of cells or a table.

 

Any ideas? Thank you!!!

  • Suggested answer
    takolota1 Profile Picture
    4,859 Super User 2025 Season 1 on 23 Apr 2025 at 00:34:11
    Copy excel sheet to another workbook
    If you have access to Azure there are ways to do this with Azure Functions like in this template: https://community.powerplatform.com/galleries/gallery-posts/?postid=a5255ced-dc08-f011-bae3-6045bdf03fcb
  • MW-21041403-0 Profile Picture
    32 on 21 Apr 2025 at 14:49:27
    Copy excel sheet to another workbook
    Hey there!
     
    I'm new to power automate and have been having difficulty getting an excel sheet to copy to another workbook in the online version. Would you mind sharing your workflows? 
     
    Thank you!
  • Verified answer
    v-xiaochen-msft Profile Picture
    on 19 Jan 2024 at 01:47:25
    Re: Copy excel sheet to another workbook

    Hi @JeanPaul ,

     

    Please try this

    vxiaochenmsft_0-1705628821495.png

    Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Administrator\\Desktop\\Test1.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
    Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Administrator\\Desktop\\Test2.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance2
    Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
    Excel.CopyCellsFromExcel.CopyAllCells Instance: ExcelInstance
    Excel.AddWorksheet Instance: ExcelInstance2 Name: $'''tempSheet''' WorksheetPosition: Excel.WorksheetPosition.First
    Excel.PasteCellsToExcel.Paste Instance: ExcelInstance2
    Excel.CloseExcel.Close Instance: ExcelInstance
    Excel.CloseExcel.CloseAndSave Instance: ExcelInstance2
    

     

    Best Regards,

    Wearsky

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 45

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 25 Super User 2025 Season 1

#3
Chriddle Profile Picture

Chriddle 21 Super User 2025 Season 1

Overall leaderboard
Loading started