Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
| Enabled for | Public preview | Early access | General availability |
|---|---|---|---|
| Users by admins, makers, or analysts | 
Mar 10, 2024 |
- |
Jul 28, 2024 |
Business value
With Power Automate, you don't sacrifice performance when you call stored procedures. You get an easier experience with action-based apps through improved paging and refreshing.
Feature details
With Power Fx, you can call stored procedures directly. Add a SQL Server Database object to your data sources, and then access stored procedure actions from the database object. This approach helps you avoid the OnStart performance impact that comes with calling Power Automate.
When you use stored procedures, you don't need to move data in and out of collections. This approach improves performance.
Working with stored procedures differs from working with basic tables. You can't filter the results directly. However, you might be able to filter results if the stored procedure includes filtering parameters. For more information, see Connect to SQL Server from Power Apps.
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.