Microsoft Lists - how to move?

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
• 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!