Make direct calls to SQL Server stored procedures
Important
This content is archived and is not being updated. For the latest documentation, go to Microsoft Power Apps documentation. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.
Important
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
| Enabled for | Public preview | Early access | General availability |
|---|---|---|---|
| Users by admins, makers, or analysts | 
Mar 10, 2024 |
- | Jun 2024 |
Business value
Customers will no longer pay a performance penalty to call stored procedures by using Power Automate. Action-based apps will be easier to use with better paging and refreshing.
Feature details
Customers can directly call stored procedures using Power Fx. Customers can add a SQL Server Database object to their data sources and then access Stored Procedures actions off of the database object. This will help customers avoid an OnStart perf hit by calling Power Automate. Similarly, they won't have to move data in and out of collections so overall data call and update perf will be better. Working with stored procedures is different than working with vanilla tables. You can't filter the results directly. You may be able to filter the results if the stored procedure has built-in filtering parameters. For more details on how to use this feature, go to Connect to SQL Server from Power Apps.