You’re offline. This is a read only version of the page.
Hi guys im new to power automate, please help me.
about how to get value of 20627.31 from this non-table sheet for using it in power automate
this value can get from many methods which are:
1)E106
2)SUM(E10:E105)
3)max(A:E)
or
anything else
ps. i attached file below
Thanks in advance for helping.
thanks for your helping sir, i will try it.
@_qqneed_uall Sorry didn't realise you were using Power Automate Desktop - that can handle non-table formats just fine.
I see the row you're looking to extract has the value "ผลรวมทั้งหมด" (which google translate tells me means 'grand total' makes sense!) in column 1, so you can have the desktop flow search for that exact text, and that action returns the row and column number of where it was found. Then you can use that row number in a subsequent action to get whatever column value you want. Attached is a flow I've just done with your sample file and I put the resulting value into an output variable, works fine:
You mention that your source data is downloaded regularly from a website with a different filename. Since you have to manually download, I'd say just create a copy and call it something like 'wrg latest for power automate.xlsx' or something, and then Power Automate has the same filename to find for each run.
i use power automate desktop
this excel is what i downloaded from website it will change file name and data every day . all i need to do is when new file is downloaded, it should paste in this table form, right?
@_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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (