SharePoint Document Issues

How to Link SharePoint Text and Person Fields for Current User Reports

John WilsonJohn Wilson Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the SharePoint list settings

In the SharePoint list, select the gear icon > List settings, or choose Settings > List settings from the command bar.

2
Create a Person or Group column

Select Create column, enter a name such as 'Assigned User', choose Person or Group as the type, and set Allow multiple selections if needed.

3
Populate the column with users

Edit items and select the correct user for each row, or use Quick Edit/Grid view to fill multiple rows.

4
Update the report or view filter

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]
[Me] filtering now works: After the Person or Group column is populated and used in the filter, the report will display records for the current user only.
Free Microsoft Office alternative

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.

Free to download and use for everyday document, spreadsheet, and presentation work.Opens, edits, and saves Microsoft Word, Excel, PowerPoint, and SharePoint-exported Office files with high compatibility.Familiar ribbon-style interface helps users migrate from Microsoft Office without retraining.Lightweight and easy to use for reports and documents when SharePoint-specific features are not required.
microsoft office alternative - wps office

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.