Forum Discussion

jonboylib's avatar
jonboylib
Iron Contributor
Jul 25, 2022
Solved

Moving a SP List

I've created a SP Online list and populated it with quite a lot of data. I've also created some flows and automations.   The list was created under my personal account, I now want to move this list...
Lists
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Jul 26, 2022

    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)

Kelly_Perkins's avatar
Kelly_Perkins
Copper Contributor
Dec 21, 2022

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?

RobElliott's avatar
RobElliott
Silver Contributor
Dec 21, 2022

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

 

Resources