Content Type & Metadata retained in a files coming from a different site collection or tenant

%3CLINGO-SUB%20id%3D%22lingo-sub-2312390%22%20slang%3D%22en-US%22%3EContent%20Type%20%26amp%3B%20Metadata%20retained%20in%20a%20files%20coming%20from%20a%20different%20site%20collection%20or%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312390%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EWe%20noticed%20that%20files%20coming%20as%20email%20attachments%20from%20different%20site%20collections%20or%20tenants%20retain%20content%20type%20and%20metadata.%20When%20users%20save%20the%20file%20to%20a%20local%20SharePoint%20Library%20it%20auto%20assigns%20a%20content%20type%20(since%20the%20source%20CT%20doesn't%20exist%20in%20their%20library).%20Is%20there%20a%20method%20to%20prevent%20this%20from%20happening%3F%20We%20are%20not%20interested%20in%20enabling%20a%20Content%20Hub%2C%20only%20saving%20the%20document%20as-is%20and%20applying%20our%20existing%20content%20type%20and%20metadata.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313120%22%20slang%3D%22en-US%22%3ERe%3A%20Content%20Type%20%26amp%3B%20Metadata%20retained%20in%20a%20files%20coming%20from%20a%20different%20site%20collection%20or%20tenan%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F269073%22%20target%3D%22_blank%22%3E%40AlbertSP%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EThis%20is%20unfortunately%20expected%20behaviour.%20The%20%22files%22%20are%20probably%20Office%20file%20formats%20such%20as%20docx%2C%20xlsx%2C%20pptx%20etc..%3CBR%20%2F%3EThe%20%22files%22%20contain%20the%20CT%20and%20metadata%20details%20from%20the%20source%20in%20the%20file%20itself.%20When%20such%20a%20file%20is%20uploaded%20to%20a%20different%20site%20the%20property%20promotion%20kicks%20in%20and%20tries%20to%20extract%20the%20metadata%20from%20the%20file%20and%20capture%20that%20into%20SharePoint%20columns%20in%20the%20target%20destination.%3CBR%20%2F%3EAlternatives%3A%20not%20really%20viable%20I%20am%20afraid.%3CBR%20%2F%3E-%20after%20downloading%20open%20the%20files%20in%20the%20client%20App%20(e.g.%20Word)%20and%20remove%20the%20properties%3CBR%20%2F%3E-%20disabling%20property%20promotion%20(this%20may%20not%20work%20on%20SharePoint%20Online)%3CBR%20%2F%3E-%20use%20Power%20Automate%20in%20your%20target%20system%20to%20erase%20metadata%3CBR%20%2F%3EI%20am%20not%20aware%20of%20tools%20that%20can%20strip%20metadata%20from%20Office%20files%20during%20uploading%2Fdownloading.%3CBR%20%2F%3EPaul%20%7C%20SLIM%20Applications%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,
We noticed that files coming as email attachments from different site collections or tenants retain content type and metadata. When users save the file to a local SharePoint Library it auto assigns a content type (since the source CT doesn't exist in their library). Is there a method to prevent this from happening? We are not interested in enabling a Content Hub, only saving the document as-is and applying our existing content type and metadata. 

2 Replies

@AlbertSP 
This is unfortunately expected behaviour. The "files" are probably Office file formats such as docx, xlsx, pptx etc..
The "files" contain the CT and metadata details from the source in the file itself. When such a file is uploaded to a different site the property promotion kicks in and tries to extract the metadata from the file and capture that into SharePoint columns in the target destination.
Alternatives: not really viable I am afraid.
- after downloading open the files in the client App (e.g. Word) and remove the properties
- disabling property promotion (this may not work on SharePoint Online)
- use Power Automate in your target system to erase metadata
I am not aware of tools that can strip metadata from Office files during uploading/downloading.
Paul | SLIM Applications

@Paul_HK_de_Jong 

 

Correct, those are MS office files.
Thank you for your suggestions