Importing partial data into a custom Sharepoint Online list

%3CLINGO-SUB%20id%3D%22lingo-sub-1470933%22%20slang%3D%22en-US%22%3EImporting%20partial%20data%20into%20a%20custom%20Sharepoint%20Online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470933%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20see%20if%20there%20are%20any%20OOTB%2Fno%20code%20solutions%20for%20the%20following.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20custom%20list%20that%20was%20built%20for%20the%20purposes%20of%20auditing%20a%20file.%26nbsp%3B%20The%20custom%20list%20has%20about%2010%20questions%20that%20are%20single%20lines%20of%20text%20(indicative%20data%20from%20the%20source%20system)%20then%20follows%20yup%20with%20about%2020%20choice%20questions%20about%20how%20the%20file%20was%20handled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20associates%20are%20looking%20to%20not%20have%20to%20key%20in%20the%20indicative%20data%20to%20save%20time.%20Is%20there%20anyway%20I%20can%20upload%20data%20into%20those%20first%2010%20fields%2C%20(which%20is%20creating%20new%20items)%20but%20keep%20the%20remaining%2020%20choice%20questions.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20currently%20moving%20from%20on-prem%202013%20to%20online%20-%20so%20i%20thought%20maybe%20I%20could%20park%20an%20export%20of%20the%20list%20in%20a%20sp%20online%20document%20library%20on%20the%20same%20site%20and%20update%20the%20list%20in%20excel%20and%20it%20would%20sync%20back%20to%20the%20list%20-%20but%20that%20didnt%20work%20-%20guess%20a%20girl%20can%20dream.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20how%20I%20can%20accomplish%20this%2C%20and%20if%20its%20even%20possible%20would%20be%20appreciated.%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1470933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Greetings, 

 

I am looking to see if there are any OOTB/no code solutions for the following. 

 

I have a custom list that was built for the purposes of auditing a file.  The custom list has about 10 questions that are single lines of text (indicative data from the source system) then follows yup with about 20 choice questions about how the file was handled.

 

The associates are looking to not have to key in the indicative data to save time. Is there anyway I can upload data into those first 10 fields, (which is creating new items) but keep the remaining 20 choice questions. 

 

We currently moving from on-prem 2013 to online - so i thought maybe I could park an export of the list in a sp online document library on the same site and update the list in excel and it would sync back to the list - but that didnt work - guess a girl can dream.  

 

Any thoughts on how I can accomplish this, and if its even possible would be appreciated.

Thank you!

1 Reply
Highlighted

@DonnaJ415 : try quick edit mode and paste data from excel.