Forum Discussion
Vacation/Leave tracker
Hi All,
I am creating a Leave tracker, Basically what I have done so far is.
-Create a form for leave submission.
-Link it to approvals so it basically retrieved manager details and sends approval request via Outlook/Teams.
-Create a SPO list item to update and save requests.
-Once approval is received the SPO list item is updated to have a status approved.
-This triggers email notification to the requestor.
-A calendar event is updated in a shared calendar.
What I would like to add/Improve is:
-Check before sending approval request to see if balance has enough days for the leave requested.
-Tracking for vacation balance. i.e. deduct approved days from balance.
-For Calendar events to cover all days of the leave in case it is more than one days. Current Create event, Creates only one day.
I tried multiple methods that did not work, Any Idea how to achieve this??
If you build it in Power Apps with SharePoint lists as the backend you could get it to check the leave balance before the user is able to submit the request. So if they only had 5 days left they would not be able to submit a request for 7 days leave.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
