Sharepoint list - copy/paste rows with lookup column in Quick Edit / Grid View

New Contributor

I'm trying to copy/paste new rows into an existing SP list - the first column is a look-up column.

I noticed a few changes to the list:

  • It no longer shows 'Quick Edit View' - it now shows 'Edit in Grid View'
  • Copying and pasting the data will happen - but an error will appear in the first row with error '#err"
  • The above point then prevents any loading of new rows

I tried to manually create a new row in 'Edit in Grid View'. I'll select an entry in the lookup column - but it will not save the new row. 


Interestingly, if I click 'do not save changes' - it will actually save that (first) row.


Can anyone help?

0 Replies