Make direct calls to SQL Server stored procedures


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.


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.

See also

Overview of connectors for canvas apps (docs)