Skip to main content

Notifications

Community site session details

Community site session details

Session Id : alcd1BMs9a5JLTdTwfm8YF
Power Automate - General Discussion
Unanswered

Renaming Default Worksheet in Excel Created via Power Automate

Like (0) ShareShare
ReportReport
Posted on 28 Nov 2023 09:45:17 by 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.

hitakshi_1-1701164257526.png

 

Thank you!

Hitakshi

 

@PowerAutomate @powerautomater1 @yipowerautomate @powerautomate88 @powerautomate17 @automate @AutoMatey @automate3 @HAutomate @IAutomate @Anonymous @v-yetonggu-msft 

 

  • Mergi Profile Picture
    2 on 25 Jun 2024 at 14:43:50
    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 Profile Picture
    8,688 Super User 2025 Season 1 on 28 Nov 2023 at 09:52:55
    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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

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 - General Discussion

#1
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#2
rpersad Profile Picture

rpersad 16

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 12 Super User 2025 Season 1

Overall leaderboard
Loading started