Where are Microsoft Lists images stored in 2024?
Microsoft Lists is a powerful tool that allows you to create and manage data in various scenarios. One of the features that makes Lists stand out is the image column field, which lets you upload an image directly from the form, without having to use a hyperlink column and manually upload the image to SharePoint.
But where are these images stored? And how can you access them if you need to? In this blog post, I will explain how the image column storage has changed over time and what are the implications for end users and developers.
How it used to work
When Microsoft Lists were first introduced, the images uploaded via the image column field were stored in the Site Assets library of the SharePoint site where the list was created. Inside the Site Assets library, there was a folder with the same ID as the list, and inside that folder, there were the images for each of the items.
This meant that you could easily access the images from the SharePoint interface, by navigating to the Site Assets library and browsing the folders.
How it works now
Recently, Microsoft has changed the way the image column field works. Now, the images uploaded via the image column field are attached to the list item, but not in the usual way. They are hidden attachments, which means that you cannot see them in the attachments section of the item, nor can you manage them from the SharePoint interface.
This means that the images are no longer stored in the Site Assets library, and you cannot access them by browsing the folders.
What are the implications of this change?
For the end user, there are no implications if they are using the out of the box experience without any customizations applied to the list. Everything will continue to work as it always did, and the images will be displayed in the list view and the item form.
However, if you have applied some list formatting to the list, and you are using the image column field to show the images in a different way, you may need to update your JSON code to reflect the new way of accessing the images. Specifically, you need to use the =getThumbnailImage(@currentField, 400, 200) function to get the URL of the image, instead of using the =@currentField.serverRelativeUrl property. You can learn more about how to use this function in my previous blog post here.
If you are a developer, or if you are trying to access the images using Power Automate or other tools, you need to use the SharePoint API to get the hidden attachments for the item. This will allow you to get the direct link to the image that you can then use in your solutions.
What about old lists?
You may be wondering what happens to the old lists that were created before the change, and that already have images stored in the Site Assets library. Well, the good news is that nothing changes for them. They will continue to work as they always did, and the images will remain in the Site Assets library. You can still access them from the SharePoint interface as described above.
In this blog post, I have explained where are Microsoft Lists images stored in 2024, and how the image storage has changed over time. I have also discussed the implications of this change for end users and developers, and how to access the images using the SharePoint API.
I hope you found this blog post useful and informative. If you have any questions or feedback, please leave a comment below or contact me via email. Thank you for reading! 🙂