SQL Server is one of the best products ... the script should look like the following: To call, or execute the stored procedure, you must use either EXEC or the EXECUTE command.

To use SQL Server connections in Power Apps ... would you want this procedure to run within a gallery? Probably not. Unless of course you wanted to audit users accessing data.