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

​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  Read More

​