Power Apps - Building Power Apps

Sharepoint list

(0) Share

Report

Posted on by NN-05080720-0

Can I use lookup for Person type column, It does not automatically fill my list when I make lookup. Person column doesn't come in choice also

Categories:

Employee Ideas app on Teams

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

MS.Ragavendar 4,109 Super User 2025 Season 2 on at

Like (0)

Report

Sharepoint list

@NN-05080720-0,

What is the datasource which you are using, what exact requirement u looking for

Was this reply helpful? Yes No
Suggested answer

wolenberg_ 681 Moderator on at

Like (0)

Report

Sharepoint list

Hello @NN-05080720-0 , You can’t use a SharePoint Lookup column to reference a Person-type column directly. Lookup columns only support basic data types like text, number, and date—not complex types like Person or Group.

Lookup columns in SharePoint are designed to pull simple values from another list.
Person or Group columns are complex objects that include metadata like name, email, job title, and department.
Because of this complexity, they don’t appear as options when configuring a Lookup column.

Workarounds You Can Use

1. Use a Text Column Instead

If you only need the person’s name or email:

• Create a text column in the source list that stores the person’s name or email.
• Then use a Lookup column to reference that text field.

2. Use Power Automate to Sync Person Data

• Create a flow that triggers when a record is created or modified.
• Use the flow to copy the Person field from one list to another.
• This allows you to simulate a lookup-like behavior while preserving the Person object.

3. Use Calculated Columns or JSON Formatting

• You can use JSON column formatting to display related person info dynamically.
• This doesn’t create a true lookup, but it can visually link data between lists.

Resources

• SharePoint Stack Exchange – Automatically update Person fields across lists

• Microsoft Tech Community – Pull data from Person field to another column

• SharePoint Migrator – Lookup column not showing all fields

If this helped or could help others in the community, feel free to give it a like or a kudo — it helps surface useful answers for everyone!

Was this reply helpful? Yes No