I'm attempting to test our newly-established Power Automate premium license by executing a stored procedure on an Azure SQL server. I've tried 2 things:
Created a new Connection for the SQL server in question using Microsoft Entra ID Integrated permissions, which appears to have established a connection; I don't know how to use the connection when building my flow.
In the flow, added an Execute stored procedure (V2) step (since I can't see how to reference the Connection I created) in which I manually entered the information for Server name, Database name, and Procedure name (see image below).
In the second scenario, I get "GatewayTimeout" errors. Does this point to an issue with a setting on the SQL server?
Thanks for any tips here that might get me up and running.
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.
249
Share
Report
All responses (
Answers (
