Multiselect options sets are one of the new features of Microsoft Dynamics 365 v9. I am now often getting requests to ‘convert’ existing options sets to the new multiselect options sets.
Strictly speaking, it is impossible to convert an old-style, single selection option set to a multi select option set. However, although not straightforward, it is possible to achieve this.
Previously, when I have changed the type of a field, e.g. from a text field to an option set field, I have migrated the data pretty simply, using either bulk edit or workflow. However, neither of these techniques work.
When trying to bulk edit a set of records, the multi-select option set field are not available to change. In workflow, the fields do not show to use in the update record step.
The technique that did work was a data update using the data import wizard.
I only had to set one value in each of the multi-select option sets – the value from the original option set. The multiselect is required for future use.
Another challenge that I encountered while doing the data import was that I could only import the data file from my downloads directory. If I moved the file into the client folder, Dynamics 365 told me that the file was corrupt.
Once you have completed the migration, and it has been confirmed as correct, there is probably no advantage in keeping the original field.
As a minimum, I would make the original field non-searchable, so it does not confuse users.
If it is a custom field, and you do want to completely remove it, check the dependencies of the field. Typically, you will need to:
The dependencies of the original option set field will point you in the right direction to achieve this quickly.
So although there is no simple tickbox to make an option set into a multiselect option set, it is possible and it is pretty straightforward.
Opsis is an expert Microsoft Dynamics 365 consulting company. Our focus is your Microsoft Dynamics 365 success - not licence sales or billable hours. As Principal Consultant, Gill oversees all business operations and strategic planning and execution, yet she still believes in offering personal attention to each and every client, so as to understand their needs and offer tailored solutions. We are based in Sydney, with clients in Sydney, Canberra, Melbourne, Brisbane and across Australia. We offer Microsoft Dynamics 365 strategy, Microsoft Dynamics 365 scoping, Microsoft Dynamics 365 implementation, Microsoft Dynamics 365 technical support, Microsoft Dynamics 365 advice and guidance, Microsoft Dynamics 365 training and mentoring.