Display Employee List from Active Directory in SharePoint 2013 Office 365 On-lin

We are using SharePoint 2013 Office 365 On-line.  I want to be able to create an Employee list in SharePoint that would display information from Active Directory, ie. Name, Department, Email, Phone Number, etc., as well as adding some additional columns in the list for miscellaneous information that may not be found in Active Directory.   It would be even better if the employee can update some of there information via the list.

Does anyone know how to create an employee list that will be displayed on a SharePoint page using the information from Active Directory?  I have tried a number of things and nothing has worked.  Also, I have searched the internet and all of the information I have found deals with on-premise SharePoint and not Office 365 on-line.

Thanks in advance for any help in this area.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vasil Michev (MVP)Commented:
There's only a limited set of attributes that will be synced from the on-prem AD to SPO, pretty much the same list detailed here: https://technet.microsoft.com/en-us/library/hh147510.aspx

You will have to take care of filling in the values for the remaining attributes.
I think you would be better off using your on-prem Active Directory than the Office 365 AD.  SharePoint Business Connectivity Services (BCS) will allow you to access AD data in a SharePoint List.  Not sure if BCS will allow AD to be updated from SharePoint.

You might also take a look at using System Center Orchestrator which has a SharePoint connector that allows a SharePoint list to be monitored for changes that could then be made using the AD connector.


Juan Carlos GonzalezCompartiMOSS Co-DirectorCommented:
Good morning,
You could build an Employee Directory using Search capabilities in SharePoint Online. Take a look at Marc Andersoon's approach: http://sympmarc.com/series/create-a-simple-sharepoint-2013-employee-directory-on-office365/

Kind regards,

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
j_heckAuthor Commented:
Juan, the link you shared looks exactly like what I want to do.  The only problem is that I cannot select the two options: (Windows Page) Search People and (Windows Page) Search Results.  I am not certain how to get them to show up in SharePoint 2013 with Office 365.

Kind regards,
j_heckAuthor Commented:
Juan, this seems to be the best solution for now.  Thanks for putting together such a great tutorial.  My only problem is that now I can't find the search page I just created to incorporate it into my SharePoint site.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.