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.

Improve this question
9
  • What kind of information would you like to store that couldn't be in the user profile?
    – ranbo
    Feb 20, 2017 at 19:41
  • or just stored in local browser storage and retrieved with store.js or in a cookie
    – Eric Alexander
    Feb 20, 2017 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.
    – ICW
    Feb 20, 2017 at 19:47
  • It needs to be server-side storage.
    – ICW
    Feb 20, 2017 at 19:49
  • Which SP version? Is it not something like this what you want? blog.sharepointlearn.com/2013/08/10/…
    – ranbo
    Feb 20, 2017 at 19:50

2 Answers 2

Reset to default
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

Improve this answer
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.
    – ICW
    Feb 20, 2017 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, 2017 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.

Improve this answer

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.