Answered

SQL query result not accessible

(0) Share

Report

Posted on by MarcDussault

Hi all,

I have a SQL connection. For testing purposes, it retrieves one line from a table. The output is stored in DataTable called 'QueryResult'.

It is 1 row, 70 columns, of which a sample is displayed above.

Let's say I want to extract 'Code' and set it into a variable. From what I gather, the 'Set Variable' syntax should be: %QueryResult[0][2]% (first row, 3rd column), or alternatively %QueryResult[0]['code']%, thus:

When run however, I only get the text representation of the query. As though I simply want to set the variable equal to the above string, as per below:

What am I doing wrong?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@MarcDussault

It appears you've constructed your workflow with Power FX enabled. Please generate a new workflow with Power FX disabled and attempt the same syntax.

For reading datatable values in a Power FX enabled workflow, kindly refer to the syntax provided below.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏

Was this reply helpful? Yes No
MarcDussault 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Beauty - many thanks.

Was this reply helpful? Yes No