Answered

Power Automate - Snowflake - Submit SQL Statement for Execution Help

(0) Share

Report

Posted on by ashleypaceRSF

I am relatively new to Power Automate. I am creating a flow to execute a query against Snowflake and then save the results to a file in OneDrive.

The issue: My Snowflake Submit SQL Statement for Execution action works great. I can test it and in the test flow, I can see the rowType and data results. However, back in my flow, my next step to save the data, rowType and data are not options. Pretty much every other item under the Returns section here is available.

What am I doing wrong???

Results in my test run:

According to the documentation, rowType should be right after format and before name. Even if I search for it by typing it in, nothing returns. The same with data.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

lbendlin 8,617 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What type of file do you want to write to? CSV? In that case the Rowtype won't be important, and you can directly iterate over the data.

Was this reply helpful? Yes No
ashleypaceRSF 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response. The issue is not the file type. The issue really is that I don't have the "data" return value available to do anything with. It does not show up as an output value from my Snowflake query execution.

Was this reply helpful? Yes No
Verified answer

Rocco 13 on at

Like (1)

Report
Copy link

Link copied!

@ashleypaceRSF I struggled with the exact same thing. The dynamic fields can be found by clicking the expression (fx) button instead of the Dynamic content (lightning) button. A window should open with the tab Function open by default. What you want to do now is click Dynamic content. This is where you'll find the fields:
- body/resultSetMetaData/rowType
- body/data

Or you can use the following code if you want to input them manually:
- @outputs('Submit_SQL_Statement_for_Execution')?['body/resultSetMetaData/rowType']
- @outputs('Submit_SQL_Statement_for_Execution')?['body/data']

Hope it works for you,

Rocco

Was this reply helpful? Yes No
ashleypaceRSF 6 on at

Like (0)

Report
Copy link

Link copied!

@Roccoyou are my hero! Thank you so much! Not very intuitive but I'm glad it's there. Thanks for reaching out and letting me know.

Was this reply helpful? Yes No