Power Platform Community Forum Thread Details

Hi everyone,

I'm currently working on an integration between Power Apps and Snowflake. I'd like to filter a Snowflake table using a parameter passed from Power Apps, and then return the filtered data back to Power Apps.

I'm considering using Power Automate to query the Snowflake data, but I'm having trouble finding an action that can properly convert or format the query result to send back to Power Apps.

Has anyone done something similar or have advice on the best approach? I'd really appreciate any tips or examples!

Thanks in advance 😊

Categories:

Building flows

Hi @tasyaaa

Firstly use Snowflake - Connectors | Microsoft Learn the new preview.

Secondarily, its really up to you in a sense.

1) You could return back JSON, then use JSON(returneddata) inside of the App to turn it into an JSON AKA a collection, that's what most people would do

2) if the data is limited, you could always create an array of data and just pass it back as a string, then in the app parse and convert it into a Collection

The point here is, depending on what Data you want to even send back, usually you will send back JSON or some made up flat file structure and convert it into JSON / Collection

JSON function - Power Platform | Microsoft Learn

As mentioned, otherwise you could take the data returned, grab the column values, create some sort of JSON, OR a flat file structure

data1,data2,data3,data4

Then you could parse this into a Collection of data by first splitting by the carriage returns, then inside that Loop, strip each line by a ,

just an example.. but usually I go the JSON rought