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

Anonymous

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?

0 comments No comments

Sign in to comment

Answer accepted by question author

Kamlesh Kumar 3,871 Reputation points Volunteer Moderator

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

  1. Anonymous

    Thanks a lot! Fully clear


Sign in to comment

1 additional answer

  1. Drew T Robertson 0 Reputation points

    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 it👁 User's image

    0 comments No comments

    Sign in to comment
Sign in to answer

Your answer