Looking for the equivilent of filtering a SharePoint list on [ME] when the peoplepicker column allows for multiple selections
Posted on 2010-11-18
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.