Power Platform – Executing Azure SQL stored procedure from Power Automate – Part 2

Hi All,
Greetings for the day 🙂 LIFE IS BEAUTIFUL 🙂 I hope we all are safe 🙂 STAY SAFE, STAY HEALTHY 🙂
We are discussing how to execute Azure SQL stored procedure from Power Automate. This is second part. In first part – “Power Platform – Executing Azure SQL stored procedure from Power Automate – Part 1 – Adding SQL Server Connector ” we discussed how to use “SQL Server” connector in Power Automate.
In this article we will actually execute the Azure SQL stored procedure from the Power Automate.
So lets begin the fun 🙂
Take away from this article :
- How to use “SQL Server” connector action – “Execute stored procedure (V2)”
Create the Power Automate and Execute the Stored procedure using the connector “SQL Server” which we added in last article
- Navigate to Power Automate home page
- From left side navigation click on “+ Create” link as
- Here we will create “Instant cloud flow”
- On “Build an instant cloud flow” dialog specify the details:
- Flow name – Knowledge Junction – Execute Stored Procedure demo
- Select the trigger – “Manually trigger a flow” as
- Once flow created it is as
- Now, lets add action for executing stored procedure
- We will use “Execute stored procedure (V2)” action from “SQL Server” connector as
- Once we added “Execute stored procedure (V2)” action we need to specify following details
- Server name
- Database name
- Procedure name
- We will get “Server name” and “Database name” from the connection string as
- Once we selected “Server name” and “Database name”, we will get all the list of stored procedures which we need to execute as
- Select the stored procedure which we want to execute. Here in my case only one stored procedure – “GetAllGroups” as shown in above fig
- Once stored procedure selected, we are ready to test the flow. Trigger flow manually.
- From “Flow Runs Page” – https://india.flow.microsoft.com/manage/environments/Default-6b38e1c3-a1fe-40cc-8b93-a4159a50592c/flows/587e9212-9812-442e-9df2-60c1ea4fa867/runs we could monitor the status as
- We will check the latest flow which executed successfully as
- In above Fig, please have a look at Output of the flow. We get the – ResultSets.
Here I’ll stop today 🙂
Next Article : In next article we will discuss use the ResultSets returned from the stored procedure
To understand Power Platform in depth please have a look our articles once –
- Power Platform – https://knowledge-junction.in/?s=Power+Platform
- Power Apps – https://knowledge-junction.in/?s=Power+Apps
- Power Automate – https://knowledge-junction.in/?s=Power+Automate
- Power BI – https://knowledge-junction.in/?s=Power+BI
Thanks for reading 🙂 If its worth at least reading once, kindly please like and share 🙂 SHARING IS CARING 🙂
Share In Teams:Enjoy the beautiful life 🙂 Have a FUN 🙂 HAVE A SAFE LIFE 🙂 TAKE CARE 🙂
You must log in to post a comment.