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

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.
LVL 1
DavidWilkinsAsked:
Who is Participating?
 
DavidWilkinsConnect With a Mentor Author Commented:
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
 
chapmanjwCommented:
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
 
DavidWilkinsAuthor Commented:
Was able to solve the issue using "=" instead of "Contains"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.