I was wondering if anyone has attempted / succeeding in building an app to manage holiday / vacation requests? I have seen this type of app in demo's howevever I am struggling to get hold of a sample app to work/learn from and adapt.
I want to implement a solution that allows the user to request holiday, and then it goes for approval. The user has a summary screen of thier approved / rejected holiday. I am debating storing the data in SQL on Premises, so it is easier to report on, versus a SharePoint online lise. However I am guessing SP online will give me greater approval functionality when called from Flow?
If anyone would like to share their thoughts, etc I would really appreciate it.
** Update **
I have bulit an App using a SharePoint list then with Flow, got the approval piece working as well, which is great.
Some more points to consider which any advice on would be great.
1/ Only showing current users holiday requests, I am guessing some kind of filter?
2/ My manager commented on that he would like to be able to check his calendar to see if the leave can be approved, not sure if this can added into the approval email at all?
But for a functional prototype it kind of works, super impressed with the fact you can connect all of these datasouces so easily!
Glad to hear that it works.
For your first question, that depends on the data source, if you would like to only show some special values, we could take use of Filter function in PowerApp, the language used in PowerApp is modeled on Excel language, which should be easy to deal with:
For the second question, if the flow is using "Send an approval email", currently I can't think of an available way to involve the receiver's calendar, and the "Get Calendar" option would require the proper User (The Manager) Credentials.
What the proper way that I could think out, is the following scenario:
When a new Holiday / Vacation Request item is generated in Sharepoint, create a Flow under the Manager's credentials to get his calendar, then check to see if the holiday request would have any conflicts with the Calendar events, and involve the proper contents into the Email.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.