Forum Discussion
anonymous9376
May 05, 2022Brass Contributor
Leave Request System in SharePoint
Hi, I need to develop a Leave Request System similar to this video, https://www.youtube.com/watch?v=5DfW8yT-4NA However, that video only shows a demo of how it works but not how to develop it. Can I...
anonymous9376
May 09, 2022Brass Contributor
SteveKnutson Thank you for your help. How to deduct the leave balance if the leave is approved? Also, using Power Automate?
SteveKnutson
May 09, 2022MVP
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.
- anonymous9376May 09, 2022Brass ContributorSteveKnutson, 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.- RobElliottMay 09, 2022Silver Contributor
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.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- anonymous9376May 10, 2022Brass Contributor
RobElliottCan you please elaborate more on the 'all the approvers are in the assigned to field in the Start an approval action and set it to everyone must approve'?
Thank you.