Forum Discussion
How to pull from 'Person' field in one column to populate 'Department' of another
Hello all. Hoping someone can help me out with this. I'm trying to set up a Microsoft list that has a person column (Column A) and a department column (coulmn B) I would like to auto-populate colum...
You might have already resolved this, but if you haven't, and your list doesn't have too many items, you can easily accomplish this with Classic Mode and Quick Edit.
- Display your list in Classic mode and include the filled in Column A and the empty Column B.
- Copy Column A and paste it into Column B just like you would do in Excel
- Exit Quick Edit
Column B should display whatever profile field you selected (Department in your case).
This only works in Classic mode - the new Lists experience and even Modern experience are broken. Both ignored the people picker field selection and displayed user name in Column B.
- Display your list in Classic mode and include the filled in Column A and the empty Column B.
- Copy Column A and paste it into Column B just like you would do in Excel
- Exit Quick Edit
Column B should display whatever profile field you selected (Department in your case).
This only works in Classic mode - the new Lists experience and even Modern experience are broken. Both ignored the people picker field selection and displayed user name in Column B.