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,066 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
Comment Utility
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
Comment Utility
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
Comment Utility
Was able to solve the issue using "=" instead of "Contains"
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

763 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

12 Experts available now in Live!

Get 1:1 Help Now