Call SQL Server stored procedures directly in Power Fx (Preview)
Power Apps now allows users to directly call SQL Server stored procedures, eliminating the need for a Power Automate Flow. This feature is currently in preview and available in all regions. It simplifies the development of Power Apps for SQL and improves app performance. To use this feature, enable the preview switch in the app settings and create a new SQL connection. Select the stored procedures you want to access in your app and you can directly use them. This feature provides an additional level of security by allowing the execution of stored procedures but not arbitrary SQL. It also allows binding stored procedures to galleries and tables.
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