How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

Posted By Arun Potti on 1 Mar 2024 in Dyn365CE

Microsoft has released a new feature to call the SQL stored procedure from the Canvas Apps using Power Fx. Customers can add a SQL Server Database object to their data sources and then access Stored Procedures actions off of the database object.

In this article, will explain step-by-step process to enable the SQL stored procedure preview feature in the Canvas Apps.

Pre-Requisites:

1. Click on the below article link and create a Microsoft Edge or Google Chrome Profile.

   Create a Profile in Microsoft Edge and Google Chrome

2. Click on the below article link to create Power Apps Trial 30 days or if you have already have an Powers Apps Tenant, skip this step.

   Create Microsoft Power Apps 30 days Online Trial Version

Follow the below steps after the Pre-Requisites.

Step 1: Open an Existing App or Create a new Canvas App.

Step 2: Click on Settings.

Step 3: Click on Upcoming features.

Step 4: Under Preview, Click on SQL Server stored procedures to…

More About This Author

Arun Potti

Array

Array

• Dyn365CE26 April 2024Timeline Highlights (New feature) in Microsoft Power Apps
• Dyn365CE26 April 2024Model-driven App – Cannot “See associate records” option in the sub grid?
• Dyn365CE19 April 2024Bookmark the Important Dynamics 365 URLs
• Dyn365CE19 April 2024How to Remove Email from the Suppression list in Dynamics 365 Customer Insights Journey (Preview feature)