How to change SQL connection in Power App when import to another environment

(0) Share

Report

Posted on by hongkong

277

I am building a canvas Power Apps connecting to SQL server.

Our database admin told me connect the DB using Azure Active Directory - Universal with MFA. It is working fine when I connect with SQL management studio. When I build my apps, I can connect to target DB by simply type in server name and database name (no need type any other parameter).

When I export the App with solution and import to another environment, it doesn't prompt me to setup connection. I cannot edit the App too because it is a managed solution. Is there any suggested way to update SQL connection when import solution to another environment?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @hongkong

You can edit the imported connection through the 'Connections' menu.

Was this reply helpful? Yes No
hongkong 277 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your suggestion. When I try to update the connection, it prompt me below pop-up panel which is Read-only. I cannot change the Authentication type dropdownlist.

Also, when I import the solution, I am being asked to create a new connection. I can "switch user" in this step. (For example, switch from my account to a service account) It is good but I CANNOT change database server name and DB name.

Was this reply helpful? Yes No
nlpickard 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm having exactly the same issue. Did you ever come up with a solution?

Was this reply helpful? Yes No