Edit a list in grid view with content types

%3CLINGO-SUB%20id%3D%22lingo-sub-2406192%22%20slang%3D%22en-US%22%3EEdit%20a%20list%20in%20grid%20view%20with%20content%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2406192%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Enot%20sure%20if%20I%20am%20at%20the%20right%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20some%20guidance%20in%20a%20problem%20I%20am%20facing%20with%20my%20Sharepoint%20implementation%20and%20I%20can't%20find%20any%20relevant%20information%20about%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20with%206%20different%20content%20types%2C%20and%20each%20content%20type%20has%20a%20distinct%20structure%2C%20with%20unique%20columns%20and%20shared%20columns%20among%20the%20other%20content%20types.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20when%20I%20try%20to%20edit%20this%20list%20in%20grid%20view%20(since%20I%20need%20to%20import%20data%20from%20my%20previous%20system%20using%20copy%20%2F%20past%20from%20Excel)%2C%20SharePoint%20doesn't%20me%20allow%20to%20fill%20in%20the%20Content%20Type%20column%20(saying%20it's%20a%20read-only%20one)%2C%20and%20therefore%20I%20am%20not%20able%20to%20define%20previously%20what%20are%20the%20fields%20that%20are%20relevant%20for%20the%20specific%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20create%20a%20view%20with%20all%20the%20existing%20columns%2C%20and%20to%20fill%20in%20the%20columns%20from%20that%20specific%20item%20but%20I%20didn't%20succeed%20as%20Sharepoint%20started%20asking%20me%20to%20fill%20in%20other%20columns%20apparently%20mandatory%20(although%20not%20for%20that%20specific%20item%20%2F%20content%20type)%2C%20and%20at%20the%20end%20it%20created%20an%20item%20with%20another%20content%20type.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20import%20an%20item%20from%20a%20list%20with%20several%20content%20types%20using%20the%20EDIT%20IN%20GRID%20VIEW%20mode%3F%20I%20used%20successfully%20this%20method%20previously%20in%20another%20list%2C%20but%20with%20only%20one%20content%20type...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20avoid%20create%20the%20items%20one%20by%20one%3F%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20the%20best!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2406192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2406775%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20a%20list%20in%20grid%20view%20with%20content%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2406775%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EMy%20guess%20here%20is%20that%20the%20Grid%20View%20is%20not%20well%20prepared%20for%20the%20scenario%20you%20are%20mentioning%20here%20and%20there%20is%20not%20a%20direct%20and%20intuitive%20way%20to%20achieve%20what%20you%20need%20here%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone!

 

not sure if I am at the right place.

 

I am looking for some guidance in a problem I am facing with my Sharepoint implementation and I can't find any relevant information about it.

 

I have a list with 6 different content types, and each content type has a distinct structure, with unique columns and shared columns among the other content types.

 

My problem is when I try to edit this list in grid view (since I need to import data from my previous system using copy / past from Excel), SharePoint doesn't me allow to fill in the Content Type column (saying it's a read-only one), and therefore I am not able to define previously what are the fields that are relevant for the specific item.

 

I tried to create a view with all the existing columns, and to fill in the columns from that specific item but I didn't succeed as Sharepoint started asking me to fill in other columns apparently mandatory (although not for that specific item / content type), and at the end it created an item with another content type.

 

How can I import an item from a list with several content types using the EDIT IN GRID VIEW mode? I used successfully this method previously in another list, but with only one content type...

 

Is there any way to avoid create the items one by one? :(

 

All the best!

 

1 Reply
Hi,
My guess here is that the Grid View is not well prepared for the scenario you are mentioning here and there is not a direct and intuitive way to achieve what you need here