Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Question is not on StackOverflow because I am not a developer and hope there is a way to do this without code :)

In SharePoint 2007, is it possible to have a list column do a lookup against a SharePoint Profile?

I would like to be able to create a list with a Person/Group column, and then once I add a user, have the list autopopulate a few columns (such as Manager) pulled from that user’s profile in SharePoint. Is that something that can be done OOB?

share|improve this question
up vote 2 down vote accepted

No, unfortunately there is not a "List" in the normal SharePoint sense of things that stores all the users.

There is not a webservice call that will get all the profiles in one hit either, so something would need to be programmed.

share|improve this answer
Also, if you are looking for the non-OOB solution, I believe it is to create an Event Handler that fires when the item is saved. It can pull the data from the person/group column and automatically populate text columns with the manager/etc. that you need. – MattB Aug 19 '09 at 14:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.