MS Flow to import from Excel from Data Range and not just tables

[Anonymous]

When trying to get rows from Excel you currently can only use TABLES as the objects to import from. I would like it when you can refer to an Excel workbook but reference a data range (dynamic ideally) as often the data being picked up is from 3rd parties that do not place the data into TABLES.

[Anonymous]

Awesome idea!!! Need this!

[Anonymous]

Totally Agree !

[YaminK]

#Meetoo

[katonage]

duplicate - same problem, vote both ideas

https://powerusers.microsoft.com/t5/Flow-Ideas/Format-Excel-Sheet-as-a-Table/idc-p/122060#M7816

[katonage]

Excel Online (Business) / Create table 

Creates a new table in the Excel workbook. Seems doing the job.

[abrae005]

@katonage - I don't think there's a way to create a table using a dynamic range. If there was, then that'd be awesome.

[katonage]

I've just tried the above mentioned connector and it works. Maybe it has not yet been rolled out for everyone.

[Tqphan87]

You can create a new BLANK table using that action, but the ask is to read/access an existing workbook with data already there and then create a table based on the rows/columns present. 

Right now, you have to go into your workbook and create a table from the data before Flow/Power Automate will even register it. I'm surprise this idea hasn't been more popular. 

[FredT]

Agreed. Often I have to manipulate Excel outputs from other systems that are not in a table. Dynamic range selection would be awesome. 

Also need to be able to process CSVs......

[rusgesig]

pleaaase, if you won't let us read sheets at least us run .py files