Workaround for SharePoint Person or Group Lookup Columns
Question details
The user needs a method to display an assigned person from another SharePoint list on a service desk dashboard without experiencing the delays associated with Power Automate flows.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Creating a real-time service desk dashboard that relies on referencing assigned personnel from a separate source list.
- Observed behavior
- Native SharePoint lookup columns do not support selecting the 'Person or Group' data type, making it impossible to map users across lists directly.
Ensure you have the necessary 'Edit' or 'Full Control' permissions for both the source SharePoint list and the destination dashboard list to modify column structures.
Use a Single Line of Text Column as the Source
Convert or replace the existing 'Person or Group' field in your source list with a 'Single line of text' column, which is fully supported by SharePoint lookup columns.
Because SharePoint inherently prevents lookup columns from pulling complex data types like 'Person or Group', the most effective real-time workaround is simplifying the data. By using a standard text column, the lookup feature works instantly without relying on delayed Power Automate flows. Note that this method sacrifices rich profile data (like user hover cards and presence indicators) but accurately fulfills the dashboard display requirement.
Open the SharePoint source list that contains the assigned persons. Click on the Gear icon in the top right corner and select 'List settings'.
Scroll down to the Columns section and click 'Create column'. Choose 'Single line of text' as the data type and name it (e.g., 'Assigned Person Name').
Manually enter or mass-update the plain text names of the assigned users into this new column for all existing list items.
Go to your service desk dashboard list. Create a new Lookup column, point it to your source list, and in the 'In this column' dropdown, select the new 'Single line of text' column you just created.

Looking for a Simpler Way to Manage Documents? Try WPS Office
Navigating SharePoint and Microsoft 365 limitations can be overly complex for standard tasks. If you need a fast, reliable, and straightforward solution for your daily document, spreadsheet, and presentation management, WPS Office is the perfect lightweight alternative.
- 1. Download and Install: Get the free WPS Office installer from the official website and follow the quick setup guide.
- 2. Open Your Documents: Launch WPS Office and instantly open your existing Microsoft Office files without losing any formatting or data.
- 3. Edit and Save: Enjoy a familiar interface to seamlessly edit your work and save files locally or sync them to your preferred cloud.

Frequently Asked Questions
Why does SharePoint block Person or Group data types in lookup columns?
SharePoint restricts complex field types—including Person or Group, Multiple lines of text, and Calculated columns—from being used as target lookup fields due to backend database architectural constraints and relationship mapping limitations.
Can I use Power Automate to sync the Person or Group column instead?
Yes, you can create a Power Automate flow that triggers when an item is modified in the source list to update a native Person column in the destination list. However, this is not instantaneous and can introduce workflow delays, which may not be suitable for real-time dashboards.
Will the text column workaround update automatically if a user's name changes?
No. Because a 'Single line of text' column contains static text, it will not automatically update if a user's display name changes in your organization's active directory. The text field in the source list must be updated manually.




