SQL Server Execute Store Procedure (V2) and other actions missing as action in Logic Apps

Anonymous
2022-07-12T18:11:19.863+00:00

I see all over the Web and documentation, that there are a number of possible actions under SQL Server operations in Logic Apps. But in my end, the "Execute Stored Procedure (v2)" as well as others are not visible.

I only see the "Execute Query" option:

219986-azure-logic-apps-sql-server-actions.png

What am I missing?

Azure Logic Apps
Azure Logic Apps

An Azure service that automates the access and use of data across clouds without writing code.

0 comments No comments

Answer accepted by question author
Kamlesh Kumar 3,871 Reputation points Volunteer Moderator
2022-07-12T18:35:37.057+00:00

Hi @Anonymous ,

Welcome to Microsoft Q&A Platform. Thank you for the question.

You are seeing the difference because you have selected the SQL Server from built-in connector list, though if you select it from Azure Connector list then you could see the more actions.

In below screenshot I have added the diff,

Standard Logic-App with Built-In Connector

220025-image.png

Standard Logic-App with Azure Connector

220026-image.png

Consumption Logic-App

220013-image.png

Please refer below MS documentation for more detail about LogicApp Connectors,

Regards,
Kamlesh Kumar
BizTalk Techie

Please don't forget to click on 205836-130616-image.png or upvote 205759-130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is How

Want a reminder to come back and check responses? Here is how to subscribe to a Notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Drew T Robertson 0 Reputation points
    2026-06-11T15:30:27.51+00:00

    Note, regarding Execute stored procedure (V2)
    the action has a native "ReturnCode" to evaluate. It is upper/lower case. but when "selecting" it as a reference, it is all lower case!!!! you have to manually fix itUser's image

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.