Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Flow: Unable to select stored procedure [sys].[sp_set_firewall_rule]

(0) ShareShare
ReportReport
Posted on by

Hi. 

 

I have problems to select the stored procedure  [sys].[sp_set_firewall_rule] on a azure sql database.

When setting up the flow, only [dbo]-procedures are presented in the drop down field of possible sp.

I took exactly the same credentials for the sql server management studio 2014 where I can see and execute the above sp. 

Why is it not possible to select the above sp in ms flow? Anny ideas?

 

Best regards

 

Ingo

  • Re: Flow: Unable to select stored procedure [sys].[sp_set_firewall_rule]

    Hi Kris, 

    Thank you.

     

    I am using azure REST API instead now. Works fine for me.

     

     

    thanks again and best regards

     

    Ingo

  • Verified answer
    v-xida-msft Profile Picture
    v-xida-msft on at
    Re: Flow: Unable to select stored procedure [sys].[sp_set_firewall_rule]

    Hi @Ingo,

     

    I have made a test and the issue is confirmed on my side. We could only select the [dbo]-procedures within the Procedure name field of the "Execute stored procedure" action in Microsoft Flow currently.

     

    I afraid that the [sys]-procedures are not supported within the "Execute stored procedure" action of SQL Server connector in Microsoft Flow currently.

     

    If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

     

    Best regards,

    Kris

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics