Storing and retrieving images

[abhishek_123]

Hi, I using powerapps to store user profile information to sharepoint list also their image.
Please let me know which is the efficient way to store and retrive images, is it:
1) converting image to binary using json function in poweraps and storing it along wth profile info in sharepoint List.
or

2) storing images separately in sharepoint library, if so how to retrive it as per the selected profile ?

Note: Data may go beyond 5000 records. Converting to binary and storing it in list column along with profile info might take longer time to load. 

[WarrenBelz · Accepted solution]

Hi @abhishek_123 ,

I have done a blog on this subject covering most of the points you mention - happy to assist with your code if necessary when you have read this.

We have over 40,000 photos in some SharePoint Libraries using mobile devices mainly and have no real issues.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[abhishek_123]

Hi @WarrenBelz  Thank you for the blog it was really helpful. 

Just one query... Out of the 3 options of storing images 1) SharePoint library 2) SharePoint List(multi line)  3) attachment... Which method is more efficient for large files?  

Thank you 

[WarrenBelz]

Hi @abhishek_123 ,

I always use a Library for this (size) and many other reasons including the fact you can store other Metadata with the file.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.