Power Platform Community Forum Thread Details

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":"https://europe002-002.token.azure-apihub.net:443/tokens/europe-002/sql/***********************/exchange","message":"Error from token exchange: Permission denied due to missing connection ACL: Connection https://europe-002.azure-apihub.net/@europe-002/logicflows/************************** 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?

Categories:

Building flows