Sep 21 2020
06:48 PM
- last edited on
Feb 01 2023
12:41 PM
by
TechCommunityAP
Sep 21 2020
06:48 PM
- last edited on
Feb 01 2023
12:41 PM
by
TechCommunityAP
Nov 13 2020 09:52 PM - edited Nov 13 2020 09:52 PM
Same isue here. Anyone?
Jan 28 2021 12:26 AM
@kristinholm From what I understand it is possible to copy lists between SP-sites. However if you've made a list in your own work space you're out of luck. Moving/copying isn't possible then.
I've recreated the list in a SP-site.
Feb 05 2021 05:19 AM - edited Feb 05 2021 05:20 AM
@Andre Siregar
It seems that you can download the lists as indicated in this post SharePoint lists - How to move them from one site to another - Microsoft Community, but it is unclear to me how you can upload them again to the SharePoint site. What is your Excel workaround?
Mar 18 2021 12:28 PM
As previously mentioned the 'Export to Excel' seems the only option.
For anyone else, this is how I did it
1. In Microsoft Lists export to Excel (it will be an .iqy file extension)
2. In Sharepoint site page click new list
3. Upload your excel file
To finish
Check the column types and choose a new type if the current selection is incorrect.
-----
I hope this helps
Mar 12 2022 02:13 AM
@bryandibben I followed your recommendation however when I tried to import the excel file I received the following error message. Help is much appreciated.
Jun 10 2022 08:15 AM
Aug 21 2022 09:45 PM
Jan 02 2023 07:46 AM
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
Feb 13 2023 03:26 PM
Garbage program that ties one into MS365 forever (unlike excel files). One can work via export for simple files but when one has attached a pile of documents to the list as the program is intended, there is no way to move to a non-sharepoint site (i.e one's personal harddrive) etc. Very frustrating and lack of disclosure.
Mar 02 2023 01:06 PM
Mar 02 2023 11:09 PM
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
Step 2: Set up your flow in Power Automate
Mar 03 2023 06:57 AM
Mar 03 2023 08:30 AM
Mar 03 2023 01:21 PM
Mar 05 2023 01:14 PM
Hi @jb_r3d
When I need to upload a list to SPO from an excel spreadsheet, I use the 'Export to SharePoint' feature in Excel. Here's how:
If you don't have the Export section in the Table properties yet, you'll need to customise your Excel ribbon. This information from Microsoft should help with that. Video: Customize the ribbon - Microsoft Support
This is the best solutions I've found so far, I hope it helps you too.
Mar 13 2023 01:51 AM
@M365Specialist , if the list has any customization like controlling when a field is hidden or shown, with your process you'll lose it, all custom's will be gone.
This is mentioned above many times.
But thanks anyway.
Apr 12 2023 01:55 PM
If using the Power Automate solution, will my custom forms/power apps, and flows move with the list?