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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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