Forum Discussion
Microsoft Lists - how to move?
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
- HelloBenTeohMar 03, 2023Bronze Contributor
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!
- WickedWolfieJun 27, 2024Copper ContributorThis worked for me, many thanks. (Co-pilot is helpful for anyone who's not used Power Automate before!)
- LesliePSep 14, 2023Copper ContributorEvery time I think Lists will be a nice solution to our "Excel All The Things" problem, I find some limitation that is beyond insane, making Lists the app I never can use.
If the solution involves "go to Power Automate and set up this or that" or "in Power Apps do the other thing" or even Sharepoint much of anything - you've rendered the solution unavailable to small businesses that don't have IT staff and don't WANT IT staff, they just want app that work, simply, reliably.- HelloBenTeohSep 14, 2023Bronze Contributor
LeslieP I hear you. Excel's flexibility has made it this one-stop-shop for a lot of this type of work. If it's working for you, then keep it going. The M365 suite has so many different apps, but they all have limitations or dependencies. The MOCA really highlights how 'noisy' the app collection we have is - I think it's just a case where you pick what's going to fit the way you work.
Where I see Lists working really well is when you're pairing it up with Power Automate and other services. But like you mentioned, that's a different skill set that's not available to everyone.
- parkm23Jun 02, 2023Copper Contributor
Hello, My List is in one MS Team and I need to move it to another Team. the problem is I have Dropdowns and Attachments that have to go with it. What can I do to make sure ALL of the information gets moved? Any help would be greatly appreciated. 🙂
- HelloBenTeohJun 05, 2023Bronze Contributor
parkm23 Hey, I haven't tried this yet but you may be able to get some pointers here: Solved: Copy attachments from one SharePoint list to anoth... - Power Platform Community (microsoft.com)
You'd need to combine this as part of the process of copying your items across to the new list.