Forum Discussion
Microsoft Lists - how to move?
bryandibben I followed your recommendation however when I tried to import the excel file I received the following error message. Help is much appreciated.
Before you add it to MS Lists, you'll need to:
- Format the data as a table with headers (open CSV, highlight data, click 'Format as Table' and select 'My table has headers)
- Save as .xls
Create the new list from your .xls file. You'll be prompted to match up the field types
You save your datas in excel and you can import them in a new list, but you loose all the column settings, isn't it?
I've a big list in 'My List' I would like to move it to a sharepoint site.In this list the Columns have different settings and different format. If I use excel to keep the datas I loose the columns setting and format if I use the existing list to create the new one I keep the columns setting and format but loose the datas....
Do you have a solution to keep the both, column setting&format AND all the datas?
Thank you
- 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!
