web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create Table (Excel) F...
Power Automate
Answered

Create Table (Excel) For Specific Sheet in Excel File

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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!!

Categories:
I have the same question (0)
  • Verified answer
    grantjenkins Profile Picture
    11,063 Moderator on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 557

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 264 Super User 2026 Season 1

Last 30 days Overall leaderboard