Forum Discussion
Solved
Lists - column to show the department code for an individual listed in a person column
I have a list where I want to add an individual under a person column and have their respective department code automatically populate in a separate column for organization purposes. Is there a way t...
simpkinspete Department property is available as an option in 'Show field' for people picker property. But you cannot use a people picker column in a calculate column calculations. Here is a workaround to try -
- Create a text column called 'Emp name'
- Update your person column to display Department value
- Setup a power automate to run and fill in your 'Emp name' text column with 'Name' property accessible for people picker.
If you execute it properly, you will end up with Name and department properties.
It is a property that is set at column level. Not possible to have a different option for a specific view.
Bharath Arja ganeshsanap - thanks for the responses! I'll take a look at using Power Automate to update the field as needed.
I also submitted a request to the feedback portal to https://feedbackportal.microsoft.com/feedback/idea/d9bd24c3-0114-ed11-a81b-6045bd864d4fthat would act similar to Lookup columns.