Unanswered

Access output from Execute a SQL Query (V2)

(0) Share

Report

Posted on by alex93jansen

101

I'm aware this question has been asked several times, but it seems the functionality of this item has changed recently and none of the solutions people have suggested are working for me.

I have a Flow which is triggered through PowerApps, taking several input parameters (provided by PowerApps) to verify whether 1 or more records matching the parameters already exist in a SQL table.

Execute a SQL query (V2) action:

Execute a SQL query (V2) response:

The issue is that there's no way for me to access the "count" variable in this response. I have tried the "Compose" and "Parse JSON" actions, but neither allow me to input the SQL response body anywhere.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

eric-cheng 5,171 on at

Like (1)

Report

Hi @alex93jansen ,

Because Table1 is a JSON array, it will try to loop the JSON objects within.

I will provide two options:

Option 1

Add a Parse JSON underneath and copy the above Body into the sample JSON payload

Add a Compose action underneath and go to expressions and paste this in (you may need to tweak Parse_JSON depending on the name of the action in the previous step). What this does is to return the first JSON object in the index and count field.

body('Parse_JSON')?['ResultSets']?['Table1'][0]['count']

When you run it, it should return the count

Option 2

You could also try the Get rows (v2) action which will still allow you to apply filters. You can then get the length of the value to get the row count.

length(body('Get_rows_(V2)')?['value'])

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No
alex93jansen 101 on at

Like (0)

Report

Thanks for the reply.

I tried Option 1, as follows:
which creates the "Schema" in the Parse JSON action. However, for the "Content" I'm not able to put any Dynamic Content from the SQL query action (only PowerApps items show up):

I also tried Option 2 which does work, so I got everything work the way it should now. Thanks.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Glad its sorted

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No