Comprehensive Guide to Creating a SharePoint Leave Request System

INTRODUCTION In today’s fast‐paced work environment, streamlining leave management can boost efficiency and transparency. This guide will show you how to build a dedicated SharePoint site to manage leave requests. In our scenario, the site will have six members: five workers who submit leave requests and one manager responsible for approving or rejecting them. One worker will receive full permissions on the leave request list (allowing, for example, advanced modifications or administrative tasks on that list), while the other four workers are given edit permissions. The manager will process the requests by approving two and rejecting three. Additionally, custom views will allow each member to quickly see the status of their submissions. This guide provides a step-by-step approach to creating a SharePoint site for managing employee leave requests. The solution includes: A Team Site with six members (five workers, one manager). A Leave Request List where workers submit requests. Permissions: One worker has full control over the list, while others can only edit their own requests. Approval Workflow: The manager approves/rejects requests, and all members see their request status. Step 1: Create a SharePoint Team Site Navigate to SharePoint Admin Center: Go to your organization’s SharePoint portal. Click Create site > Team site. Configure Site Details: Name: "Leave Management Site". Add a description (optional). Under Privacy, select "Private". Select the default site language for your site. You can't change this later. Click Next. - Add Members: Add the manager’s email under "Add additional owners". Add five workers’ emails under "Add members". Click Finish. Step 2: Create a Leave Request List Navigate to the New Site: Open the newly created site. - Click + New > List > Blank list. Name the List: Title: "Leave Requests". Click Create. Add Columns: Default "Title" column: Rename to Leave Type (e.g., Vacation, Sick). Start Date: Column type = Date. Follow the same step and the below columns Requester: Column type = Person End Date: Column type = Date. Status: Column type = Choice (Options: Pending, Approved, Rejected). Comments: Column type = Multiple lines of text. Step 3: Configure Permissions Goal: staff 1: Full control over the list. Staff 2-5: Edit only their own items. Manager: Approve/reject requests. Break List Inheritance: - Go to Leave Requests list > Settings (⚙) > List settings. - Under Permissions, click Permissions for this list. - Click Stop Inheriting Permissions. - Remove Default Groups: Select Members and Visitors groups > Remove User Permissions. Assign Custom Permissions: Staff 1 (Full Control): Click Grant Permissions. Enter Staff 1 (Hagital JanGrp1) email or name. Select Full Control > Share. Staff 2-5 (Edit Access): Click Grant Permissions. Enter Staff 2-5 emails. Select Edit > Share. Manager Permissions: The manager is already in the Owners group (Full Control). - Restrict Item Editing: Go to List Settings > Advanced Settings. Under Item-level Permissions: Set Edit access to Only their own. Step 4: Enable Content Approval - Configure Versioning: Go to List Settings > Versioning Settings. Under Content Approval, select Yes. Click OK. Update Status Column: The default Approval Status column will now track requests as Pending/Approved/Rejected. Step 5: Test the Workflow - Staffs Submit Requests: Staff 1 add items via + New. Status defaults to Pending. Staff 2 add items via + New. Status defaults to Pending. Staff 3 add items via + New. Status defaults to Pending. Staff 4 add items via + New. Status defaults to Pending. Staff 5 add items via + New. Status defaults to Pending. Manager Approval/Rejection: Manager navigates to Dashboard. Select a request > Edit. Update Status to Approved or Rejected. Add Comments (optional). Follow the same step to Approve or Reject for other Staffs NOTE : All the approved leave request is visible to all staffs in the department (ie Hagital Grp2 Dashboard) - Hagital Grp3 can see his leave request which was rejected and can also see other staffs leave request which was approved Conclusion I’ve successfully built a SharePoint site for managing leave requests with granular permissions and approval workflows. Key outcomes: Staff 1 manages the list with full control. Staff 2–5 submit and edit their own requests. Manager approves/rejects requests via dashboard. All members view personalized statuses. This solution ensures transparency, accountability, and streamlined communication for leave management.

Mar 22, 2025 - 14:07
 0
Comprehensive Guide to Creating a SharePoint Leave Request System

INTRODUCTION

In today’s fast‐paced work environment, streamlining leave management can boost efficiency and transparency. This guide will show you how to build a dedicated SharePoint site to manage leave requests. In our scenario, the site will have six members: five workers who submit leave requests and one manager responsible for approving or rejecting them. One worker will receive full permissions on the leave request list (allowing, for example, advanced modifications or administrative tasks on that list), while the other four workers are given edit permissions. The manager will process the requests by approving two and rejecting three. Additionally, custom views will allow each member to quickly see the status of their submissions.

Image description

This guide provides a step-by-step approach to creating a SharePoint site for managing employee leave requests. The solution includes:

  • A Team Site with six members (five workers, one manager).
  • A Leave Request List where workers submit requests.
  • Permissions: One worker has full control over the list, while others can only edit their own requests.
  • Approval Workflow: The manager approves/rejects requests, and all members see their request status.

Step 1: Create a SharePoint Team Site

  1. Navigate to SharePoint Admin Center:
  2. Go to your organization’s SharePoint portal.
  3. Click Create site > Team site.

Image description

Configure Site Details:

Name: "Leave Management Site".
Add a description (optional).

Image description

  • Under Privacy, select "Private".
  • Select the default site language for your site. You can't change this later.
  • Click Next.

Image description

- Add Members:

  • Add the manager’s email under "Add additional owners".
  • Add five workers’ emails under "Add members".
  • Click Finish.

Image description

Step 2: Create a Leave Request List

  • Navigate to the New Site:
  • Open the newly created site.

Image description

- Click + New > List > Blank list.

Image description

Image description

Name the List:

Title: "Leave Requests".
Click Create.

Image description

Add Columns:

  • Default "Title" column: Rename to Leave Type (e.g., Vacation, Sick).
  • Start Date: Column type = Date.

Image description

Follow the same step and the below columns

  • Requester: Column type = Person
  • End Date: Column type = Date.
  • Status: Column type = Choice (Options: Pending, Approved, Rejected).
  • Comments: Column type = Multiple lines of text.

Image description

Step 3: Configure Permissions

Goal:

  1. staff 1: Full control over the list.
  2. Staff 2-5: Edit only their own items.
  3. Manager: Approve/reject requests.

Break List Inheritance:

- Go to Leave Requests list > Settings (⚙) > List settings.

Image description

- Under Permissions, click Permissions for this list.

Image description

- Click Stop Inheriting Permissions.

Image description

- Remove Default Groups:

Select Members and Visitors groups > Remove User Permissions.

Image description

Assign Custom Permissions:

Staff 1 (Full Control):

  • Click Grant Permissions.
  • Enter Staff 1 (Hagital JanGrp1) email or name.
  • Select Full Control > Share.

Image description

Staff 2-5 (Edit Access):

Click Grant Permissions.
Enter Staff 2-5 emails.
Select Edit > Share.

Image description

Manager Permissions:

The manager is already in the Owners group (Full Control).

Image description

- Restrict Item Editing:

  • Go to List Settings > Advanced Settings.

Image description

  • Under Item-level Permissions:
  • Set Edit access to Only their own.

Image description

Step 4: Enable Content Approval

- Configure Versioning:

Go to List Settings > Versioning Settings.

Image description

Under Content Approval, select Yes.
Click OK.

Image description

Update Status Column:

The default Approval Status column will now track requests as Pending/Approved/Rejected.

Step 5: Test the Workflow

- Staffs Submit Requests:

  • Staff 1 add items via + New.
  • Status defaults to Pending.

Image description

Image description

  • Staff 2 add items via + New.
  • Status defaults to Pending.

Image description

  • Staff 3 add items via + New.
  • Status defaults to Pending.
    Image description

  • Staff 4 add items via + New.

  • Status defaults to Pending.

Image description

  • Staff 5 add items via + New.
  • Status defaults to Pending.

Image description

Manager Approval/Rejection:

  • Manager navigates to Dashboard.

Image description

  • Select a request > Edit.

Image description

  • Update Status to Approved or Rejected.
  • Add Comments (optional).

Image description

Follow the same step to Approve or Reject for other Staffs

Image description

NOTE : All the approved leave request is visible to all staffs in the department (ie Hagital Grp2 Dashboard)

Image description

- Hagital Grp3 can see his leave request which was rejected and can also see other staffs leave request which was approved

Image description

Conclusion

I’ve successfully built a SharePoint site for managing leave requests with granular permissions and approval workflows. Key outcomes:

  • Staff 1 manages the list with full control.
  • Staff 2–5 submit and edit their own requests.
  • Manager approves/rejects requests via dashboard.

All members view personalized statuses.

This solution ensures transparency, accountability, and streamlined communication for leave management.