Create Table (Excel) For Specific Sheet in Excel File

Like (0) Share

Report

Posted on 15 Nov 2022 19:21:24 by Community Power Pla...

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

All responses (1)

Answers (1)

Verified answer

grantjenkins 11,059 Moderator on 16 Nov 2022 at 02:07:05

Like (2)

Report
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