Hello community,
I am working on a Power Automate flow where I create an Excel file and a table within it. The process automatically generates a worksheet named "Sheet1," but I would like to customize this sheet name.
Could someone guide me on how to rename the default worksheet created by Power Automate in Excel to a name of my choice? Any insights or step-by-step instructions would be greatly appreciated.
Thank you!
Hitakshi
@PowerAutomate @powerautomater1 @yipowerautomate @powerautomate88 @powerautomate17 @automate @AutoMatey @automate3 @HAutomate @IAutomate @Anonymous @v-yetonggu-msft
Hi, I create excel File following the steps in this video
Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel (youtube.com)
and to customize the Sheet name, I rename the sheet1 in the empty Excel file that is used as a template.
It works fine!
There's no action that can directly do it, you'd need to do it custom through an Office Script.
Here's an example of one that has been posted:
https://powerusers.microsoft.com/t5/General-Power-Automate/Can-we-rename-an-excel-sheet-tab-using-Power-automate/m-p/1948782/highlight/true#M113408
Pstork1
20
Most Valuable Professional
rpersad
16
Michael E. Gernaey
12
Super User 2025 Season 1