web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Moving Solutions with ...
Power Apps
Unanswered

Moving Solutions with On Premise Gateway connections between enviornments

(0) ShareShare
ReportReport
Posted on by 36

Hello, I have built an app that has an on premise sql connection as well as about 10 flows that use that connection. When moving between environments I am required by my team to provide a managed solution. In order for the solution to be imported into an environment, I understand that the connections and flows would need to be removed from the solution and added back upon import. What would be the easiest way to go about this? My connection and flows live in environment dev where the owner of that environment is the one importing the solution into environment prod. I am not able to touch the solution in the prod environment and can not add the connections back. I have shared the flows and connection with the user who is in charge of the importing, will they be able to add the connection and flows from the dev environment into the prod environment ? Or would I have to create them again in this new environment? How should I go about getting the references back in there?

I have the same question (0)
  • velegandla Profile Picture
    204 Moderator on at

    @datahelpme 

    You don't have to remove the connections to the flows in development environment.

     

    When someone who got privileges in Prod and access to the data sources they should be asked to connect again via connection references.

     

    https://benediktbergmann.eu/2022/02/08/connections-and-connection-references-explained/ 

     

    ====================================================

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    https://www.linkedin.com/in/devendravelegandla/ 

     

     

  • datahelpme Profile Picture
    36 on at

    It is an on premise sql connection. They were asked to re create the connection when the solution was being imported and based this link we had to remove the connection to import the solution Import solutions - Power Apps | Microsoft Learn. Then all of our flows use this connection, so they had to be removed as well or this error occurred 

     

     

     

    errors.jpg

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard