Where are Microsoft Lists stored?
Microsoft Lists is a new application that’s been added to Microsoft 365 to modernize the lists available in SharePoint and recently became available for consumer users with an MSA account.
With two different versions of Microsoft Lists it is important to know where the data gets store depending on the options that you choose when using the application.
Where are Microsoft Lists stored in Microsoft 365?
When using lists in Microsoft 365 with your corporate account, lists can get stored in two locations depending on the scope that you choose when creating the list.
If you are planning to create a list that will be used just by you, and you’ve selected My lists in the Save to option the list will be stored on your personal SharePoint site, the same site you access to open the files stored in OneDrive.
On the other hand, if you are planning to create a list that is shared by multiple users in SharePoint or Microsoft Teams, then the list gets stored in the SharePoint site collection where it was created.
Where are Microsoft Lists stored with MSA accounts?
If you are using Microsoft Lists with your personal Microsoft account, your list will be stored in your personal OneDrive, despite the different URL (https://lists.live.com).
Technically under the hood Microsoft Lists MSA is running the same old SharePoint but with a lot of engineering on top of it to be available to the consumer market.
If you want to know more about Microsoft Lists MSA I recommend you listen the Intrazone PodCast below with Mark Kashman and Miceile Barrett.
November 12, 2023
Hello João,
thanks for this good blog post.
Do you have a clue, if I can access lists stored in a MSA account via SharePoint connector in Power Automate?
Thanks,
André
January 26, 2024
Hi André,
It is not possible, at least for now.
Have a nice day
February 20, 2024
Hello Joao,
Thank you for creating this Microsoft List. I’ve been utilising this, and it’s beneficial in managing and organising my tasks. I’ve been advocating the great experience to my teammates for a productive and collaborative output.
Our questions are the following:
When uploading the attachments via Microsoft List, where are these attachments being stored in One Drive / Sharepoint?
And can the attachments be stored in a specific folder of every list file name?
Can customised files be exported directly to Excel?
Help us please to locate these files and organise them accordingly for a better experience and result.
Thanks,
K
February 22, 2024
Hi Kristine,
I just wrote a post about Microsoft Lists attachments that answer to some of your questions.
You can have a look in the link below:
https://lists.handsontek.net/turn-off-attachments-microsoft-lists/
Keep in mind that the attachments should not be used as document library, all the attachments will be stored in the SharePoint site where the List is.
Let me know if you have any other question.
Have a nice day 🙂