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.