Datable query

[HazemSaleh]

Hello, 

Im extracting data from excel to a data table , is it possible to query the datatable without iterating throw ever item in it?

And if its possible how to get the SUM of a cloumn? im trying all the syntax but no luck.
Select SUM [cloumn name ] from SHEET1 where.... never worked for me.

[VJR · Accepted solution]

Use it as follows:

Select SUM(Age) from [Sheet1$]

Regarding your first query you can find a value or update the datatable using below actions.

Check the Datatable section for other ways to directly access any particular row

Variable data types - Power Automate | Microsoft Learn

[GJH]

VJR, I believe the SQL statement is correct but the error says that its Invalid? 

[VJR]

Is there a space in your actual sheet name like you have given in the query? -> sheet 1$

Also check the upper and lower case.

[garthh]

VJR…silly me! Thanks, I’ll check tomorrow 

[GJH]

VJR, this error is returned

Should the Filter statement be part of the path?

I tried a semicolon and placing it in parenthesis but got this error

Apology for my naivety!

[VJR]

The file extension in the screenshot is showing as .xlxs whereas the correct extension of an Excel file is .xlsx

[garthh]

VJR, thank you

i didn’t use the SQL statement but will experiment later. I found SUBTOTAL(109, ref1, [ref2],…) worked well