Please try above solution, then check if it is helpful for your scenario. Note: Within the OnSuccess property of the Edit form, you could use the formula to get the submitted field value from your Edit form. When you submit your form data successfully, the OnSuccess property of the Edit form would be fired automatically, then it would invoke your flow, and execute the "Execute storage procedure" action along with the passed parameter values. Then within the OnSuccessproperty of the Edit form, type the following formula: 'Your Flow Name'.Run(Į1, // Argument1 specified in your flowĮ2, // Argument2 specified in your flow Within your canvas app, create a connection to above flow. Then within the "Execute storage procedure" action, specify the parameters you want to pass from your canvas app using "Ask in PowerApps" dynamic content: You could consider fire a flow from your canvas app, then pass the entered field values from your canvas app to your flow.įirstly, you could create a flow on your side, use "PowerApps" button as Trigger, then add a "Execute storage procedure" action of SQL Server connector.
Please check the following article for more details about the known limits of SQL Server connector:Īs an fixed solution, I think the combination of Power Apps and Power Automate Flow could achieve your needs. Currently, Stored Procedures cannot be invoked from Power Apps. Here’s an overview of some of the new features. WYSIWYG Web Builder 17 has more than 125 new features/improvements This release focusses on SEO, Ecommerce, Productivity and Creativity. If you want to invoke your SQL Stored Procedures from your canvas app directly, I afraid that there is no way to achieve your needs. WYSIWYG Web Builder is kept up to date to provide you with the latest features and tools to create amazing website. Hi you please share more details about your scenario?ĭo you want to call your SQL Stored Procedures from your canvas app directly?
0 kommentar(er)
