Unanswered

Filter SharePoint list based on MultiUser column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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)
) )) )

Was this reply helpful? Yes No