Format Excel Sheet as a Table

[SamPo]

I have excel files that are automatically generated from multiple systems as reports. I would like to use this data in multiple daily flows.

Each file contains a single sheet with records of data. The first row contains column headers and consecutive rows contain data records. As the reports are generated by a system, the data is not formatted as a table in excel and therefore I cannot use the 'Get Rows' action in flow.

I would like an action to format an excel sheet into a table. It should select all rows that contain data and mark the first row as column headers (in the same way Ctrl+T in Excel), then save the table with a given name.

Thanks,
Sam

[BigJohn]

I have the same issue and would like to see this feature added.  Is there a particular reason why there's a hard rule that you must specify a table instead of assuming that the data is a table and automatically making the Sheet a table?

[abrae005]

This would also be useful to me. I get a file from an external source, and it would be great if I could automate making it a table, so I could then copy all the data to a different spreadsheet (with a table) so I can analyze it in PowerBI.

[ONYXJas]

Even simpler, allow the Get Rows action to return rows that are not in tables...

[katonage]

duplicate - same problem, vote both ideas

https://powerusers.microsoft.com/t5/Flow-Ideas/MS-Flow-to-import-from-Excel-from-Data-Range-and-not-...

[katonage]

Excel Online (Business) / Create table 

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

[Anonymous]

I agree with @ONYXJas. Until I started working with Flow I had no idea you could even make a table in Excel! I am having many difficulties using the current connectors with Flow and Excel. Can't get table rows AND use dynamic file names. MUST use a table. Seems all these things make it impossible to use excel files as starting input to a flow process for automation without custom connectors!

Create an excel connector where the filename comes from a dynamic source, and you can identify the header row (if not 1 then that row is the field names and all rows prior are skipped and all rows after are data), identify the column where data is required to know when to stop processing the worksheet, allow worksheet to be identifed or if not specified use the first in the excel document.

[Freck]

Has this been solved yet? I'm hitting a similar wall. I need to handle invoices from third parties. In this particular case the table starts on A8 but it will be different for different invoice styles. The data is not formatted into tables.

1. If PowerAutomate could automatically find data organized into tables if not called tables that would potentially mean one process could handle multiple statement styles.

2. If PowerAutomate would take an input cell range of the column headers then I could point to the data it needs to read as a table.

1 would be ideal but 2 would be workable