Forum Discussion

HarshPatel's avatar
HarshPatel
Copper Contributor
Aug 22, 2024

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

Resources