Not able to use 'Result set' from mssql connector

[rohitjadhav123]

I am able to run my sql query and, can confirm its bringing results back. But, when I go to 'Response' step 'Result set' variable is not present in the 'dynamic content' list. 

Is this a bug on sql connector? or I am missing something?

[rohitjadhav123]

This is how I can confirm I am getting results back.

[v-bacao-msft · Accepted solution]

Hi @rohitjadhav123 ,

Please check this blog and see if it helps:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

You could use Parse JSON action to parse the body of the Execute a SQL query(V2) action.

Then you could search the Dynamic content in search box according to the property name.

Best Regards,