Keep a Sharepoint List updated with User Profile changes

Question

Here is a run-down on what I am hoping to achieve on Sharepoint 2013:

• We need to create a Sharepoint List of users. This list is a sub-set of users - only from certain departments, for example.
• We will be adding columns to this list that are specific to the project we are working on. eg: 'Has been inducted to project', 'Project Role', 'Current Task', etc.
• Updates to user info in AD via the User Profile Service (new user, disabled user, department, etc.) would be reflected in the list. eg: New user gets added to the list.

I'm hoping for some direction on the best way of doing this, if it is even possible?

Many thanks,

Nathan

Answer 1

Is it SharePoint Online (Office 365) or On Premises? If it's on premises, a timer job can be built that reads all user profiles and updates the list.

However if it's Office 365, the options are limited. One of the ways is -

Develop a Site Workflow that uses a REST call to fetch all site users, loops through site users, gets user profile info for these users, updates the list. The gotcha here is all site users doesn't mean all users, its all users who have visited the site.