SOLVED

Share Point List Copy not maintaining Createdby

%3CLINGO-SUB%20id%3D%22lingo-sub-1174300%22%20slang%3D%22en-US%22%3EShare%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174300%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20copying%20a%20share%20point%20list%20from%20one%20to%20another%2C%20the%20original%20createdby%20is%20being%20replaced%20with%20my%20name.%20How%20can%20the%20original%20createdby%20be%20preserved%20on%20the%20new%20list%20it%20is%20copied%20to%3F%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1174300%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-1174405%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174405%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557913%22%20target%3D%22_blank%22%3E%40dmhco%3C%2FA%3E%26nbsp%3BThat's%20working%20as%20intended.%20Copying%20lists%20creates%20a%20new%20copy%20of%20the%20item%20and%20therefore%20you're%20creating%20a%20new%20item.%20The%20only%20way%20to%20get%20around%20this%20would%20be%20to%20use%20PnP%20PowerShell%20where%20you%20could%20force%20the%20CreatedBy%20to%20stay%20the%20same%2C%20or%20use%20a%20migration%20tool%20such%20as%20ShareGate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1174424%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557913%22%20target%3D%22_blank%22%3E%40dmhco%3C%2FA%3E%26nbsp%3Bthis%20isn't%20possible%2C%20you'd%20need%20to%20have%20a%20separate%20column%20on%20on%20your%20lists%2C%20perhaps%20called%20Original%20Created%20By%2C%20and%20copy%20the%20CreatedBy%20into%20that%26nbsp%3Bbefore%20you%20copied%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1174596%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174596%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20confirmation.%20Do%20you%20know%20if%20the%20copy%20of%20Createdby%20can%20be%20done%20by%20just%20adding%20a%20new%20column%3F%20I%20tried%20using%20a%20calculated%20column%20but%20CreatedBy%20is%20not%20one%20of%20the%20picklist%20options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20limited%20in%20my%20options%20of%20getting%20that%20information%20copied%20over%20(cannot%20do%20it%20via%20code%2C%20macro%2C%20or%20designer%20workflow).%20Any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176114%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557913%22%20target%3D%22_blank%22%3E%40dmhco%3C%2FA%3E%26nbsp%3Bnot%20automatically%2C%20you'd%20either%20need%20to%20go%20into%20Quick%20Edit%20select%20all%20the%20items%20in%20the%20Created%20By%20column%2C%20copy%20them%20then%20paste%20them%20into%20the%20new%20column%20in%20the%20same%20way%20you%20would%20if%20it%20was%20Excel%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22QuickEdit-%20originalCreatedBy.png%22%20style%3D%22width%3A%20820px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171421iBB7DC2CD8CEF35DA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22QuickEdit-%20originalCreatedBy.png%22%20alt%3D%22QuickEdit-%20originalCreatedBy.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20if%20the%20list%20has%20many%20thousands%20of%20items%20you%20could%20run%20a%20simple%20flow%20in%20Power%20Automate%20as%20a%20one-off%20to%20copy%20the%20Created%20By%20column%20of%20each%20item%20to%20the%20new%20column%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22originalCreatedBy.png%22%20style%3D%22width%3A%20861px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171422i128DC90CEB1725B2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22originalCreatedBy.png%22%20alt%3D%22originalCreatedBy.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177981%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177981%22%20slang%3D%22en-US%22%3EYou%20are%20talking%20about%20migrating%20a%20list%20to%20another%20site%20which%20means%20you%20need%20a%20migration%20tool%20to%20that%20if%20you%20want%20to%20keep%20the%20proper%20metadata%20for%20the%20list.%3CBR%20%2F%3E%3CBR%20%2F%3EUsing%20a%20second%20%22created%20by%20%22%20column%20is%20only%20going%20to%20create%20headaches%20as%20you%20move%20forward.%20How%20will%20it%20be%20maintained%3F%20How%20will%20users%20know%20which%20%22created%20by%22%20column%20to%20use%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20do%20it%20right%20the%20first%20time%20and%20use%20a%20migration%20tool.%20If%20you%20don't%20have%20one%2C%20your%20IT%20department%20will.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178028%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F57004%22%20target%3D%22_blank%22%3E%40Rachel%20Davis%3C%2FA%3E%26nbsp%3BNot%20sure%20I%20entirely%20agree.%20Users%20can't%20do%20anything%20with%20the%20Created%20By%20column%20so%20don't%20need%20to%20decide%20which%20to%20use%2C%20and%20they%20possibly%20don't%20need%20to%20interact%20with%20the%20OriginalCreatedBy%20column.%20I%20work%20in%20the%20IT%20department%20of%20a%20company%20of%2065%2C000%20staff%20and%20we%20don't%20have%20a%20migration%20tool%20other%20than%20Microsoft's%20own%20(which%20doesn't%20maintain%20the%20created%2Fcreated%20by%20info).%20But%20if%20you%20do%20want%20to%20look%20at%20a%20tool%20with%20a%20good%20reputation%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557913%22%20target%3D%22_blank%22%3E%40dmhco%3C%2FA%3E%26nbsp%3Bthen%20ShareGate%20seems%20to%20be%20very%20good.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184581%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20Point%20List%20Copy%20not%20maintaining%20Createdby%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184581%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20the%20insightful%20responses.%20After%20reviewing%20options%2C%20decided%20to%20go%20with%20ShareGate%20approach%20as%20that%20best%20fit%20the%20needs%20of%20our%20specific%20scenario.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

When copying a share point list from one to another, the original createdby is being replaced with my name. How can the original createdby be preserved on the new list it is copied to?

Thank you!

7 Replies
Highlighted

@dmhco That's working as intended. Copying lists creates a new copy of the item and therefore you're creating a new item. The only way to get around this would be to use PnP PowerShell where you could force the CreatedBy to stay the same, or use a migration tool such as ShareGate.

Highlighted

@dmhco this isn't possible, you'd need to have a separate column on on your lists, perhaps called Original Created By, and copy the CreatedBy into that before you copied the list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

Thank you for the confirmation. Do you know if the copy of Createdby can be done by just adding a new column? I tried using a calculated column but CreatedBy is not one of the picklist options.

 

I am limited in my options of getting that information copied over (cannot do it via code, macro, or designer workflow). Any suggestions?

 

Thank you!

Highlighted

@dmhco not automatically, you'd either need to go into Quick Edit select all the items in the Created By column, copy them then paste them into the new column in the same way you would if it was Excel:

 

QuickEdit- originalCreatedBy.png

 

Or if the list has many thousands of items you could run a simple flow in Power Automate as a one-off to copy the Created By column of each item to the new column:

 

originalCreatedBy.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted
Best Response confirmed by dmhco (New Contributor)
Solution
You are talking about migrating a list to another site which means you need a migration tool to that if you want to keep the proper metadata for the list.

Using a second "created by " column is only going to create headaches as you move forward. How will it be maintained? How will users know which "created by" column to use?

I would do it right the first time and use a migration tool. If you don't have one, your IT department will.
Highlighted

@Rachel Davis Not sure I entirely agree. Users can't do anything with the Created By column so don't need to decide which to use, and they possibly don't need to interact with the OriginalCreatedBy column. I work in the IT department of a company of 65,000 staff and we don't have a migration tool other than Microsoft's own (which doesn't maintain the created/created by info). But if you do want to look at a tool with a good reputation @dmhco then ShareGate seems to be very good.

 

Rob
Los Gallardos

Highlighted

Thank you for the insightful responses. After reviewing options, decided to go with ShareGate approach as that best fit the needs of our specific scenario.