SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list of items where a field is a group of users. Is it possible to filter the list to that the person viewing the page will only see the items where he is a member of the users listed in the item ?


 - Item 1
   -- Title = A
   -- Members = X, Y, Z

 - Item 2
   -- Title = B
   -- Members = U, V, Y

So that user X would only see item 1, user V would only see item 2, and user Y would see both.

share|improve this question

I solved same problem by dynamicaly setting permissions on list items in event receiver. But this solution is not scalable at all.

I will recomend create Folders with unique security assignments and view for all items without folders.

share|improve this answer
This is one of the few effective uses of Folders there is in SharePoint. – James Love Apr 8 '11 at 17:00
I cannot use folders as this is about a custom list of items with various fields, including a team field containing several users. – Veynom Apr 13 '11 at 9:33
up vote 1 down vote accepted

Ok, we solved this issue by writing a piece of code that dynamically set the permissions to the item. Using my above example, users X, Y, Z have contribute rights on A.

share|improve this answer

In some cases u can use XsltListViewWebPart and create SPView 'on the fly' - clone exist view, add/remove fields, setup SPQuery and set this SPView to your XsltListViewWebPart instance.

This solution also have a lot of limits but sometimes it is useful trick.

share|improve this answer
There is no way to filter items in query by user group membership, unfortunately. – gandjustas Apr 9 '11 at 20:53
Actually, it is - Membership Element (, isn't it? – avishnyakov Sep 16 '11 at 11:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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