Executing SQL Server stored procedures with Power FX in Power Apps
Microsoft has introduced a new feature that allows direct calling of SQL stored procedures in Canvas Apps using Power FX. Previously, this required the use of Power Automate flows. To call a stored procedure in a Canvas app, you need Microsoft Dataverse access and an existing SQL stored procedure. After connecting to the SQL Server, you can select the stored procedure and designate it as safe for integration within galleries and tables. The stored procedure should have no adverse effects when called multiple times and should return a manageable amount of data. To call the stored procedure with Power FX, you can use the formula "Table(D365.dboGetCompanyAllDetails().ResultSets.Table1)". This feature streamlines the app development process and enhances performance.
Article 4w
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