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.
| Enabled for | Public preview | Early access | General availability |
|---|---|---|---|
| Users by admins, makers, or analysts | 
Mar 10, 2024 |
- |
Jul 28, 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 from the database object. This helps customers avoid an OnStart performance hit by calling Power Automate.
Similarly, customers won't have to move data in and out of collections; therefore, performance is better.
Working with stored procedures is different than working with basic 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.