SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

I wish to create a Site Column, that will display all existing departments in our company.

We have the correct departments setup in our AD, and all users subject for this list are part of the same OU ('Organisational Unit' in AD terms).

The departments are subject to change, so I would like the list to update every night, so the list of departments is always up-to-date.

Do any of you have some advise on how to manage this ?

Look forward to your advise!

share|improve this question
Are you running, or can you run a Managed Metadata Service Application - ie Standard or Enterprise? – Daniel Symonds-Lloyd May 16 '12 at 9:49
We are running the Enterprise version. – CodeMonkey May 16 '12 at 10:34
up vote 1 down vote accepted

I would recommend you use a Managed Metadata Term Set, which will make the column available throughout your environment, integrate with search and have all the other advantages of Managed Metadata Columns.

To update the departments each night, write a SharePoint Timer Job which sources its information from SQL and populates it within the term set.

Make sure you manually set the GUID for the term when creating them, that way you can rename the existing term, eg Accounting to Accounts based on the ID, then the environment will update the label for existing values on next save.

share|improve this answer

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.