Forum Discussion
Share Point List Copy not maintaining Createdby
- Feb 17, 2020You 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.
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
- dmhcoFeb 14, 2020Copper Contributor
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!
- RobElliottFeb 16, 2020Silver Contributor
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:
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:
Rob
Los Gallardos
Microsoft Power Automate Community Super User