Requirement:- we need to convert a multi-select picklist value into single select picklist value.if We change the Multiselect to Single .how we can avoid data loss

  • If there is record that currently have 3 picklist values, how do you want to convert it into single value?
    – Liron C
    Nov 3, 2016 at 4:55
  • Yes that is the business requirement.I already Explained its not possible ,but posted for any solution/workaround.
    – dem
    Nov 3, 2016 at 4:59
  • You can suggest that in case record have more than 1 picklist value, then you will put there only first value (after changing it single picklist). If it's fine, use the solution Sharvan suggest below. If it's not, require conversion logic from the person who raise the requirement
    – Liron C
    Nov 3, 2016 at 5:04

1 Answer 1


We will be losing data if Changing from multi Picklist to any other type. It's not possible to avoid while conversion but we can do with apex data loader with minimal risk.

  1. Take a backup
  2. convert to picklist
  3. Remove multi select to single value in csv file with respect to your requirement
  4. upload into salesforce.

documentation Link

  • Now the Requirment is The Value listed First in Mulitselect for perticular record needs to be set in single Picklist after Changing to Single Picklist. Is there any option to set fist value in record when we convert multi select to single picklist.Please suggest
    – dem
    Nov 3, 2016 at 6:03
  • you have to play with csv file. it's not possible in salesforce
    – S B
    Nov 3, 2016 at 6:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .