How to Link SharePoint Text and Person Fields for Current User Reports
Question details
The user needs to filter a SharePoint list by the current user with [Me], but the list imported from Access stores user names and IDs in text columns rather than Person or Group columns.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- A report or list view must display only records for the currently logged-in user.
- Observed behavior
- SharePoint cannot link a Single line of text column to a Person or Group column, so [Me] filtering cannot use the text data directly.
Check the SharePoint list column type for the user name or ID field, and confirm whether your report or view uses the [Me] filter token. This token works only with Person or Group columns, so the workaround depends on the column type.
Create a Person or Group Column and Filter by [Me]
Use this native SharePoint workaround when you can add a new column and populate it with the correct user values for the current user report.
SharePoint list view filters and report filters can use [Me] only against Person or Group columns. You cannot change an existing text column into this type, so you must create a separate column and either enter the users manually or use automation to fill it.
In the SharePoint list, select the gear icon > List settings, or choose Settings > List settings from the command bar.
Select Create column, enter a name such as 'Assigned User', choose Person or Group as the type, and set Allow multiple selections if needed.
Edit items and select the correct user for each row, or use Quick Edit/Grid view to fill multiple rows.
In the view or report filter, choose the new Person or Group column and set the condition to 'is equal to' then enter [Me].
![Create a Person or Group Column and Filter by [Me]](https://res-academy.cache.wpscdn.com/upload/seo-engine-admin/2026-11-13/5642670860c86bcaabc2626e61e977cc.png)
Automate Text-to-Person Column Updates with Power Automate
Use this when the text column already contains many user names or IDs and you want to populate the Person or Group column automatically instead of editing each item.
Create a Custom Power Apps Filter Based on the Current User
Use this if you cannot add or populate a Person or Group column and need a custom report interface that filters text fields by the current user.
Use WPS Office as a Free, Lightweight Alternative for Office Documents and Reports
WPS Office cannot change SharePoint's built-in column behavior, but it provides a free, lightweight way to create, edit, and share Office documents with strong Microsoft Office format compatibility and a familiar interface.

Frequently Asked Questions
Why does [Me] not work with a Single line of text column in SharePoint?
Because [Me] is a filter token that only resolves against Person or Group columns. SharePoint cannot compare [Me] to a text column, so a text username or user ID is treated as plain text.
Can I change an existing text column into a Person or Group column?
No. SharePoint does not provide a direct column type conversion. Create a new Person or Group column and populate it manually, in grid view, or with Power Automate.
How do I add a Person or Group column to a SharePoint list?
Open the list, go to Settings > List settings > Create column, choose Person or Group, enter a column name, and save. Then edit items to select users.
Will WPS Office fix SharePoint [Me] filtering issues?
No. WPS Office is a free Office-compatible desktop suite and does not modify SharePoint list schemas or filter behavior. Use SharePoint column configuration or Power Platform for the fix.
Can Power Automate copy text user names into a Person or Group column?
Yes. Use a Power Automate flow to read the text value, search for the user with the Office 365 Users connector, and update the Person or Group field with the resolved user.




