Create Table (Excel) For Specific Sheet in Excel File

(0) Share

Report

Posted on by Community Power Pla... 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:

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

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

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
Copy link

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

'ECC PP'!A1:DB15000

Was this reply helpful? Yes No