Error when migrating sharepoint list contains lookup field

Gulnar 146 Reputation points

I am trying to migrate a list that contains lookup field from local sharepoint 2013 to sharepoint online office 365, but I am getting the following error:

SharePoint on-premise list 'Department' is skipped; Reason: The list reference is broken. The lookup field 'Department type' cannot find the referred list '71e5ca71-ad37-46a6-a389-d794e96e27b6' (ErrorCode: 0x02010023)

Already the referred list that the lookup field use it to return the data from it is migrated successfully.

I am using sharepoint migraton tool.

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,202 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Shaun Brown 1 Reputation point

    In the "Department" list what kind of data is pulled from the "Department Type"? What kind of fields are being looked up?
    Also does the migrating account have access to all list and lookups involved?

    0 comments No comments

  2. Joseph Cilia 1 Reputation point

    This happens as when you migrate the lists to OnLine the list reference is changing, then when you try to migrate a list linked to that list its unable to match it. I am having the same problem, -migrate all is failing and migrate list by list is not an option due to this issue. I am stuck :(

    0 comments No comments

  3. JoyZ 18,031 Reputation points

    Hi @Gulnar ,

    Please try to migrate the whole site includes the source list and target list instead of migrating lists one by one.

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.