Forum Discussion
Microsoft Lists - how to move?
Is there a way to move a List, e.g. from my personal space to an Office365 Group? There does not seem to be a way to do this other than using workaround of export & import to Excel. However,...
I'd like this as well. User created a list, we want to move it to SP. There are several Choice columns, and they get messed up when importing.
An option is to use Power Automate to migrate your data across. This is a basic run down of what you need to do.
Note: For some fields (e.g. multi choice drop downs etc, images etc) you'll need to add some extra functionality in but this should get you started.
Step 1: Create your new list, based on your original list
This will replicate the columns for you.
In Microsoft Lists
- Select New list
- Select From existing list
- Select My lists in the "Select a team or site" column
- Select the list you want to copy
- Select Next
- Enter the name, description, color and icon of the new list. (If you want to use the same name, it will initially have an error saying "List already exist")
- In the 'Save to' dropdown, select the location for your new list (once changed, the error will disappear)
Step 2: Set up your flow in Power Automate
- Select Create
- Select Manually trigger a flow
- Add the action Get Items (SharePoint)
- For Site Address, select Enter custom value
- You will need to copy/paste your personal list location. You can get this by opening your original list. From the url, copy everything in https://[your-domain].sharepoint.com/personal/[username_domain]
- For List Name, select original list
- For Site Address, select Enter custom value
- Add the action Create Item (SharePoint) - this will also create an Apply to each action for you
- For Site Address, select the site of the new list
- For List name, select the new list
- For each of the fields, select the matching field in the list that pops up under Get Items
- Save and test!