I have a feature which contains lists definitions, content types and site columns.
There is one site column of choice type with 10 options. I need to change type from choice to lookup and get that options from a list containing the same items as options in old column. Enabling users to add more options just by adding items to the list.

There is already some data on production so i should fill new lookup column according to old options from choice type.

Any suggestions how to do that?

3 Answers 3


There isn't a direct way.

I would use feature upgrading code to create a new list with the desired valaues. Then I would add the lookup column to the list and views. Then iterate through all the list items which have a value in the choice field and set the appropriate lookup value. When complete, delete the choice column from the list and views.


Export existing data into an Excel File.

Now using feature etc. change column type to Lookup.

Now put List in Data Sheet Edit Mode. Copy paste from Excel.


1) add a new field with the lookup relationship 2) link to the table and the related table 3) create a query to update values in the first table with the values in the related where choice value = lookup value.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.