Forum Discussion
HarshPatel
Aug 22, 2024Copper Contributor
Lookup column issue while bulk upload from excel
At my organization I am working on a SharePoint list having 3 lookup columns for another list.
And to add new items in bulk I used to, open a view in quick edit mode, copy paste data from excel and worked perfectly fine.
Since a few weeks, after I guess some recent SharePoint update, when I do bulk upload, the lookup gets populated with some garbage values as hyperlink.
Initially I thought it displaying the item id from the lookup list. But it's not, it's just a long string of numbers.
Alternatively, it works perfectly fine when I open and edit the list Classic SharePoint.
Can anyone help me with this? Or is it a bug that Microsoft needs to fix?
Thanks,
Harsh
No RepliesBe the first to reply