StoredProcedure Object - ResultSets.Table1 Object not Populating in Response Action Body

[maphill]

Hi All 

I am following this video on how to use a Stored Procedure via Flow in PowerApps.  It seems pretty straightforward.

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

I am using the Reponse Action to pass the json array back to Power Apps.  For some reason Flow is not creating a ResultSets.Table1 object that I can use in my Response action.   I only see a ResultSets object. 

Any suggestions on why I cannot get the ResultSets.Table1 object to populate?  I've tried several different things and it seems like Flow isn't fully turning  the Output from my Stored Procedure Action into objects that can be used in subsequent steps.  See below for what I am getting

[faustocapellanj · Accepted solution]

Hi @maphill 

Flow converts certain data types automatically, but to convert other data types, expressions are needed. If you look close in the GIF embedded in the article, @Mr-Dang-MSFT writes the expression as follows:

body('Execute_a_SQL_query').ResultSets.Table1

Did you try it that way? Also, did you copy the Table1 information from the SQL action output to generate the JSON schema? Please let me know.

Thank you,

[v-bacao-msft · Accepted solution]

Hi @maphill ,

Following the suggestion of @faustocapellanj , you could use the expression provided by him to get Table1.

In addition, you could use Parse JSON action to parse Body of the previous action.

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

Please take a try.

Best Regards