Answered

sql query results

(0) Share

Report

Posted on by lkhall_37203

I have a PAD where I am running a SQL statement to calculate a rather complex time differential equation. where the query executes their will only ever be 1 value return in the output. It appears that the output of the SQL statement comes back as a data table with 1 column and 1 row. I need to be able to use this value as part of another calculation further down in my PAD process but can't seem to find the best way to get the value out as a variable to use. Any help or guidance would be greatly appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

LokeshBysani 229 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@lkhall_37203 Lets say you have a datatable variable called %SQLResultsTable% with 1 row and 1 column as below and if you want to extract the result 45 and use it in downstream. follow this approach.
1. set variable action and provide a variable name
%SQLResultsTable[0][0]%

Was this reply helpful? Yes No
lkhall_37203 72 on at

Like (0)

Report
Copy link

Link copied!

thanks, works perfect I was using %SQLResultsTable[0]% which makes sense now why it wasn't working.

Was this reply helpful? Yes No
LokeshBysani 229 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@lkhall_37203 When working with data tables in Power Automate, you can use the following approaches to retrieve specific column values:
To fetch values using row and column indices:
%SQLResultsTable[rowindex][columnindex]%
For example: %SQLResultsTable[0][0]% (fetches the value from the first row and first column), or %SQLResultsTable[0][2]% (fetches the value from the first row and third column).
To fetch values using column names:
%SQLResultsTable[rowindex]['columnName']%
For instance: %SQLResultsTable[0]['Result']% (fetches the value from the 'Result' column for the first row).

Was this reply helpful? Yes No