Power Platform Community Forum Thread Details

Hi All,

We have different environments for Azure SQL. We want to make a Power App where we can easily switch connections to different environments.

Is there any way using ALM or something ?

Thanks in advance

Regards

Manjot Singh

Categories:

Building Power Apps

Hi @manjotsingh057,

The main way I connect to different datasource environments within the app is by using different environments for my Power Platform solution itself (ALM). This would mean that we'd have a DEV, UAT & PRD environment within the Power Platform and each solution in those environments would be connected to their respective SQL / datasource environments.

This can either be done manually by exporting the solution and importing it in the next environment or automatically via Azure DevOps pipelines. During the first (manual) import of that solution in the environment, you will be prompted to create a new connection to SQL.

I would not recommend combining all SQL environments within one solution/app.

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!