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
Hi Kris,
Thank you.
I am using azure REST API instead now. Works fine for me.
thanks again and best regards
Ingo
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