2

I was contemplating the concept of using SharePoint lists for data storage (not what they're for, I know), and came up with the idea of having a unique SharePoint list for each user of the site, and have some data associated with that user stored in the list. Is there any reason I can't have a large number(Hundreds, perhaps. Less than 1500.) of SharePoint lists stored on our site? It seems like something I shouldn't do/shouldn't be able to do but I would like to know why before I move past the idea. Using SharePoint online if that matters.

Thanks in advance.

9
  • What kind of information would you like to store that couldn't be in the user profile? – ranbo Feb 20 '17 at 19:41
  • or just stored in local browser storage and retrieved with store.js or in a cookie – Eric Alexander Feb 20 '17 at 19:45
  • @RafaelBonametti Without going to deep into detail, I am attempting to implement a sort of badge system in my website that keeps track of which badges the user has earned, so it's a sort of custom data. Can the user profile be used to store data? If so, what kinds? Thanks. – Isaac C Way Feb 20 '17 at 19:47
  • It needs to be server-side storage. – Isaac C Way Feb 20 '17 at 19:49
  • Which SP version? Is it not something like this what you want? blog.sharepointlearn.com/2013/08/10/… – ranbo Feb 20 '17 at 19:50
2

Answering one of your questions, yes, there is a limit of lists that you can have in SharePoint before performance starts to downgrade.

You can check Microsoft's documentation on that

2
  • Good link - however I don't think the page addresses the limit of the max number of lists on any given SharePoint site. It seems only to address the number of items for any given list. – Isaac C Way Feb 20 '17 at 20:29
  • You're right. The same documentation but for SP 2010 shows 2000 lists per site. That can give you an idea technet.microsoft.com/en-us/library/cc287790.aspx – ranbo Feb 20 '17 at 20:35
1

You can do it in a single list if you configure it appropriately. 1500 users is well under the list threshold boundaries. You'd want to configure the list in such a manner that users can't really see other's data.

enter image description here

Users would need to have contribute permissions on the list as well to be able to perform CRUD operations against the list.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.