It's only the cloud flows that require it formatted as a table. And that is because it uses GraphAPI to interact with Excel, and it currently only supports tables. Power Automate Desktop flows do not require tables, as it uses a different approach to interacting with Excel (due to the fact it runs on the desktop).
But it can be done quite easily by using VBScript/PowerShell. Here's a sample script that you can use in a Run VBScript action:
Const xlYes = 1
Const xlSrcRange = 1
Dim Workbook,Worksheet
'Launch the Excel app
Set Excel = CreateObject("Excel.Application")
'Open the workbook
Set Workbook = Excel.Workbooks.open("%FilePath%")
Activate a specific worksheet
Set Worksheet = Workbook.worksheets(1) 'Set a different index here, or use a name of the sheet
'create a new listobject from the Range with top-left=A1
Worksheet.ListObjects.Add xlSrcRange, Worksheet.Range("A1").CurrentRegion, , xlYes
'Save and Close Excel
Excel.DisplayAlerts = False 'don't show "a file already exists..."
Workbook.Save
Workbook.Close
Excel.Quit
Note: you need to set %FilePath% to the path to the actual Excel document path via Set variable before the Run VBScript action.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
