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.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,477)