How to add Preexisting Microsoft List to a SharePoint group

Gosse, Hayley (HC/SC) 50 Reputation points
2023-07-26T15:34:45.7766667+00:00

Hello,

I created a Microsoft Lists and saved it to 'My Lists' with the intent to add it to the SharePoint group afterwards. However, when I went to do so in the list's settings, the option was no longer available.

Is there a way for me to move the list into SharePoint without having to restart. There is an insane amount of data that would take way too long to retype in its entirety.

Thank you!!

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,204 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 28,961 Reputation points Microsoft Vendor
    2023-07-27T06:19:45.8033333+00:00

    Hi @Gosse, Hayley (HC/SC) ,

    There is currently no direct way to do a move. But there are two possible options, one is Export to Excel. These are the steps:

    1. Open the list in Microsoft Lists.
    2. Click on the three dots in the upper-right corner of the page and select "Export to Excel" from the dropdown menu.
    3. Save the Excel file to your computer.
    4. Open the SharePoint site where you want to move the list.
    5. Click on "Site Contents" in the left-hand navigation menu.
    6. Click on "New" and select "List" from the dropdown menu.
    7. Give the list a name and click "Create."
    8. Click on the "Import Spreadsheet" button in the ribbon at the top of the page.
    9. Browse for the Excel file you saved earlier and click "Import."
    10. Follow the prompts to map the columns in the Excel file to the columns in the SharePoint list.
    11. Click "Finish" to complete the import process.

    The other is to use Power Automate, but Power Automate is currently not supported in the Q&A forum. Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

    There is post for your reference:

    https://techcommunity.microsoft.com/t5/microsoft-365/microsoft-lists-how-to-move/m-p/1696702


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.