Hi, I need to develop a Leave Request System similar to this video, https://www.youtube.com/watch?v=5DfW8yT-4NAHowever, that video only shows a demo of how it works but not how to develop it. Can I know how to develop the system similar to that video step by step without any help from any 3rd party tools? As I'm totally a beginner at SharePoint? Thank you. RobElliott Adin_Calkic SteveKnutson Kerem Yuceturk John Wynne ganeshsanap ChrisWebbTech VesaJuvonen Mark-Kashman jcgonzalezmartin Dean_Gross Brent Ellis

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

anonymous9376 that used a set of paid 3rd party tools from Infowise, so it wasn't with out-of-the-box SharePoint functionality. And it's now quite an old video. We now have Power Apps where, if it's one of your Office 365 apps, you can develop a full leave system with no/low code. But there is quite a learning curve with Power Apps as well as needing to know a bit about SharePoint. Reza Dorrani has produced a Power Apps Leave Request video at https://www.youtube.com/watch?v=0U5jax-zMIc and April Dunnam has also done one at https://www.youtube.com/watch?v=S-YUearXrBA. I also highly recommend the videos on YouTube by Shane Young, for example there is one on getting started with Power Apps at https://www.youtube.com/watch?v=kA5xUtrM6bo RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

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.

anonymous9376 assuming your approval type list has a title column for the employee email and another column for the approval type, you would use the get items action and set a filter query to Title eq 'the column in your approval list where you've got the employee's email'. That would just bring back 1 item but would create an apply to each which is expected behaviour. Your multi-level approval could be done in 2 ways: either all the approvers are in the assigned to field in the Start an aproval action and you set it to everyone must approve, or you have a condition that if the first approval is Approve then start an approval for the second approver, otherwise do nothing etc. RobLos GallardosMicrosoft Power Automate Community Super User

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.

Leave Request System in SharePoint | Microsoft Community Hub

11 Replies

RobElliott
Silver Contributor
May 05, 2022
anonymous9376 that used a set of paid 3rd party tools from Infowise, so it wasn't with out-of-the-box SharePoint functionality. And it's now quite an old video.

We now have Power Apps where, if it's one of your Office 365 apps, you can develop a full leave system with no/low code. But there is quite a learning curve with Power Apps as well as needing to know a bit about SharePoint. Reza Dorrani has produced a Power Apps Leave Request video at https://www.youtube.com/watch?v=0U5jax-zMIc and April Dunnam has also done one at https://www.youtube.com/watch?v=S-YUearXrBA. I also highly recommend the videos on YouTube by Shane Young, for example there is one on getting started with Power Apps at https://www.youtube.com/watch?v=kA5xUtrM6bo

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- anonymous9376
  Brass Contributor
  May 05, 2022
  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.
  - SteveKnutson
    MVP
    May 07, 2022
    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

Forum Discussion

Leave Request System in SharePoint

11 Replies

Resources