Others

How to Track Monthly Employee Leave with SharePoint and Power Automate

Maira Mehtab Sep 27, 2026 870 views

Question details

The user wants to track each employee's monthly leave usage and restrict new applications once a defined monthly limit is reached.

Product: SharePoint and Power Automate
Device & OS: not provided
Scenario: Setting up an automated HR system to monitor employee leave requests and enforce monthly allowance policies.
Observed behavior: Requires a custom automated workflow to calculate leave days dynamically and prevent submissions that exceed the allowed threshold.

Before you start

Ensure you have owner permissions for the target SharePoint list and an active Power Automate license to build and test custom workflows.

Solution 1Recommended

Build a Custom Power Automate Flow for Leave Tracking

Create a flow that triggers upon a new leave request, calculates the total approved days for the current month, and enforces the monthly limit.

By integrating your SharePoint leave list with a custom Power Automate flow, you can fully automate employee leave tracking. The flow will handle the logic of counting past requests and validating them against company policy limits.

Set Up the Trigger

In Power Automate, create an automated cloud flow and select the trigger 'When an item is created' pointing to your SharePoint leave request list.

Identify Employee and Month

Initialize variables to capture the Employee ID from the created item and the current month to ensure you only count recent leave records.

Count Approved Leave Records

Add a 'Get items' action to retrieve all records from the SharePoint list where the Employee ID matches and the status is approved or submitted for the current month.

Compare Against the Monthly Limit

Use a 'Condition' control to check if the total requested days plus the already approved days exceed your predefined monthly limit.

Send Notifications and Update Status

If the limit is exceeded, use the 'Send an email (V2)' action to notify the employee that their request is denied, and update the SharePoint item status to rejected.

Seek Community Expertise: Because list structures vary greatly, it is highly recommended to share your specific SharePoint schema and requirements in the Microsoft Power Automate Community for detailed design assistance.

Free Microsoft Office alternative

Manage Employee Leave Efficiently with WPS Office

If setting up complex Power Automate flows is too time-consuming, WPS Office provides a lightweight, highly compatible alternative for everyday document and spreadsheet management. You can easily track employee leave using free, ready-made spreadsheet templates.

1. Open WPS Spreadsheets: Launch WPS Office and click on 'Spreadsheets' to create a new document.
2. Find a Leave Tracker Template: Go to the Template library and search for 'Leave Tracker' or 'Attendance' to find pre-formatted HR spreadsheets.
3. Manage Limits Manually: Input your employee data and use built-in Excel-compatible formulas like SUMIFS to easily monitor monthly leave limits without coding.

Free, lightweight, and easy to use without complex setupFully compatible with Microsoft Excel (.xlsx) formats for seamless trackingFamiliar UI that requires zero learning curveRich library of free spreadsheet templates for HR and leave management

microsoft office alternative - wps office

Frequently Asked Questions

Can I prevent users from submitting a leave request in SharePoint if they exceed their limit?

While you cannot physically block the form submission natively in a basic SharePoint list, you can use Power Automate to immediately reject the application, delete the list item, and email the user if their calculated monthly leave balance exceeds the defined limit.

How do I calculate total leave days in Power Automate?

You can use an OData filter query within the 'Get items' action to retrieve only records for a specific employee in the current month. Then, use an 'Apply to each' loop and a float variable to sum up the total requested days before comparing it to the limit.

Where can I get help designing complex Power Automate flows?

The official Microsoft Power Automate Community forums are the best resource. Sharing your exact SharePoint list columns and your workflow requirements there will allow community experts to provide tailored step-by-step guidance.

Office Quick Solutions