cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmchx
Helper III
Helper III

leave request template - customize

Hi expert,

I'm still stuck to customizing the leave request app.

1. each user can see their current balance of each type, so this means the current balance of each type and each user will be different. for example User A sick leave current balance: 3 days, annual leave 10days

                    User B sick leave current balance 5 days, annual leave 5 days

this one can we use the SharePoint list to do it? , I am still stuck on how to update the new current balance store in the SharePoint and show it in the power apps. I want the users to see like this which seems like not working when using the gallery.

mmchx_2-1637742255557.png

 

2. user can select the type of dates such as a day off / half-day off both on the start date and end date

not sure this calculation is correct haha.

mmchx_1-1637742157915.png

 

 

If(Dropdown_start.SelectedText.Value = "afternoon off" & (Dropdown_end.SelectedText.Value = "morning off" || Dropdown_end.SelectedText.Value = "afternoon off",
    RoundDown(DateDiff(LeaveStartDatePicker_3.SelectedDate, LeaveEndDatePicker_3.SelectedDate, Days) / 7, 0) * 5 +
    Mod(5 + Weekday(LeaveEndDatePicker_3.SelectedDate) - Weekday(LeaveStartDatePicker_3.SelectedDate), 5)
    - CountIf(HolidaysCollection,Date>=LeaveStartDatePicker_3.SelectedDate,Date<=LeaveEndDatePicker_3.SelectedDate)
-1,
If(Dropdown_start.SelectedText.Value = "afternoon off" & (Dropdown_end.SelectedText.Value = "a day off",
    RoundDown(DateDiff(LeaveStartDatePicker_3.SelectedDate, LeaveEndDatePicker_3.SelectedDate, Days) / 7, 0) * 5 +
    Mod(5 + Weekday(LeaveEndDatePicker_3.SelectedDate) - Weekday(LeaveStartDatePicker_3.SelectedDate), 5)
    - CountIf(HolidaysCollection,Date>=LeaveStartDatePicker_3.SelectedDate,Date<=LeaveEndDatePicker_3.SelectedDate)
-0.5

 

 

 3. the current balance needs to update when the request has been approved.

0 REPLIES 0

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,391)