Renaming Default Worksheet in Excel Created via Power Automate

Like (0) Share

Report

Posted on 28 Nov 2023 09:45:17 by hitakshi

162

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

All responses (2)

Answers (0)

Mergi 2 on 25 Jun 2024 at 14:43:50

Like (0)

Report

Re: Renaming Default Worksheet in Excel Created via Power Automate

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!
Rhiassuring 8,688 Super User 2025 Season 1 on 28 Nov 2023 at 09:52:55

Like (1)

Report

Re: Renaming Default Worksheet in Excel Created via Power Automate

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