Forum Discussion
Moving a SP List
jonboylib no, they'll copy over when you create the new list.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
jonboylib you can create the structure of the new list from within SharePoint, then use a flow in Power Automate to copy each item from the old list to the new list. Any flows that depend on the old list will need to be updated of course.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott thank you for answering that question. I believe I understand what you are explaining. Can you tell me if the original creator of an item will migrate over when I use a flow in power automate to copy the items in the list? And if not, is there a way to change created by to another user?
Kelly_Perkins no, by default the created by column will be you rather than the original creator. If you get hold of a (rather expensive product) called ShareGate to migrate the list the created by column is preserved. If you don't have ShareGate you can still change the creator to someone else with a flow in Power Automate, but it would need to be done for every item using a JSON formatted button in your list and the following flow which we use to change the created by column of a news story to the contact on the page. That way THEY get the comments and likes, not me!
The button looks like this:
and the JSON code to format the column is as follows. You will need to change the id to your flow and also change the button text etc.
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Change Created By to name of page contact", "customRowAction": { "action": "executeFlow", "actionParams": "='{\"id\":\"50097cde-b800-4c6c-ade9-95be7574f4e5\", \"headerText\":\" ' + [$Title] + '\",\"runFlowButtonText\":\"Go\"}'" }, "style": { "background-color": "#cf000f", "color": "white", "border-radius": "10px" } }Rob
Los Gallardos
Microsoft Power Automate Community Super User
- RobElliott and what if I have calculated fields and formulas in my current SP list, do I also need to manually copy these to the new list?
jonboylib no, they'll copy over when you create the new list.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
