Jul 25 2022 08:44 AM
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 (including data, settings and connected flows) to my MS Team so that my colleagues can add to and edit the list.
How can I achieve this?
Jul 25 2022 10:36 AM
Jul 25 2022 10:45 AM
@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
Jul 26 2022 01:01 AM
Jul 26 2022 01:32 AM
Solution@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)
Dec 21 2022 08:19 AM
@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?
Dec 21 2022 08:39 AM
@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
Jul 26 2022 01:32 AM
Solution@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)