@_qqneed_uall Power Automate (cloud version) cannot read data from Excel if it's not in Table Format, there's no way around that. The simplest solution by far - assuming your source file is something you receive / generate regularly - is to use Power Query in Excel to pull in the source data as it automatically creates it in Table format, and then your Power Automate flow can call your Power Query version instead. NB: Power Automate Desktop can work with non-table data, but if you're using a cloud flow then you need a premium license to call a desktop flow, so the simplest solution is just to use Power Query to convert your source data into a nice neat Table format, this is always the go-to for my dept whenever we have a source file that isn't in Table format, takes a few minutes max.
Based on your file, the steps needed are:
1. New Excel file, Get Data > From File > From Excel Workbook: select your file, pick the worksheet then click on 'Transform Data' to open up the Power Query editor.
2. From the Home tab, select 'Remove Top rows' and choose 7, since your source file has 7 rows above where the column headers are
3. Again from the Home tab, select 'Use first row as headers', this will promote your 'RATE A', 'RATE B' etc. to be the 'true column headers once it's in Table format
4. In case Power Query hasn't detected that all your RATE X columns are the right type (for me it recognised RATE C and RATE D as being decimal numbers, but as the RATE A and RATE B had no values it defaulted to alphanumeric, right click on any column headers that show the type as 'ABC123', then choose Change Type > Decimal number.
5. Rename your first column header (currently 'Column1' because your source data doesn't have a column), I've gone with just 'Timestamp' as that's what it looks like to me!
6. Select the multiple column headers (using ctrl + left click) for the columns you want to keep, then right click one of them and select 'Remove other columns'
Once done you get a nice Table format which you can interact with using Power Automate. And because the Power Query steps are saved, when you get a new source file and it's saved in the same location, you can just click Data > Refresh All and the data will be updated instantly within your new Table format.
