Hey All,
I have a flow which is triggered by Power Apps. I have created an action within this flow: Execute Stored Procedure (SQL Server V2). When I added this action, it showed the right Server name en db name setup by the connection reference. When I selected the servername and db name I could choose the right stored procedure. It even showed the right parameters. fd
AFter saving the flow as a draft, the I got the following error message:
Failed to retrieve dynamic inputs. Error details: 'The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'Forbidden'. This may indicate invalid input parameters. Error response: {"status":403,"source":" from token exchange: Permission denied due to missing connection ACL: Connection ************************* version -9223372036854775808, connection=europe-002/sql/**********************"}
Is this firewall related? The SQL Server is installed on our server and uses a gateway. Or has this something to do with the way we have setup our connections and connection references?
Share
Report
All responses (
Answers (
463
