Jun 01 2021 03:35 PM
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!
Jun 01 2021 10:22 PM
Mar 24 2023 01:50 AM
Jun 12 2023 11:43 PM
How about defaulting the required content type in list settings and then create a separate view as datasheet view to import data. Don't add content type column in this view.
Normally when importing data in edit view mode it automatically takes the default content type.
It's just a work around and to avoid bringing data row by row manually.