Customers can now call stored procedures in Power Automate without incurring performance penalties, leading to improved efficiency in action-based apps.

Feature Details:

  • Direct Stored Procedure Calls:  Customers can utilize Power Fx to directly call stored procedures, eliminating the need for additional steps.
  • Seamless Integration: Adding a SQL Server Database object to their data sources enables customers to access Stored Procedures actions directly from the database object.
  • Performance Optimization: This feature helps customers avoid performance hits during app initialization by calling Power Automate. Additionally, it reduces the need to move data in and out of collections, resulting in better overall data call and update performance.
Continue reading