cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
stan_gifford
Level: Powered On

Converting Flow to use Dynamics 365 Prod from Sandbox

Good morning.

 

I have a Loader flow that has been developed and tested against a Sandbox instance of Dynamics 365.

Now I need to put it into production.

Converting any 'Read' actions is easy - just change the connection.

Converting 'write' actions seems to be an issue - If I change the connection, I have to re-enter all fields I am writing (I assume because potentially the underlying Dynamics schema may be different between prod and Sandbox).

 

The only way I can do it is to have two windows open - one with the Sandbox flow and one with the Prod Flow - and transpose between the two with the fields to be written.

 

Obviously this is error prone.

 

Is there anything obvious I have missed when changing the connection from one Dynamics Instance to another? Any other suggestions

 

Stan

 

1 ACCEPTED SOLUTION

Accepted Solutions
stan_gifford
Level: Powered On

Re: Converting Flow to use Dynamics 365 Prod from Sandbox

**bleep** - whenever I publish a question, five minutes later I find the solution....

 

Anyway - what needs to change is the org in the flow.

 

Step 1 - make a teeny little flow connecting to the Production Dynamics environment. I put in a simple list records on the Contacts entity.

 

Step 2 - export to json

 

Step 3 - edit (visual Studio code) and look for something like 

                                    /datasets/@{encodeURIComponent(encodeURIComponent('org8262439b.crm6'))}
 
Step 4 - copy the bit I have bolded (org8262439b)
 
Step 5 - Export the Sandbox flow as a zip file
 
Step 6 - Open the zip file and go to the directory Microsoft.Flow/Flows
 
Step 7 Edit definition.json (visual Studio Code again)
 
Step 8 - look for the org string in here and replace all org strings with what you saved above
 
Step 9 - save the file (my version of zip was good enough to put it back into the zip file)
 
Step 10 - Import the zip file (make a new flow up)
 
Stan

View solution in original post

1 REPLY 1
stan_gifford
Level: Powered On

Re: Converting Flow to use Dynamics 365 Prod from Sandbox

**bleep** - whenever I publish a question, five minutes later I find the solution....

 

Anyway - what needs to change is the org in the flow.

 

Step 1 - make a teeny little flow connecting to the Production Dynamics environment. I put in a simple list records on the Contacts entity.

 

Step 2 - export to json

 

Step 3 - edit (visual Studio code) and look for something like 

                                    /datasets/@{encodeURIComponent(encodeURIComponent('org8262439b.crm6'))}
 
Step 4 - copy the bit I have bolded (org8262439b)
 
Step 5 - Export the Sandbox flow as a zip file
 
Step 6 - Open the zip file and go to the directory Microsoft.Flow/Flows
 
Step 7 Edit definition.json (visual Studio Code again)
 
Step 8 - look for the org string in here and replace all org strings with what you saved above
 
Step 9 - save the file (my version of zip was good enough to put it back into the zip file)
 
Step 10 - Import the zip file (make a new flow up)
 
Stan

View solution in original post

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,735)