Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Changing a Connection Reference in a Managed Solution?

(1) ShareShare
ReportReport
Posted on by 829

Hello,

 

We have two SQL Connections in our environment:

SQL-1

SQL-2

 

A Connection Reference in a managed solution was set up during import to reference 'SQL-1'.

Can we now edit/change/reimport this Connection Reference in our solution to point to 'SQL-2' instead?

 

Thanks in advance

  • Charles Seguin Profile Picture
    Charles Seguin 401 on at
    Re: Changing a Connection Reference in a Managed Solution?

    You just saved my weekend! Thanks for posting this solution.

  • RPraschma Profile Picture
    RPraschma 9 on at
    Re: Changing a Connection Reference in a Managed Solution?

    Hi @raulcocerasanch,

    just change it using the default solution (see solution for this post).

    Ignore my workaround since it is not necessary.

  • Re: Changing a Connection Reference in a Managed Solution?

    Hi ,

     

    could you tell me the fields you used to update the table? I tried to do the update and it asks me for the Api id, showing the message :

    Api Id cannot be null or empty on a connection reference 

    raulcocerasanch_0-1696450344123.png

     

  • RPraschma Profile Picture
    RPraschma 9 on at
    Re: Changing a Connection Reference in a Managed Solution?

    Nice.

    Now finally a proper way to do this.

    Thank you, thank you, thank you.

     

    Didn't know about it.

    The workaround I found was changing the connection ID in the connection reference table in dataverse using a cloud flow.

    Super backend without knowing the full impact, but after turning the affected flows off and on again it actually worked 🙂

  • Hppyclown Profile Picture
    Hppyclown 23 on at
    Re: Changing a Connection Reference in a Managed Solution?

    Legend!

  • Verified answer
    rb Profile Picture
    rb 829 on at
    Re: Changing a Connection Reference in a Managed Solution?

    In case anyone ever finds this, here is how you can change the Connection property of a Connection Reference in a Managed Solution:

     

    Go to Solutions -> find "Default Solution" -> Find your connection reference and edit it's properties from here.

     

    I hope this helps someone!

  • rb Profile Picture
    rb 829 on at
    Re: Changing a Connection Reference in a Managed Solution?

    Sorry, but how would this work?

     

    If I change the connection in the source environment, how does Power Platform know which Connection to use for the Connection Reference in the target environment after export? The connections will have different names/IDs/values....

  • kierian Profile Picture
    kierian on at
    Re: Changing a Connection Reference in a Managed Solution?

    You have to change connection on un managed solution  once you did all change export it as managed solution that only way 

    Have a good day.

  • rb Profile Picture
    rb 829 on at
    Re: Changing a Connection Reference in a Managed Solution?

    Hey Kierian,

     

    Thanks for that - so in my case, what are the options for getting the Connection Reference changed from SQL 1 to SQL 2?

     

    It seems the only way would be to delete the Solution, re-import, and choose SQL 2 for the Connection Reference value. But then I would lose all the permissions to my PowerApp, right? Possibly worse - the App ID/URL could change?

  • kierian Profile Picture
    kierian on at
    Re: Changing a Connection Reference in a Managed Solution?

    In managed solution all components are in read only you cant edit or add new connection.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics