Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jHrgwA5aNzs7lD/dGTIuG1
Copilot Studio - General
Unanswered

MS SQL Server stored procedure plugin parameters

Like (0) ShareShare
ReportReport
Posted on 5 Jan 2024 16:06:45 by 22

Hi

 

Does anyone know how to create input parameters for plugin? There are only two options for Parameters section in Plugin definition

How will the bot fill this input?
1. Dynamically fill with best option (default)
2. Set Value

When I change to set value I can set only one value, but my stored procedure has few parameters. Does anyone know how to cope with that?

Categories:
  • adilei Profile Picture
    on 01 Feb 2024 at 06:17:40
    Re: MS SQL Server stored procedure plugin parameters

    My suggestion pointed to a different pattern: 1. Create a Power Automate flow that calls "Execute Stored Procedure". Make sure that the input parameters for your flow are the ones needed to run the stored procedure. 2. Load the flow itself as a plugin action in Copilot Studio, instead of loading the connector directly

  • Twon Profile Picture
    22 on 30 Jan 2024 at 11:51:36
    Re: MS SQL Server stored procedure plugin parameters

    Hi @adilei  thanks for your insight.
    I'm not even at this point to test it, it's because I simply don't how to fill in parameters. Could you please take a look on the screenshot, do you know how to pass 4 arguments in the last line which is called "Parameters list"?
    If I fill in correctly and then it will turn out that this functionality doesn't work yet, then fine. But again for now I don't even know how to pass arguments which is very first step.

    Twon_0-1706615339967.png

     

  • adilei Profile Picture
    on 14 Jan 2024 at 21:14:15
    Re: MS SQL Server stored procedure plugin parameters

    Sorry for missing your reply. Plugins are currently in preview, and currently not all connectors flawlessly translate to plugins. For now, I suggest the Power Automate approach - I'm not sure the latency is going to be noticeable, but you will have to verify.

  • Twon Profile Picture
    22 on 08 Jan 2024 at 15:59:38
    Re: MS SQL Server stored procedure plugin parameters

    It does not. Moreover it's not establishing connection realtime like Power Platform does, thanks to which you see there available names of stored procedures on the dropdown list. Please look at attached screenshots. There are two same options for each connection parameter(Server, Database, Procedure, Parameters). Field is called "How will the bot fill this input?"
    1. Set as value - where you can set one value(which for me for now in Parameters case doesn't make sense as you can have multiple parameters there, unless you can fill out all parameters in one line - which I don't know how to do here.)
    2. Dynamically fill with best option (default) - which I have no idea of how it works.

    I would rather use directly connector in the Plugin section, Power Automate flow might be slower than direct connector implementation.
    Why it doesn't work? Does that mean there is a bug? Or how to set it up?

  • adilei Profile Picture
    on 08 Jan 2024 at 15:30:41
    Re: MS SQL Server stored procedure plugin parameters

    So when loading "execute stored procedure" as a plugin, Copilot Studio does not dynamically identify the parameters for the procedure? If that is the case, consider wrapping the connector with a Power Automate flow, and load the flow as a plugin instead.

  • Twon Profile Picture
    22 on 08 Jan 2024 at 14:12:32
    Re: MS SQL Server stored procedure plugin parameters

    @adilei SQL Server connector, Execute stored procedure (V2)

  • adilei Profile Picture
    on 05 Jan 2024 at 19:31:42
    Re: MS SQL Server stored procedure plugin parameters

    Which connector and action are you using in this plugin?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started
Loading complete