Hello, I am migrating a list containing lookup columns from on-premises to SPO using SPMT. As per this article , it looks like lookup columns are supported in SPMT with the option to migrate all referenced lists. In my case, I am migrating the child and parent lists under same site in SPO. Also, the parent list is migrated first and then trying to migrate the child list using SPMT. However, under list settings the lookup columns seems to be broken and values are not showing up in child list in SPO. Hence, fixed the lookup column first using this script . After fixing as well, it is not picking the values from parent list. Is there any way to get the values for lookup columns for all items in child list in SPO or entering manually is the only way? Thanks

@Anjana R Per my test, in the migration settings, please set "Migrated all lists referenced in lookup columns". And you just need to migrate the child list to SharePoint Online, then the parent list will automatically be migrated to SharePoint Online. After migration, you could choose lookup column values in the child list. If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 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.

Lookup columns in SPO - Microsoft Q&A

Accepted answer

Emily Du-MSFT 45,586 Reputation points Microsoft Vendor

2022-01-11T09:09:27.793+00:00

@Anjana R

Per my test, in the migration settings, please set "Migrated all lists referenced in lookup columns".

And you just need to migrate the child list to SharePoint Online, then the parent list will automatically be migrated to SharePoint Online.

After migration, you could choose lookup column values in the child list.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.
Please sign in to rate this answer.

1 person found this answer helpful.
Anjana R 156 Reputation points

2022-01-11T14:14:13.163+00:00

@Emily Du-MSFT - Thanks for your response

Does that mean after migration we have to select the values for lookup columns manually for each of the items in child list? Is that by design or any way to link the lookup column values to the items automatically?

Emily Du-MSFT 45,586 Reputation points Microsoft Vendor

2022-01-13T08:59:47.217+00:00

@Anjana R

Before migration, if you have filled in values of lookup column, after migration, values of lookup column also be migrated.

Anjana R 156 Reputation points

2022-01-14T05:02:09.797+00:00

@Emily Du-MSFT - Whether this will work if we have multiple lists (3 or 4 lists) with lookup columns on each dependent on other list? For e.g. suppose if we have have Lists named A, B,C and D wherein B has lookup on A, D has lookup on B and C has lookup on D. In this case, migrating child list C will migrate all the dependent lists A,B and D with the above option selected in SPMT tool along with its values?

Emily Du-MSFT 45,586 Reputation points Microsoft Vendor

2022-01-18T02:54:52.157+00:00

@Anjana R

I have tested the assumption you proposed that have multiple lists with lookup columns.

After migrating list C, list A,B,D and values of lookup columns in the list A,B,D also be migrated.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Emily Du-MSFT 45,586 Reputation points Microsoft Vendor

2022-01-21T11:11:49.147+00:00

@Anjana R

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

Anjana R 156 Reputation points

2022-02-09T01:49:49.063+00:00

@Emily Du-MSFT - Thanks for testing this out.

In my case it didn't work out. I will try again.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Lookup columns in SPO

0 additional answers

Your answer