Skip to main content

Successful Integration of SharePoint for HR Departments

Technical and pre-sales support, SharePoint administration.
Elissa Caligiuri
18 July 2018
SharePoint for HR Departments


This article aims to solve a common challenge when creating solutions in SharePoint. We discuss how to deliver a solution built in SharePoint to end users and critical team members, as well as exploring how we can personalize the SharePoint user experience for staff and team managers by using SharePoint and OnePlaceLive.


Industry: Human Resources department


This scenario discusses a Human Resource (HR) system which uses a team site for the HR team. The HR department uses document libraries and document sets to administrate and manage employee records. These are also accessible to each department manager, and each individual employee.

Within the company Initech, each employee is managed by their direct manager. A member of the HR team is also appointed several teams to manage from a human resources perspective.
Each employee has a document set created for them upon commencement of their contract. Only they, their direct manager and the HR team have permission to view this document set. Each document set is created by a template and includes areas for training, development, reviews, and a log of annual leave requests.

User stories demonstrated

  • HR Manager for Initech – Tom Brown
  • Manages the Sales team for Initech – Sally Jones
  • Employee of Initech - David Smith

Information architecture

There is one HR team site, with a series of document libraries relating to different services. There is a document library containing all personnel records, which contains a document set created for each employee.

Series of document libraries relating to different services

A document set is created per employee, based on a template. The metadata for these document sets include:

  • Name
  • Employee ID
  • Team 
  • Position
  • Reports to
  • Employee Type (Permanent or contract staff).

hr document set


What is possible using OnePlaceLive & Solution Profiles

  • Personalize staff members SharePoint experience, by delivering their information directly to them in applications they are familiar with
  • Remove the noise and clutter of too much information being available for HR and department team managers
  • Use SharePoint security trimming to ensure information is kept restricted, and available to those who need it
  • Deliver correct and timely information to relevant people in the organization
  • Dynamically plan for growth and staff changes – as teams grow and change this information is delivered to those who need to be kept informed. Using browse metaphors, these are based off relevant metadata that is proactively delivered – removing the complexity of a large HR site, as well as reducing outdated information
  • Improve user adoption and visibility of HR systems, including policies and procedures to employees
  • Proactive delivery of updated HR information to employees
  • Personalized views of employee information.

User Story: Tom Brown - HR Manager

Using OnePlaceLive, it is possible to create a Solution Profile to directly deliver SharePoint locations and content directly where employees work in Outlook or via OnePlaceDocs.

Tom, as HR Manager manages different teams across a range of locations. Tom needs to see information for these employees, as well as be across the broader information that is shared from the human resources department. He needs to access this information quickly, as well as be able to save with ease to these locations, without wasting time constantly searching for what is relevant to him.

Using OnePlaceLive, it is possible to show these staff members in one profile directly where they work in Outlook or via OnePlaceDocs.

Solution Profile in Outlook

sharepoint hr solution profile



As Human Resources Manager, Tom manages both the IT & Sales team. There are times when Tom wants to see all staff members in the company, however his primary needs are to access information for those team members he directly manages.

The Personnel Records document library in SharePoint contains a document set created for each employee where this information is stored.

Viewing the contents of this library in SharePoint, we can see there is a column named HR Manager which lists all the staff that Tom is managing:

sharepoint hr personnel records

We can create a view in SharePoint, where we filter the view by ‘Reports to’ = Me – will refine this view to staff that Tom needs to view throughout his working day.

sharepoint hr view 2

 We can now create a Solution Profile based off this view:

  1. Create a new ‘Item’ in the Solution Profile – select Central Register
  2. Enter the list name, and set the type of register to “Document Set”
  3. Select the “Base query on Central Register view filter” and select the view that was created in SharePoint

sharepoint hr create solution profile


In Outlook or via OnePlaceDocs, by clicking on this new Solution Profile, Tom sees only the staff that belong to the departments he is managing:

sharepoint hr staff i manage


There may be times that Tom needs to access all employees within the organisation. We can create a search query to bring back these document sets and allow for free text search – where Tom is able to refine this in the search box.

sharepoint hr refine searchbox

Search is useful when there is a large amount of data that navigating or browsing through would be time consuming and inefficient. In OnePlaceLive, we’re able to configure a location that will just search across the employee document sets.

Tom is looking for Amy Fry’s account:

sharepoint hr find account

We can now see a specific user’s details.


sharepoint hr specific user

This can be configured in OnePlaceLive as a location based search:

sharepoint hr location based search


Tom is also the Human Resources General Manager, he needs to manage staff who are on fixed contracts. When a document set is created in SharePoint, the contract type is added with a choice of permanent staff or contact staff.

Using the power of the Central Register, we’re able to deliver this information directly, without requiring Tom to go searching for this when he needs it.

We can create a view in SharePoint to show when the Employee Type is set to Contract. Further to this, as our document sets are created with the same structure, we can return just the contract subfolder – we do this by using a “descendant location” in OnePlaceLive, Central Register settings:

sharepoint hr central register

When viewing this in OnePlaceMail or OnePlaceDocs, we can see a refined view of this specific piece of information we need access to:

sharepoint hr central register settings

Building on the managing of staff on a contract, it is also possible to surface time critical information, such as a notification when am employee’s contract is nearing its completion date.

This is achieved by:

  • 1. Create a calculated column in the library (name: ‘Contracts Ending’ This is calculated from the Contract End date column – 2 months:
  • sharepoint hr create calculated column

    2. Create a view “Action Contract” based with a filter to show items where the Employee Type = Contract + the Contract end date is less than or equal to [Today]+60

    sharepoint hr emplyee type


    In this example, we can see Aiden Long’s contract is due to expire on 5th of October 2017, and Alex’s is not due to expire until June 2018

    sharepoint hr expiration advise screen


    The Human Resources team are alerted that they need to either extend or prepare to end the contract for Aidan, within 60 days:

    sharepoint hr advise screen


    Team Manager

    A team manager needs to keep up to date on their employee’s leave, position profile and performance reviews. They also need to be able to save information in an easy manner into their respective staff’s folder.

    Sally is the Sales Manager, using OnePlaceLive she can view all the members of her team, in one central location.

    Reviewing the personnel records in SharePoint, we can see a few team members are listed, with two reporting directly to Sally.

    sharepoint hr personnel records 2

    In SharePoint, we can create a view where the ‘Reports to’ is equal to ‘Me’. This allows us to only show the staff members that Sally is managing via OnePlaceMail and OnePlaceDocs.

    In our Solution Profile, we can use the Central Register profile item to identify the staff that report to Sally. We use the key columns of

    • Employee Name
    • Department
    • Reports To – to identify those who report to Sally.

    Staff I Manage

    sharepoint hr staff managed 2


    User Story: Employee of Initech – David Smith

    From an employee’s perspective, they need to see their personal information in an easy manner. They also need to keep up to date on policies and procedures and any job opportunities that might arise internally. They don’t want to go looking for this information across a number of systems.

    Using OnePlaceLive, and the capability of SharePoint permissions this can be delivered directly to where users work. We are able to personalize their user experience when accessing content in SharePoint enabling users to do more, simply.

    A Solution Profile be created for their own document set, which is labelled ‘My HR’. David can update his annual leave, kick off workflows and keep up to date on internal information.

    Outlook: “My HR” > My Information: David only sees his information.

    The HR Solution Profile is also accessible whenever staff interact with SharePoint via OnePlaceMail or OnePlaceDocs allowing for drag/drop of files to these locations.

    sharepoint hr drag drop

    David can see important company information as soon as these are posted:

    sharepoint hr folders my info

    Part of the review process for each staff is to fill out a template with rating for each KPI. David can fill out his performance review form, and save this directly to his document set, for his Manager and HR Manager to review.

    sharepoint hr save to sharepoint

    This article has shown how OnePlaceLive and Solution Profiles work to personalize SharePoint for the end user, drive user adoption and allow users to access existing files, that are important to them. OnePlaceLive overcomes challenges of sharing information in a dynamic way, and overcomes challenges of building robust and scalable solutions on SharePoint/365.

    Latest news & blogs

    | Jessica Mckenzie | Blog

    ESPC23 Unwrapped: Navigating the Future with Microsoft Innovations

    Europe’s top Microsoft technologies conference, ESPC23 took place last week, and we were there, thrilled to be part of it!

    This event delivers the opportunity to learn the most up-to-date practices, advice, and techniques from the finest Microsoft 365, SharePoint, Teams, Power Platform, and Azure experts globally, including Microsoft Product team members and independent community leaders, including Regional Directors (RDs), MVPs, and Microsoft Certified Masters (MCMs). Because of this, an extraordinary community of like-minded people converge!

    Thank you to everyone who visited our booth during the event or the demo in the community area – it was great to meet old and new faces alike, and hear your feedback and ideas – it shapes our future, so stay tuned for what's to come! If you would like to continue the conversation, please contact us.

    Here are key takeaways from ESPC23:

    Microsoft 365 Co-Pilot – The Next Big Thing!

    • Co-Pilot emerged as a game-changer, but success hinges on quality data input
    • Ensure data is centrally stored and easily accessible to maximize Co-Pilot's capabilities
    • Data cleanliness is paramount – you get out what you put in! Prioritize accurate data for Co-Pilot effectiveness
    • Eliminate outdated or conflicting data to prevent confusion and enhance Co-Pilot's decision-making prowess

    SharePoint Embedded Public Preview - Now Available

    • Explore a revolutionary way to build custom content apps for enterprises and ISVs with SharePoint Embedded, now available for public preview.
    • Learn more about this exciting development announced at ESPC23.

    The New Microsoft Teams Client: Performance, Rollout, and Feature Parity

    • Since Microsoft announced the general availability of the new rebuilt Teams client in October, ESPC23 delved into discussions about performance enhancements, technical rollout, change management, and achieving feature parity with Teams classic.
    • Discover the ins and outs of the new Microsoft Teams client Introducing the new Microsoft Teams client – Teams | Microsoft Learn

    In-Person Conferences: The Power of Connection and Networking

    • Despite the digital era, in-person conferences remain an invaluable way to connect and network.
    • A Microsoft MVP captured the sentiment: "This is the only time I see people in person; I'm now 100% remote. I feel like this is my chance to come to the office and talk with my fellow speakers."

    To learn more and explore how we provide a streamlined and consistent approach way for people to engage with business systems built on Microsoft 365 for better information management and governance, contact us for a personalized demo.

    | Jessica Mckenzie | Blog

    ESPC23: Visit the top European Microsoft Conference

    Join us at the top European Microsoft Conference, ESPC23 - where an extraordinary community converges to explore the latest innovations and trends in the realm of Microsoft technologies

    | Jessica Mckenzie | Upcoming

    ESPC23 Amsterdam

    Join us for Europe’s top Microsoft technologies conference, ESPC23, 27th – 30th November 2023, in Amsterdam.

    At ESPC, you will hear the latest expertise on Copilot, Microsoft Teams, AI, Azure, Microsoft Viva, Microsoft Graph, Microsoft Power Platform, Governance, CoE, SharePoint, Migrations, PowerShell.

    Schedule a demo

    See the OnePlace Solutions product suite in action and unlock the potential of your data by leveraging the SharePoint platform.

    Try free

    Download and try the full OnePlace Solutions product suite for Windows Desktop and Apps for Microsoft 365.

    Contact us

    We're here to help, so please don’t hesitate to get touch with any questions you may have.