Unanswered

How to deploy Power automate flows with connection references to another environment?

(0) Share

Report

Posted on by OK29

388

Hi, I have a created solution and then flows in the solution and added connection references for Outlook, Office 365 user, Microsoft forms and SQL (on premises).

Flow is working fine in dev environment.

When I imported solution to prod, the flows were turned off and got errors for SQL connection. I tried to open flow in edit and tried to open the execute sql procedure action and reestablish the sql connections but not succeeded. It's not opening at all. Can I get any help regarding?

Any help would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Usually you create the connection first or during import of the (managed) solution. You should never edit a flow in a managed solution. It will create a custom layer and you will get troubles later if you don’t handle it.

During import of the solution you usually get asked to set the correct connection for each connection reference inside the solution. Depending of the way you import, it will look different.

If you now have a solution without connections, you can create the connections and set the connection references using the default solution.

Was this reply helpful? Yes No
OK29 388 on at

Like (0)

Report

@Matthy79 Thank you for your comments. I am getting issue if I create connections during import because gateway name was not showing up. That's why I deleted solution and created connections first and then imported the solution and it's working as expected.

Was this reply helpful? Yes No