You’re offline. This is a read only version of the page.
Hi everyone!
I'm trying to build an app based on a sharepoint list of projects.
Some projects are assigned to multiple people (you can just select multiple people in the "assigned to" column).
I'm trying to create a screen on an app called 'my projects', however I'm having issues with filtering the gallery through the 'assigned to' column based on the 'User().FullName' as the column now contains a table for each record.
If anyone could help me out I would really appreciate it!!!
@han080
Filtering should be done on a unique identifier. Two people can have the same name (e.g. John Smith). Therefore, I recommend you Filter based on the user email.
The IN operator can be used to check if a value exists in a set of records.
Share
Report
All responses (
Answers (
29,991
Filter(
'Your SharePoint List',
User().Email in 'Assigned To'.Email
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
