cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Filter SharePoint list based on MultiUser column

I have a sharepoint list of tasks. The tasks list has an Assigned To column (field type SPUser). It allows multiple users to be selected. It ONLY allows user... no groups.

 

How can I filter the list to select only tasks assiggned to the current  user. 

2 REPLIES 2
Highlighted
Super User
Super User

Re: Filter SharePoint list based on MultiUser column

You can use the in operator. It would look something like this:

 

Filter('Data Source', User().Email in AssignedTo.Email)

Since the "in" isn't delegable in SharePoint you could run into some issues if you have a large list.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Filter SharePoint list based on MultiUser column

Thanks, That works. I didn't know there was an IN operator. Thats way simpler than the route I was going:

Filter(
testlist,
IsBlank(
LookUp(
testlist.multiusercol,
Upper(Email) =Upper( User().Email)
) )) )

 

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,232)