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

Power Automate -setting "Server name", "Database name" and getting stored procedures listing
Power Automate -setting "Server name", "Database name" and getting stored procedures listing

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
Power Automate - Creating Instant cloud flow
Fig : Power Automate – Creating Instant cloud flow
  • 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
Power Automate - Creating Instant cloud flow
Fig : Power Automate – Creating Instant cloud flow
  • Once flow created it is as
Fig : Power Automate - Creating Instant cloud flow
Fig : Power Automate – Creating Instant cloud flow
  • Now, lets add action for executing stored procedure
  • We will use “Execute stored procedure (V2)” action from “SQL Server” connector as
Power Automate -Adding "Execute stored procedure (V2)" action
Fig : Power Automate -Adding “Execute stored procedure (V2)” action
  • Once we added “Execute stored procedure (V2)” action we need to specify following details
    • Server name
    • Database name
    • Procedure name
Power Automate -"Execute stored procedure (V2)" action
Fig : Power Automate -“Execute stored procedure (V2)” action
  • We will get “Server name” and “Database name” from the connection string as
Microsoft Azure - Azure SQL database connection string
Fig : Microsoft Azure – Azure SQL database connection string
  • Once we selected “Server name” and “Database name”, we will get all the list of stored procedures which we need to execute as
Microsoft Azure -setting "Server name", "Database name" and getting stored procedures listing
Fig : Power Automate -setting “Server name”, “Database name” and getting stored procedures listing
Power Automate - Flow Runs page
Fig : Power Automate – Flow Runs page
  • We will check the latest flow which executed successfully as
Power Automate - Input and Output details for flow
Fig : Power Automate – Input and Output details for flow
Power Automate - Input and Output details for flow
Fig : Power Automate – Input and Output details for flow
  • 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 –

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 🙂

Prasham Sabadra

LIFE IS VERY BEAUTIFUL :) ENJOY THE WHOLE JOURNEY :) Founder of Knowledge Junction and live-beautiful-life.com, Author, Learner, Passionate Techie, avid reader. Certified Professional Workshop Facilitator / Public Speaker. Scrum Foundation Professional certificated. Motivational, Behavioral , Technical speaker. Speaks in various events including SharePoint Saturdays, Boot camps, Collages / Schools, local chapter. Can reach me for Microsoft 365, Azure, DevOps, SharePoint, Teams, Power Platform, JavaScript.

You may also like...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: