cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

Status: New
Comments
Anonymous
Not applicable

Awesome idea!!! Need this!

New Member

Totally Agree !

 

New Member

#Meetoo

Advocate V
Advocate V

Excel Online (Business) / Create table 

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

Advocate II
@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.
Advocate V
I've just tried the above mentioned connector and it works. Maybe it has not yet been rolled out for everyone.
Frequent Visitor

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.