Storage procedure to production

(1) Share

Report

Posted on by FH-07040800-0

Hello!

I have a project where I am using storage procedure.

When adding the storage procedures to the app it looks like this in test. I have added with envirement variables. A server name and a database name.

I have to write a query like this to call the storage procedure:

'SQL-DB-PowerPlantRegister-006-T'.dbospFilterPlantProduction({PlantIDs: varPlantIDs}).ResultSets.Table1. 
 
When I publish from test to prod it is still 'SQL-DB-PowerPlantRegister-006-T'. How can i make it go to prod? It works fine for tables

Categories:

Experimental features

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi @FH-07040800-0

Do you mean a stored procedure?

Is this in a Canvas App or Model Driven App or Power Page?

Are you saying you have Environment variables defined, but you do not know how to use them?

Here is a guide to help you create and leverage the environment variables for SQL in your app. What you wrote above looks like you hard coded it, not that you are using an Environment Variable(s) for Server or Database

SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog

However, when you export your managed solution to you can put it into production you can change them on import of the solution

When you imported into Production, did you remember to Change the environment variable values as part of the import?

If this answers your question, Please mark as such and maybe a like.

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

Hi @FH-07040800-0:

I think you have to manually rebind the SP reference with a new SQL Connection in prod.

for long term, try to use ALM or Devops + Power platfrom CLI.

here is the article you may know:

Environment variables, SQL Server

Was this reply helpful? Yes No