Using SQL Stored Procedures within PowerApps via PowerFX


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.


Article 15m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time