'How to Export and Import Dataverse Choices between Environments

We are trying to export a Managed Solution from a Power Automate Development Envronment to a seperate Production one. On Importing the Solution it complains of :

"Import failed due to missing dependencies"

It then lists the missing dependencies and they are all Choice columns (Example):

additionalOcSignerYN cr3b4_additionalocsigneryn Choice MVV (AdditionalOcSignerYN) Column

I can see in the exported solution zip it has not included the Choice column data (simple Yes\No).

I have then installed and attempted to use the Common Data Service Configuration Migration Tool to migrate the data the Solution relies on. I have Created a Schema from the Solution, Exported the Data and then attempted to import it. It also fails to import due to the missing Choice columns. In the Schema I note that the Field that references the Global Choice schema has been included but the Choice hasn't been included.

<entities >
  <entity name="cr3b4_mvv" displayname="MVV" etc="10121" primaryidfield="cr3b4_mvvid" primarynamefield="cr3b4_mvvname" disableplugins="false">
    <fields>
      <field displayname="AdditionalOcSignerYN" name="cr3b4_additionalocsigneryn" type="optionsetvalue" customfield="true" />
    </fields>
  </entity>
</entities>

I considered recreating the Global Choices manually in Production but also noted it would create new field prefixes i.e. "cr3b4_" would be something different and hence break the import.

How do I Export and Import a Solution that references Global Choices from one environment to another please?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source