Customers can now call stored procedures in Power Automate without incurring performance penalties, leading to improved efficiency in action-based apps. This feature allows customers to directly call stored procedures using Power Fx, eliminating the need for additional steps. By adding a SQL Server Database object to their data sources, customers can access stored procedures actions directly from the database object. This feature helps avoid performance hits during app initialization and reduces the need to move data in and out of collections, resulting in better overall data call and update performance. The benefits include enhanced user experience, streamlined workflow, and improved app performance. To get started, customers need to create a SQL connector, enable SQL Server stored procedures in the app settings, and add SQL as a data source.
Login now to access my digest by 365.Training