Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Create Table (Excel) For Specific Sheet in Excel File

Like (0) ShareShare
ReportReport
Posted on 15 Nov 2022 19:21:24 by

Hello all.

 

I am using the Create Table action for Excel in a Power Automate flow. This action can be seen in the image below:

createTableError1.PNG

 

However, I want to ensure that when creating this table, it will create the table for the specific sheet within that excel file where the data... as you can see below, the sheet I need this Create Table action to run on is the ECC PP sheet... 

createTableError2.PNG

 

Is this an option? If so... how do you select the specific sheet in the create table action? Appreciate the help!!

  • Verified answer
    grantjenkins Profile Picture
    11,059 Super User 2025 Season 1 on 16 Nov 2022 at 02:07:05
    Re: Create Table (Excel) For Specific Sheet in Excel File

    For your Table range you can specify the Sheet and Cells as so:

     

    'ECC PP'!A1:DB15000

     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 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…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 196 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 171 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 165

Overall leaderboard
Loading started
Loading started