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!!
For your Table range you can specify the Sheet and Cells as so:
'ECC PP'!A1:DB15000
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional