SOLVED

Copying files with column data preserved

%3CLINGO-SUB%20id%3D%22lingo-sub-1179406%22%20slang%3D%22en-US%22%3ECopying%20files%20with%20column%20data%20preserved%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179406%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20company%20I%20work%20at%20has%20one%20document%20library%20which%20stores%20current%20working%20files%20and%20another%20library%20which%20is%20an%20archive%20of%20past%20working%20files%2C%20these%20are%20usually%20pdfs%20which%20have%20properties%20such%20as%20revision%20number%2C%20document%20ID%20(internal%20document%20notation)%2C%20approved%20by%2C%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20added%20the%20same%20columns%20to%20the%20archive%20library%20and%20tried%20to%20copy%20a%20file%20from%20the%20original%20library%20to%20the%20archive%20library%2C%20but%20the%20only%20column%20data%20that%20is%20preserved%20from%20the%20original%20library%20is%20the%20Revision%2C%20for%20some%20reason%2C%20although%20all%20of%20the%20other%20columns%20come%20in%20the%20same%20order%20and%20have%20the%20same%20exact%20names%20and%20data%20types.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20also%20tried%20to%20create%20a%20flow%20for%20this%2C%20but%20I%20have%20the%20same%20problem%20and%20am%20not%20managing%20to%20use%20the%20copy%20file%20properties%20action%20because%20I'm%20not%20very%20proficient%20in%20Power%20Automate.%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anyone%20have%20a%20solution%20to%20this%2C%20or%20maybe%20know%20what%20I'm%20doing%20wrong%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1179406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1179582%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20files%20with%20column%20data%20preserved%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179582%22%20slang%3D%22en-US%22%3EIf%20my%20memory%20serves%20well%2C%20this%20is%20expected%20when%20copying%20files.%20If%20you%20move%20the%20files%20and%20the%20columns%20at%20the%20destination%20are%20exactly%20te%20same%2C%20then%20the%20metadata%20and%20versions%20should%20be%20copied%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmove-or-copy-files-in-sharepoint-00e2f483-4df3-46be-a861-1f5f0c1a87bc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmove-or-copy-files-in-sharepoint-00e2f483-4df3-46be-a861-1f5f0c1a87bc%3C%2FA%3E%3C%2FLINGO-BODY%3E
Visitor

The company I work at has one document library which stores current working files and another library which is an archive of past working files, these are usually pdfs which have properties such as revision number, document ID (internal document notation), approved by, and so on.

 

I've added the same columns to the archive library and tried to copy a file from the original library to the archive library, but the only column data that is preserved from the original library is the Revision, for some reason, although all of the other columns come in the same order and have the same exact names and data types. 

 

I've also tried to create a flow for this, but I have the same problem and am not managing to use the copy file properties action because I'm not very proficient in Power Automate.

Does anyone have a solution to this, or maybe know what I'm doing wrong? 

Thank you!

1 Reply
Best Response confirmed by thea_dahlberg (Visitor)
Solution
If my memory serves well, this is expected when copying files. If you move the files and the columns at the destination are exactly te same, then the metadata and versions should be copied https://support.office.com/en-us/article/move-or-copy-files-in-sharepoint-00e2f483-4df3-46be-a861-1f...