SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a custom list on dev-int environment, now I saved it as a template and moved it over to the dev-vm environment and created a list (Listl1) based on the template. Now this list consists of few lookupfields. I have also created the needed lists in which the lookup columns resides, but when I open this Listl1 (add new item) it does not have values in the lookup fields.

So do I need to delete the column which are lookups and create new column and point to the respective lookup columns in the lookuplist? Is this the standard approach? Any suggestions?

share|improve this question
up vote 4 down vote accepted

Lookup uses internal ID to do the mapping to the lookup list. Lookup list will have different ID in the other environment which will break lookups.

Disclaimer: my answer is not based on factual knowledge, but in generic understanding of how these things tend to work in SharePoint. You will probably find the list ID used for the mapping somewhere in the lookup field properties if you look deep enough (object model) :)

share|improve this answer
This is accurate. If you go and look at the column settings in the list you can notice that where it usually displays the lookup list / column it is instead blank and this is the reason why. – SpartanDonut Feb 13 '12 at 21:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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