cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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

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

flowDiscussionMessage.png

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Memorable Member
Memorable Member

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,

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

Community Support
Community Support

 

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

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Memorable Member
Memorable Member

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,

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

Community Support
Community Support

 

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

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (19,768)