I want to create something easier for my colleagues.
We have a rota and leave process which is very messy
current process...
Staff wants leave > check capacity rota to see if time is available > submit leave request > Admin receive request > Admin update rota > send update to manager > Update staffs leave card
This is all done by excel spreadsheets
problem is how many steps there are and sometimes my manager doesn't see the leave request too.
I want something like...
Staff member wants to submit leave > checks leave rota (not sure if an excel sheet is the best way to present this) > requests leave (via powerapp/forms) > automatic approval sent to manager > once manager approves this is automatically sent to admin team > they then amend rota?
something like that.
Wasn't sure on the best way to do it...
forms then powerapp?
Sharepoint site with list and automation?
any help would be appreciated