Forum Discussion
Leave Request System in SharePoint
Hi RobElliott, thank you for your reply. I have used Power Apps to develop Leave Request but only halfway because my organization decides to use SharePoint for the system, similar to the video I posted earlier. Do you know how to do the leave request system without any 3rd part tools in Sharepoint using the site and customizable web parts?
Thank you.
anonymous9376 to do this using SharePoint and Power Automate (no premium connectors required, so you can use the license included in most subscriptions - Business and Enterprise plans)
Do something like this:
- Create a SharePoint List with the columns you want to capture for the leave request - leave type (choice list), start and end dates, comments, leave approval status
- Create a Power Automate workflow to run when an item is submitted - creates an approval request for the manager
- Once approved, update the List item to set the leave approval status
- Email the requestor with the outcome of the approval
- Email Payroll with leave details
- Create views so Payroll can see approved leave
I hope this helps point you in the right direction
- SteveKnutson Thank you for your help. How to deduct the leave balance if the leave is approved? Also, using Power Automate?
- To do that you would need to store the leave balance against each employee. I would do this in a seperate list, so you can limit who can see the leave balance (List Settings -> Advanced) and then use Power Automate to update the value when the leave is approved.
- SteveKnutson, Okay, thank you for your help. Right now I'm doing the approval workflow. I'm required to have multi-level approval that checks the employee's approval type from an employee list. May I know how to do this in the Power Automate?
Thank you.
SteveKnutson what about integrating power apps with that too, like having the employee submit the request through the app which triggers the automated flow?
MoAlsalman yes, that will work. In my notes above, the SharePoint List form can be customised with PowerApps or you can use a Standalone PowerApp.
