Forum Discussion
SharePoint view filtered to Me
Hello!
Is it possible to create a view, or JSON format a view, when a field contains my information that is not a people picker field?
I have a multiple line of text field where I enter a JSON object with user emails.
Is there a way to change the view to only show the line item if that text field contains my email?
I have tried using that field with Contains [Me] but that does not work. Presumably as [Me] is for people picker fields.
Is there a way to add a filter to the view to look for my email?
1 Reply
You cannot reliably filter or hide rows using contains() on a text column (multi‑line or single‑line) in modern SharePoint view formatting.
To filter rows based on user membership or email, you must: Store the user value in a People column as work-around.
I tested filtering with both multi‑line and single‑line text columns using exact values and [@me], but SharePoint does not pass the column value into view‑formatting expressions. Because of this, contains() never matches. To filter or personalize a view, the user value must be stored in a dedicated People column or a clean single‑line text column. Only then can the view be filtered reliably.
