Notifications
Announcements
Hello guys!
I'm creating a flow and I want it to be able to copy an Excel Sheet and paste it in the same Excel File. Do you know how can I do this?
Thank you so much!
Have a lovely weekend!
You can use "Set active Excel worksheet" -action to set the worksheet you want to copy.Then use "Copy cells from Excel worksheet" -action with Copy mode: "All available values from worksheet".Then again "Set active Excel worksheet" -action to choose the worksheet you want to paste the values to.Lastly use "Paste cells to Excel worksheet" -action to paste it where ever cells you want to.
Hey, i forgot to mention that i use the online app, not the desktop one. Do you know how can i do that there?
Is all the values inside a table in the excel? If the data is inside tables then use List rows present in a table. Then I think you need to loop the table and add the rows one by one in the other sheet.If the data is not in a table its bit more difficult I think. Then you might have to use Run script and figure out a script that does that (maybe try googling one)
Because I think Power Automate Clouds Excel actions you usually need the data to be in a table inside the Excel worksheet.I recommend starting this thread (or asking mods to move this thread) to Power Automate Building Flows section which is meant for Power Automate stuff. This forum is for the desktop version.Building flows: https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 503 Super User 2025 Season 2
Tomac 321 Moderator
abm abm 237 Most Valuable Professional
