In this blog, I will guide you through creating a fully automated Leave Approval Process using Power Automate. This solution ensures smooth communication between employees and their reporting managers or team leaders, with automated notifications and updates.
Overview
This Power Automate flow is triggered when an employee submits a leave request via Microsoft Forms. The flow determines the number of leave days and directs the request to the appropriate approver (Team Leader or Manager) based on predefined conditions. Notifications are sent to both the approver and requester, and the approval status is updated in a central record-keeping system such as an Excel file or SharePoint list.
Steps to Create a Leave Request Form in Microsoft Forms
- Open Microsoft Forms
- Go to forms.microsoft.com and log in with your Microsoft 365 account.
- Create a New Form
- Click New Form.
- Give your form a title like Leave Request Form.
- Add a short description such as “Use this form to apply for leave. The approval will be automated through Power Automate.”
- Add Form Fields
Here are the recommended fields based on your screenshot:- Employee Name → Text field (Required)
- Employee Email → Text field (Required)
- Department → Choice field (e.g., HR, IT, Finance, Sales, etc.)
- Leave Type → Choice field (e.g., Sick Leave, Casual Leave, Annual Leave, Other)
- Start Date → Date field (Required)
- End Date → Date field (Required)
- Number of Days → Text or calculated field (this will help trigger conditions in Power Automate)
- Reason for Leave → Long answer text field (Optional but useful for managers)
- Attachment (if required) → Currently, Forms does not support file upload for personal accounts, only for organizational accounts. If you’re using a corporate account, you can add a File Upload field.
- Adjust Settings
- Go to Form Settings → Select “Record name” if you want to capture the logged-in user’s details.
- Enable “Required” for critical fields like Name, Email, Start Date, End Date.
- Preview Your Form
- Click Preview to see how it looks on desktop and mobile.
- Make sure the flow of questions is simple and user-friendly.
- Share the Form
- Once ready, click Share → Copy the form link.
- This link will be used in Power Automate as the trigger (When a new response is submitted).
Steps to Create the Flow
1. Trigger: When a new response is submitted
Add ‘When a new response is submitted trigger connector’ and use the ‘Leave request form id’ here.
2. Get Response Details
- Add the Get response details connector to retrieve all the submitted data from the Microsoft Form. This ensures that all input fields, such as employee name, leave dates, and reasons for leave, are captured.
3. Convert Leave Days to Number Format
- Add a Compose connector to convert the “Number of Leave Days” field from text to a numerical format using the
int()function and use Dynamic content ‘No. of Leaves days’ This step ensures that the field can be used in conditional logic.
4. Define Approver Details in JSON Format
- Use a Compose connector to create a JSON object with the following approver details:
{ "TeamLeader": { "Name": "John Doe", "Email": "tl@example.com" }, "Manager": { "Name": "Jane Smith", "Email": "manager@example.com" } }Replace the sample data with the actual details of your organization’s team leaders and managers.
5. Parse JSON
- Add the Parse JSON connector and configure it to parse the JSON object created in the previous step. This will allow you to dynamically access approver names and email addresses in subsequent steps.
6. Add a Condition to Check Leave Days
- Use a Condition connector to evaluate whether the number of leave days is less than or equal to 2.
- If Yes: The request is sent to the Team Leader for approval.
- If No: The request is sent to the Manager for approval.
7. Start and Wait for Approval
- For both branches of the condition, add the Start and wait for an approval connector and configure it as follows:
- Approval Type: Approve/Reject – First to respond
- Details: Include the employee’s name, leave dates, and reason for leave.
- Recipient: Dynamically assign the Team Leader’s or Manager’s email from the parsed JSON object.
8. Update Approval Status in a Record
- For both branches, add an Update a row (Excel) (or similar connector like create item (SharePoint list), depending on your record-keeping system) to update the approval status and approver comments in the record. Ensure the following fields are updated:
- Approval Status: Approved/Rejected
- Approver Comments: Feedback provided by the approver
- Approver Name: Name of the person who approved or rejected the leave
9. Notify Approver and Requester
- Configure notifications for both the approver and the requester:
- Approver Notifications: Use the Teams and email connectors to notify the approver of the pending request.
- Requester Notifications: Notify the requester of the final decision via Teams and email.
10. Test the Flow
- Thoroughly test the flow by submitting a leave application through Microsoft Forms to ensure the following:
- The flow routes the request to the correct approver based on the number of leave days.
- Notifications are sent as expected.
- The approval status and comments are accurately updated in the record.
Additional Features
- Custom Responses: You can customize the approval notification to include the approver’s comments for better clarity.
- Audit Trail: Use a SharePoint list instead of an Excel file to maintain an audit trail of all leave requests and approvals.
- Escalations: Add a timed condition to escalate the request if the approver does not respond within a specified period.
Conclusion
This automated leave approval process reduces manual intervention, ensures timely approvals, and keeps all stakeholders informed. By leveraging Power Automate’s versatile connectors and dynamic capabilities, you can streamline this crucial HR function and improve employee satisfaction.
Feel free to implement this flow and customize it as per your organizational needs. Let me know in the comments if you have any questions or face any issues!
