Hello,
I have a PowerApp that uses a Microsoft SQL Server through a datagateway. In the database I have created a stored procedure that is called by a flow. This stored procedure needs an input parameter called "year".
Everything works fine, but I want to switch the database from a local server to Azure. So I created an Azure database with the same CREATE statements and the same stored procedures.
I changed the source from flow and the input value field for the parameter "year" disappears and an error occurs saying that the datatype for the parameter "year" is invalid.
So here is a picture of the flow using the local database:
And that's the flow after I changed the connection to the Azure database:
I have all permissions for the Azure database and a stored procedure without parameters works fine.
I have also tried using the Azure stored procedure via SSMS and it works well.
Is this an error or how can I set the parameter for the variable "year" ?
