locked
Derive department from People/Group column in a list RRS feed

  • Question

  • I am trying to create a list containing details about an individual. In addition to the unique content I will be adding to the list, I would like to display the person's department in a column. Is it possible to have a column displaying the Department Name for the person appearing in another person/group column?

    Column 1 would be populated with the username and would be a person-group column

    Column 2 would need to automatically return the department based for the individual identified in Column 1

    Sounds like something that should be simple but...

    Tuesday, May 13, 2014 8:42 AM

Answers

  • Yes you can get that

    http://www.n8d.at/blog/dynamically-display-department-information-for-a-user-in-a-list/

    Or try

    var thisDepartment = $().SPServices.SPGetCurrentUser({
    fieldName: "Department",
    debug: false
    });

    http://stackoverflow.com/questions/5358035/sharepoint-get-current-user-attribute

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/d1b54140-1718-4e56-8033-2a2ef96c6363/how-to-sync-department-from-active-directory-to-sharepoint?forum=sharepointgeneralprevious

    Tuesday, May 13, 2014 9:02 AM