I'm migrating a list up a level from the site to the site collection. After migrating the list via list template, I need to move the data from the Lookup to the new Filtered lookup field on the same list. (so I can delete the original list).

When trying to copy/paste the date in datasheet view, I found that it's a read only field. Is there a way to do this with just COTS abilities?


  • What do you mean by "filtered" lookup?
    – Christophe
    Mar 21, 2012 at 20:28
  • a filtered lookup as in a lookup column that is able to search the entire site collection for information, and not only the current site
    – hrezs
    Mar 21, 2012 at 21:02
  • Maybe you'll need to be more specific in your question. It seems that you are using a third party tool, not an out of the box feature.
    – Christophe
    Mar 21, 2012 at 21:10
  • Copy/Paste from when creating a new column for a List Lookup (information already on this site) Filtered Lookup (Information from all sites in site collection
    – hrezs
    Mar 21, 2012 at 21:11
  • I'm sure copying the information between two standard lookup columns would also work for coping from a lookup to a filtered lookup. I am using SharePoint 2010, I don't have experience with older versions, so a filtered lookup could be a new feature?
    – hrezs
    Mar 21, 2012 at 21:15

1 Answer 1


I am not sure what you mean by filtered lookup. But keep in mind that a regular lookup field is actually a combination of an id and text. For example: 35;#LookupText#

The id is the most important part, this is what will allow your lookup to stay connected if you later edit the text.

The association of id (35) and value (LookupText) is specific to the source list, and probably doesn't match what your site collection filtered lookup expects.

  • Thanks, thankfully there isn't tooooo much data to just do the migration manually
    – hrezs
    Mar 30, 2012 at 17:54

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.