Lookup Column SharePoint Help

Occasional Contributor

Hi-

Maybe someone can help or be of assistance.

I am working with a SharePoint list that has employee column of type person or group.

When the user enters their name it pulls from active directory. What I am trying to accomplish is that, I need to associate the names with the company codes for the company (example list provided).

Is there a way to accomplish this with a person or group column in SharePoint? If not what is the best way to accomplish this - even if it means that I may have to use Power Automate to get it working.

Company Code Test.png

 

Thanks,

y2kardell

0 Replies