Solved

Looking for the equivilent of filtering a SharePoint list on [ME] when the peoplepicker column allows for multiple selections

Posted on 2010-11-18
3
2,099 Views
Last Modified: 2012-08-14
I've filtered peoplepicker columns in SharePoint lists using "Assigned To = [ME] " many times in the past.  I never would have guessed that if you allow the peoplepicker column to contain multiple selections and change the filter to "Assigned To contains [ME]" that SharePoint would deny your request with an informational message equivilent to "sorry, that's not allowed"

The peoplepicker field I need to filter on allows for multiple values.  It is populated from a workflow which adds users to the peoplepicker column,  seperated as usual, by a semicolon.

I could accomplish this in a dataview web part as "(Contains (Assigned To, $UserID)) works in a DVWP but this view is comprised of two two datasheets, each from a different list and I don't believe you can create a datasheet view in a DVWP when using a combined (linked) datasource.

If you have a work around as to how I can filter a view, where the peoplepicker column allows for multiple selections and the current user is included in that column.... let me know.
0
Comment
Question by:DavidWilkins
  • 2
3 Comments
 
LVL 21

Expert Comment

by:chapmanjw
ID: 34430488
That is a limitation of vanilla SharePoint 2007.  There are two ways I have found to overcome this:  

1) Go third-party: I really like FilterZen http://roxority.com/filterzen/

2) Use some calculated column madness.  Create a calculated column that is gets its value from the people picker column.  Then filter off the calculated column.
0
 
LVL 1

Accepted Solution

by:
DavidWilkins earned 0 total points
ID: 34816163
If you allow for multiple selections in a people picker field you can still use the filter  "=" instead of using "contains"  It doesn't matter which position (in the multiple selection field) you name is in, the filter still works
0
 
LVL 1

Author Closing Comment

by:DavidWilkins
ID: 34849925
Was able to solve the issue using "=" instead of "Contains"
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now