cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hmp-pt
Frequent Visitor

No expression builder to define Table1 in Flow Response from a SQL Server (on-prem) stored procedure.

Hi,

 

I trying to create a Flow to execute a SQL stored procedure and have been following lots of posts such as:

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Display-results-from-Flow-SQL-Stored-Procedu...

 

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

 

But I don't get the option to define Table1 as the body of the response returned by the stored procedure (which returns 1 row):

 

Capture1.PNG

 

The result of the flow when using the 'ResultSets' as the body (shown above) is:

 

InkedCapture2_LI.jpg

 

If I manually type the expression in 

body('<my_execute_stored_procedure_(V2)_step_name>').ResultSets.Table1

the text of the expression is all that's returned in the Response-Outputs-Body field.

 

I've spent hours on this trying lots of different configs and json structures with no success so please help!

 

Thank you.

 

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Hmp-pt
Frequent Visitor

Sorry for not posting my solution sooner.

 

I was simply down to the way I was accessing Flow/Power Automate.

 

If you access the flow from https://make.powerapps.com/ and the Flows menu on the left, the expression builder doesn't appear.

 

If you access the flow through the waffle and Power Automate (https://emea.flow.microsoft.com/), it appears!

 

Very frustrating.

 

This needs to be fixed.

View solution in original post

1 REPLY 1
Hmp-pt
Frequent Visitor

Sorry for not posting my solution sooner.

 

I was simply down to the way I was accessing Flow/Power Automate.

 

If you access the flow from https://make.powerapps.com/ and the Flows menu on the left, the expression builder doesn't appear.

 

If you access the flow through the waffle and Power Automate (https://emea.flow.microsoft.com/), it appears!

 

Very frustrating.

 

This needs to be fixed.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,124)