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

Stored Procedure Flow Action Result Set in a PowerApps Gallery

I would like to use the result set from a Stored Procedure to create a list using PowerAppsGallery.  I have successfully set up the Stored Procedure action in Flow.  However, I am having trouble figuring out how to get that the ResultSet in the Output of the StoredProcedure back into PowerApps.   I've taken a look at this

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-a-sql-stored-procedure-to-powerapps-...

And watched a couple of YouTube videos, but those are focused on INSERTS/UPDATE not returing a result set back to be consumed in a PowerApps Gallery.  But no luck. I think I am stuck on Data Operations Select.  It seems in my Data Operations Select I should be able to use Dynamic Content for the From = ResultSets.  But I'm not having any luck.  

 

Anybody aware of documentation or a video that shows the basics of  #1 Passing parameters from PowerApps to a Stored Procedure Action in Flow >> #2 Returing the result set of the Stored Procedure to a PowerApps Gallery?  This seems like a basic design pattern.  

 

Also here is a picture where I think I am stuck. It seems in the Data Operation Select that the From box should have ResultsSetsTable available, but there is nothing. Any suggestions on what is going on here?
powerapps-flow-stored-procedure.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Stored Procedure Flow Action Result Set in a PowerApps Gallery

Hi @maphill ,

Do you want to return data to PowerApps from Flow?

I think this link may help you:
https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

What's more, I suggest you post your issue in Flow forum.

The engineers there are more professional about this kind of problem.

https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums

 

Best regards,

Community Support Team _ Phoebe Liu
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
Highlighted
Community Support
Community Support

Re: Stored Procedure Flow Action Result Set in a PowerApps Gallery

Hi @maphill ,

Do you want to return data to PowerApps from Flow?

I think this link may help you:
https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

What's more, I suggest you post your issue in Flow forum.

The engineers there are more professional about this kind of problem.

https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums

 

Best regards,

Community Support Team _ Phoebe Liu
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

Highlighted
Helper I
Helper I

Re: Stored Procedure Flow Action Result Set in a PowerApps Gallery

maphill did you ever figure this out. I am having the same EXACT issue you had. I see that this was solved, I'm really curious and have spent many hours trying to do something which should be hard to do. PLEASE HELP I'm losing my mind.  Thank you kindly!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,503)