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

%3CLINGO-SUB%20id%3D%22lingo-sub-1786862%22%20slang%3D%22en-US%22%3ESharepoint%20list%20-%20copy%2Fpaste%20rows%20with%20lookup%20column%20in%20Quick%20Edit%20%2F%20Grid%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786862%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20copy%2Fpaste%20new%20rows%20into%20an%20existing%20SP%20list%20-%20the%20first%20column%20is%20a%20look-up%20column.%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EI%20noticed%20a%20few%20changes%20to%20the%20list%3A%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3EIt%20no%20longer%20shows%20'Quick%20Edit%20View'%20-%20it%20now%20shows%20'Edit%20in%20Grid%20View'%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3ECopying%20and%20pasting%20the%20data%20will%20happen%20-%20but%20an%20error%20will%20appear%20in%20the%20first%20row%20with%20error%20'%23err%22%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EThe%20above%20point%20then%20prevents%20any%20loading%20of%20new%20rows%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EI%20tried%20to%20manually%20create%20a%20new%20row%20in%20'Edit%20in%20Grid%20View'.%20I'll%20select%20an%20entry%20in%20the%20lookup%20column%20-%20but%20it%20will%20not%20save%20the%20new%20row.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInterestingly%2C%20if%20I%20click%20'do%20not%20save%20changes'%20-%20it%20will%20actually%20save%20that%20(first)%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1786862%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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