Is it possible to import data to multiselect option sets in D365?
I.ex. we have fields on an Account that allow selecting multiple elements in one list of interests.
It would be ideal to import this multiselect optionset list as the customer has about 800 account they want imported.
Thank you, i will try this out :)
Hi Thomas,
Yes, we can import multiselect option sets in D365.
Please refer to https://www.inogic.com/blog/2017/11/import-data-with-multi-select-option-set-values-in-dynamics-365-v9/
First create a personal view that contains all Accounts need to be imported, add the multiselect option sets field as a column. Export to Excel > Static Worksheet.
Then edit the Excel, enter the data into the multiselect option sets field column. Values of multiselect option sets field are separated by semicolons, like "interestA;interestB;interestC".
Finally import the Excel to D365.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156