Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Note    This feature is in General Availability (GA) in the Microsoft 365 Monthly Release Channel as of May 2022. If you are on the Microsoft Semi-annual Enterprise Channel, it is available in December 2022. For more information on how to participate, see

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.

    Creating a Choice Field

  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:

    Specifying two columns

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

    Entering the three choices

  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:

    Displaying the list of choices to a user

  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.

    Displaying of choices in Dataverse UI

  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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!