Currently I have a Person/Group column called Project Team Members that allows you to add multiple SharePoint users to it.
All i'm looking to do is filter the list view based on the current logged in user being part of the Project Team Members column.
Current methods I've tried:
Workflow sets a single line text column to store the Project Team Members:
(This just returns) {"__metadata":{"type":"Collection(Edm.Int32)"},"results":[28]}
Rest Call to connect to the current list item, then try to extract the values from the Project Team Members column:
_api/web/lists/getByTitle('Projects')/items?$filter=Id eq '[%Current Item:ID%]'
This connects and allows me to extract any value from the list except the Project Team Members column. (Person/Group)
I've looked into using the $expand in the query to expand the Project Team Members column as it's a lookup column but the syntax is most likely wrong.
_api/web/lists/getByTitle('Projects')/items?$filter=Id eq '[%Current Item:ID%]'&$expand=Project Team Members
(I've also tried the internal name: Project_x0020_Team_x0020_Members to no avail)
Essentially I just want to extract the values from the Project Team Members person/group field and display them as one text value so I can then filter the view.
$expand='Project Team Members'
help