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?
Error when migrating sharepoint list contains lookup field
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.