Answered

Connection Reference Owner Changing from Dev to Prod

(0) Share

Report

Posted on by IanJB

Hi everyone. I'm having an issue with my connection references not cooperating after publishing from Dev to Prod. In my sandbox environment I have a connection reference set up and owned by a service account. It works just as expected in the dev environment, great! However, when I import the solution to my Prod environment, the connection owner is changed to my personal account. So now whenever a prod cloud flow runs using this connection, it is using my account rather than the service account. I can't figure out how or why this is happening. Any suggestions on what I'm doing wrong here? I just want the connection to remain the same between my dev and prod environments.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Jonathan Manrique 2,687 on at

Like (0)

Report

Hi @IanJB

Connection references may change when I import a solution if when users are different

You can use this method according to the official documentation so when you import you put the connection string you need

https://learn.microsoft.com/en-us/power-platform/alm/conn-ref-env-variables-build-tools

Was this reply helpful? Yes No
IanJB 93 on at

Like (0)

Report

Thanks @Jmanriquerios .

This seems a bit complex for my needs, and I'm not running an automated deployment solution. From that documentation it mentions:
Which sounds to me like at some point in the past (maybe the first time the solution was imported to Prod?) it used one set of credentials for the connection reference, and it's just stuck with that ever since. On subsequent solution imports there is no prompt to update this information, even if I import the solution from the desired account. Any idea on how this can be updated on the Prod environment?
On the dev environment the connection reference is set to allow customizations:
But it is going into a managed solution in the Prod environment so the connection reference is locked for edits.

Was this reply helpful? Yes No
Verified answer

IanJB 93 on at

Like (0)

Report

Found the answer in an old power automate thread:
Solved: Changing a Connection Reference in a Managed Solut... - Power Platform Community (microsoft.com)

In the prod environment simply go to the Default Solution, find the connection reference in question, and it is editable from there. Once updated all of the flows in the managed solution using the reference now are linked to the correct credentials. Very easy!

Was this reply helpful? Yes No
AJAGER 2 on at

Like (0)

Report

Hi, I believe the account used for the deployment takes ownership of all the resources in the solution. So if you connect with the service account for the deployment it should be ok. Doing changes in the default solution creates solution layers which can be problematic as they are applied on top of the deployed solution. It is helpful when used as a hot fix in production. Ultimately you should always delete the solution layer before deploying a new version solution in prod.

Was this reply helpful? Yes No