cancel
Showing results for 
Search instead for 
Did you mean: 

Calling a Stored Procedure in PowerApps

It would be fantastic to have stored procedure access to PowerApps. It's a feature presently blocking a number of customers of ours from implementing PowerApps since much of their logic is in the sprocs already. They don't want to implement Flow for this since they see it as another cog to pay for. This seems like pretty core functionality but there must be some big technical blocker from MS implementing it. 

Status: Under Review
Comments
Kudo Kingpin

It's a big review... 😉

Regular Visitor

Why is this still under review? Should have been released long ago. Trying to keep all the data logic in the app layer creates a very clear constraint to scale. That MS Flow workaround is garbage. Very frustrating!!

Regular Visitor

Calling a stored procedure should have been available right from day 1 when premium SQL Server connector was released. On one hand Stored Procedure is one of the best practice for performance optimization since queries are compiled on so on, at the same time MS did not provide that functionality. Create a flow to invoke stored procedure from Power Apps is a bad design and implementation. Hence if there were 5 stored procedures, one would need to create 5 flows for those. PowerApps was to make it simpler to develop Apps so there should not be requirement to use Flow to invoke stored procedures.

 

Please implement this as a priority.

 

 

Kudo Kingpin

I agree.
I thought of this as a (very) nice to have since we has the Flow workaround. It's a pain to move an app into production with 20+ Flows around, but hey it was part of the free connector gig. Now that we pay a substantial amount for this, it needs to be part of the package.

Super User II

I agree this would be great if it could be done natively from Power Apps. The Same for SQL Queries.

 

In the meantime, the following video shows how to pass parameters to Stored Procedures from Power Apps through Power Automate.

https://youtu.be/BAGBzI4zdww

 

Another thing that would make using Power Automate easier for running stored procedures (and other data sources), is the parse JSON directly in PowerApps. Please go and vote for this idea:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Parse-JSON-in-PowerApps/idi-p/359563

 

 

Resolver II

Can we get an update on this backlog item, it's been under review for a long time. Thanks!

Kudo Kingpin

Yes! Pretty Please 🙂 A simple update would be great!

Regular Visitor

An update with an ETA, of course

Kudo Kingpin