Create a choice field for migration to Dataverse

If you want to migrate an Access Multivalued field to a Dataverse Choices field, here’s how to create it in Access so the operation is successful.

1. In the navigation pane, right-click the Table name, and then select Design View.

2. Under Field Name, in the first available blank box, enter a name, such as "ChoiceField".

3. Under Data Type, on the right of the field name you just entered, select Number from the drop-down list.

4. Select the same drop-down list, and then select Lookup Wizard.
   
   

5. On the first page of the Lookup Wizard, select I will type in the values that I want, and then select Next.

6. On the second page of the Lookup Wizard, in the Number of columns box, enter 2.

7. In the boxes under Col1 and Col2, enter the following values:
   
   

8. Between the Col1 and Col2 headers, select the separator  and drag it all the way to the left so that only Col2 appears.
   
   

9. To finish the Lookup Wizard, select Next > Next > Finish.

10. Right-click the table name header, and then select Save.

11. Right-click the table name header, and then select Datasheet View.

12. Create a few records to confirm the ChoiceField works as expected:
    
    

13. Right-click the table name header, select Close, and then confirm the operation.

14. In the navigation pane, right-click the table name, and then select Export > Dataverse.

15. Follow the steps to migrate the table to Dataverse. Make sure you select the option Open the Dataverse table URL when finished.
    
    For more information, see Migrate Access data to Dataverse.

16. After successful completion of the migration, Dataverse opens the table. On the top right, select Active <Table Name> > All Columns.

17. Locate the ChoiceField in the list of columns.
    
    

18. In Access, make some changes to the data and then select Home > Refresh All.

19. Switch back to the Dataverse view in step 17, and then select Refresh Data to see the updated data on the page.