I want to start with an Excel file called PTO-Tracker1.0 to fill out requests. Once an employee is selected, the DateRequested and ReturnDate must be chosen. Then, you need to fill in the Code, hours, and partial fields, which have a drop-down menu for selection in Excel. The Excel file automatically selects the supervisor from the employee column. PTO-Tracker1.0.xlsx.
After all those fields are chosen, I want the flow to automatically include a timestamp once those fields are entered. The timestamp should be current time CST. Once that is done, it should send an approved or denied message in Teams to the supervisor from the approval map in excel. After the supervisor responds, the employee receives a notification of the decision. If approved, it should automatically update the PTO-Tracker calendar in Teams.
After being approved or denied, the request will be Archived in RequestArchive. On the Request side, there can be multiple requests for PTO. There are sections for 'No approval required' and 'Holidays'. This will also track vacation and sick days from their balance in the PTO Tracker, as set in the Settings. It does most of this but it isn't subtracting vacation and sick hours from the settings table. My formula doesn't work in excel. I also want to improve this flow to run flawless. It's my first time in power automate.
