Forum Discussion
Creating a list and restricting the items within to defined users only?
Hi,
I'd like to create a list within SharePoint Online, into this list I plan to add information for each of my users. I would like to create a central page with this list on but would like to filter the items within the list to the relevant user only. I'm struggling to find anything to acheive this? The goal would be when user 2 views the page/list they only see items which are attached to them.
I know that "Item-level Permissions" can be set to "Read items that were created by the user" but the problem is the users are not creating the items - someone else is...
Lets say the list contains 4 items for user 1 and 4 for user 2, etc and these items have been added by someone other than the user... when each user views the list they should only be able to only see their own items. Ideally this should be via some sort of security but I'm aware this may not be entirely possible.
Any suggestions on how to reliably do this? Ultimately I'm trying to avoid having to create the same list for every single user (30+) and then having to maintain multiple separate lists.
- Oh missed the line in there about security. Yeah if you want it secured your looking at a very big pain to get that to work properly. If security through obscurity is fine, then making a view and the default view by filtered to the [me] in a column assigned to them then you can accomplish this, so when they load into the page / view they will only see their items. Then you just trim and remove all the views that can show other data, and unless they know how to go in and read the data via some other means, they really won't see the other data.
3 Replies
- Oh missed the line in there about security. Yeah if you want it secured your looking at a very big pain to get that to work properly. If security through obscurity is fine, then making a view and the default view by filtered to the [me] in a column assigned to them then you can accomplish this, so when they load into the page / view they will only see their items. Then you just trim and remove all the views that can show other data, and unless they know how to go in and read the data via some other means, they really won't see the other data.
Thanks for your time!
This sounds like a great solution - security is a concern but "security through obscurity" could work in this particular instance if item level security is going to be problematic to setup.
- That's easy to accomplish using views and the [me] filter, but this only works if a user can see the other data in the rest of the list (If they go looking for it). Like if this is confidential data then your opening up a big ball of mess.
If you got data, that isn't really confidential that you just want to filter to that user when visiting a page that's easy. Let me know which and I can give suggestion if it doesn't require the data to be protected.
