Announcements
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.
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.
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)) )) )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
