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

(1) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

faustocapellanj 1,662 on at

Like (1)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No