I have simple Sharepoint list named Alist with lookup value column.

the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup value disappeared, after I restored Blist but in Alist lookup values didn't restored.

is there some way to restore lookup values in Alist?

  • Have you enabled versioning in Alist? Have you any backups? Commented Jan 8, 2019 at 12:23
  • no, version is not enabled and what type of backup do you mean? Commented Jan 8, 2019 at 12:32
  • Backup with DPM or some backing up program? The information is saved in List[ID] and because you haven't set that this is cascade lookup and you cannot delete this, so when you delete listB the values dissapear. > so you need backup of SharePoint for restore this values, otherwise you must set this manually again. Commented Jan 8, 2019 at 12:34
  • It's separate program. You have your own SharePoint or in some company? Ask infrastructure of application manager.. Commented Jan 8, 2019 at 12:46
  • I backup my sharepoint Blist but in A list there is no any lookup value. if I edit lookup column there is written "Get information from:" and no more information Commented Jan 8, 2019 at 14:33

1 Answer 1


ListB has now different GUID than the original one. GUID is used at ListA for referencing (original) ListB. You need to change referencing ListB GUID from ListA - this can be done but is a bit hard to do.

  • First, check out new ListB GUID Reference.
  • Save ListA as template (with content), save it on disk (stp packet)
  • rename *.stp to *.zip & unpack it.
  • from manifest.xml find the original referenced column and it's list GUID, change it to new ListB GUID
  • zip manifest.xml and rename *.zip to *.stp
  • upload file to list templates.
  • Create new list (new 'ListA') from this template -> reference should work now.

Have done this couple of times and it works.

  • It seems good way, now I got manifest.xml file so how can I find original referenced column and it's list GUID? Commented Jan 11, 2019 at 7:51
  • it is very good way but instance of .zip I have to do it with .cab, thank you Commented Jan 14, 2019 at 11:37
  • the stp file needs to be packaged using the command makecab.exe manifest.xml mytemplatename.stp chayadigital.wordpress.com/2011/08/05/… Commented Nov 21, 2020 at 17:53

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.