Microsoft Power Apps has released a new feature that allows users to call SQL Server stored procedures without using Power Automate. Stored procedures are pieces of code that perform actions within a database. This feature improves performance, hides complexity, and increases the reliability and efficiency of Power Apps solutions. To use this feature, users can add a SQL Server connection to their app and select the stored procedure they want to use. They can then populate galleries with data returned by the stored procedures, making data communication between the app and the database more efficient. This feature is beneficial for accessing data that resides in SQL Server without the need to copy it to another location.
Login now to access my digest by 365.Training