SharePoint Online document library - original metadata lost when replacing documents

%3CLINGO-SUB%20id%3D%22lingo-sub-2140028%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20document%20library%20-%20original%20metadata%20lost%20when%20replacing%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2140028%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EMy%20issue%20is%20that%20when%20replacing%2Fdrag%26amp%3Bdroping%20the%20document%20with%20an%20exact%20name%2C%20the%20metadata%20that%20was%20originally%20there%20gets%20all%20wiped%20out%2C%20and%20I%20end%20up%20re-applying%20all%20of%20them.%20Also%2C%20the%20behavior%20is%20inconsistent.%20In%20some%20other%20document%20libraries%2C%20after%20replacing%20the%20document%20and%20losing%20the%20metadata%20values%2C%20I%20re-apply%20a%20value%20in%20one%20column%2C%20and%20then%20SPO%20auto-fills%20other%20fields%20to%20match%20the%20lost%20metadata%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20ideas%20why%20it%20happens%20and%20how%20to%20fix%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERhea%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2140028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMetadata%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMetatags%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2245303%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20document%20library%20-%20original%20metadata%20lost%20when%20replacing%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2245303%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782835%22%20target%3D%22_blank%22%3E%40Rie0205%3C%2FA%3E%20-%20I%20have%20a%20guess.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20save%20an%20Office%20file%20in%20a%20SharePoint%20library%20that%20has%20custom%20metadata%2C%20that%20information%20is%20embedded%20within%20the%20document.%20You%20can%20see%20this%20by%20downloading%20a%20file%20(which%20has%20custom%20metadata%20in%20the%20columns%20for%20it)%2C%20changing%20its%20name%2C%20and%20then%20uploading%20it%20back%20to%20that%20same%20library%20(or%20another%20library%20with%20the%20columns%20of%20the%20same%20name).%20The%20original%20metadata%20will%20appear%20in%20the%20library's%20columns.%3CBR%20%2F%3E%3CBR%20%2F%3ESO%2C%20my%20guess%20is%20that%20you%20are%20uploading%20a%20file%20that%20was%20stored%20in%20a%20library%20with%20metadata%20columns%20with%20the%20same%20name%20as%20the%20library%20you're%20uploading%20the%20file%20to.%20These%20are%20embedded%20within%20your%20file%20as%20blank%20and%20those%20values%20then%20overwrite%20the%20metadata%20columns%20when%20you%20upload%20it.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

My issue is that when replacing/drag&droping the document with an exact name, the metadata that was originally there gets all wiped out, and I end up re-applying all of them. Also, the behavior is inconsistent. In some other document libraries, after replacing the document and losing the metadata values, I re-apply a value in one column, and then SPO auto-fills other fields to match the lost metadata values.

 

Does anyone have any ideas why it happens and how to fix it?

 

Thank you,

Rhea

1 Reply
Hi @Rie0205 - I have a guess.

When you save an Office file in a SharePoint library that has custom metadata, that information is embedded within the document. You can see this by downloading a file (which has custom metadata in the columns for it), changing its name, and then uploading it back to that same library (or another library with the columns of the same name). The original metadata will appear in the library's columns.

SO, my guess is that you are uploading a file that was stored in a library with metadata columns with the same name as the library you're uploading the file to. These are embedded within your file as blank and those values then overwrite the metadata columns when you upload it.