Forum Discussion
jhammons
Aug 07, 2023Copper Contributor
Sharepoint Document Library Columns Data Populates Random Information
I created a sharepoint document library. The default column data has no defaults set and should be blank. However, anytime a document is drag/dropped into the document folder; the column populates ...
ganeshsanap
Aug 07, 2023MVP
jhammons Check if your documents have file properties associated with them which are populating column data in SharePoint library.
Open your excel file > click on File menu at the top left corner > select Info > check Properties section at the right hand side.
Similar like this: Can I map the word document properties inside SharePoint document library
If you have same properties like your document library columns, you will have to remove those properties from file before uploading to SharePoint.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- jhammonsAug 07, 2023Copper ContributorThere is nothing in the information properties. It copies the column data from the last "edit in grid view" change is what it appears. I might use PowerAutomate to just clear the values but I feel like this is just a work around a problem in Sharepoint.
- jhammonsAug 07, 2023Copper ContributorI originally posted the issue here with screen shots https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-document-library-error-when-drag-drop-files/m-p/3892922/emcs_t/S2h8ZW1haWx8dG9waWNfc3Vic2NyaXB0aW9ufExMMFlCWU05RDE2QVg0fDM4OTI5MjJ8U1VCU0NSSVBUSU9OU3xoSw#M73419