Trying to build a flow that would trigger when a new file in a folder is created (using onedrive business for this one). Basically, if I choose get a row , it requires my excel files to have a table to get data from it. However, files I receive are not always formatted so I need something that would parse the files regardless of whether or not it is formatted as table. Is there a workaround?
Yep, use Office Scripts. You'll need to make sure your licence covers it but most do.
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
Or the only other real alternative is the Microsoft Graph API's ...
https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
They allow you to perform a number of functions, one of which is getting range based data that is not formatted as a table.