Convert a List Choice Column to a Lookup Column RRS feed

  • Question

  • Needs require  to change a list column with fixed choices that have been selected to a dynamic lookup list.

    It's easy to create the new list with a lookup column, but since we have historical information already in the list Column I would prefer to change the list column type from Choice to Lookup, preserve the existing data in the column and tie the existing column to an existing sharepoint list.

    How can I do this in the most simple, straight forward way?

    Thank you

    • Edited by jmcpsd Wednesday, January 25, 2012 5:25 PM
    Wednesday, January 25, 2012 5:23 PM


  • Hi,

    I would suggest you to follow these steps:

    1. Create a list template with data from your existing list. In this way it will be safe as a backup.

    2. Use it to create a new temporray list.

    3. Now in your source list change the column type.

    Now you can add your new data and you also have a reference to your old data which you can use.

    Thanks, Rahul Rashu
    • Marked as answer by Pengyu Zhao Thursday, February 2, 2012 2:12 AM
    Wednesday, January 25, 2012 6:14 PM