Power Platform Community Forum Thread Details

I've set up a radio control on annual leave request to adjust the time booked off for half-day and third-day requests.

The OnSelect property of LeaveDateStartPicker is:

//**** CALCULATION USED TO DETERMINE TOTAL WORK DAYS REQUESTED ****

If(LeaveStartDatePicker.SelectedDate <= LeaveEndDatePicker.SelectedDate,
 Set(_inclusiveTotalDaysRequested, DateDiff(LeaveStartDatePicker.SelectedDate, LeaveEndDatePicker.SelectedDate, Days) + 1);
 Set(_numFullWeeks, RoundDown(_inclusiveTotalDaysRequested / 7, 0));
 Set(_numFullDaysPartialWeek, _inclusiveTotalDaysRequested - _numFullWeeks * 7);
 Concurrent(Set(_startWeekday, Weekday(LeaveStartDatePicker.SelectedDate)), Set(_endWeekday, Weekday(LeaveEndDatePicker.SelectedDate)));
 //calculates the number of business days in the partial week left over after whole weeks are subtracted out of total days requested
 If(_numFullDaysPartialWeek = 6, 
 If(_startWeekday <= 2, Set(_numPartialWeekdays, 5), Set(_numPartialWeekdays, 4)
 ),
 _numFullDaysPartialWeek = 5,
 If(_startWeekday = 2, Set(_numPartialWeekdays, 5), _startWeekday = 1 || _startWeekday = 3 || _startWeekday = 4, Set(_numPartialWeekdays, 4), Set(_numPartialWeekdays, 3)
 ),
 _numFullDaysPartialWeek = 4,
 If(_startWeekday = 2 || _startWeekday = 3, Set(_numPartialWeekdays, 4), _startWeekday = 1 || _startWeekday = 4, Set(_numPartialWeekdays, 3), Set(_numPartialWeekdays, 2)
 ),
 _numFullDaysPartialWeek = 3,
 If(_startWeekday = 6 || _startWeekday = 7, Set(_numPartialWeekdays, 1), _startWeekday = 1 || _startWeekday = 5, Set(_numPartialWeekdays, 2), Set(_numPartialWeekdays, 3)
 ),
 _numFullDaysPartialWeek = 2,
 If(_startWeekday = 7, Set(_numPartialWeekdays, 0), _startWeekday = 1 || _startWeekday = 6, Set(_numPartialWeekdays, 1), Set(_numPartialWeekdays, 2)),
 _numFullDaysPartialWeek = 1,
 If(_startWeekday = 1 || _startWeekday = 7, Set(_numPartialWeekdays, 0), Set(_numPartialWeekdays, 1)
 ),
 _numFullDaysPartialWeek = 0, Set(_numPartialWeekdays, 0)
 );
If(Radio2forLeaveStartDatePicker.Selected.Value="Third Day - AM" && _startWeekday<>1&&_startWeekday<>7, Set (_numPartialWeekdays, _numPartialWeekdays-0.66));
If(Radio2forLeaveStartDatePicker.Selected.Value="Third Day - PM" && _startWeekday<>1&&_startWeekday<>7, Set (_numPartialWeekdays, _numPartialWeekdays-0.66));
If(Radio2forLeaveStartDatePicker.Selected.Value="Half Day - AM" &&_startWeekday<>1&&_startWeekday<>7, Set(_numPartialWeekdays, _numPartialWeekdays-0.5));
If(Radio2forLeaveStartDatePicker.Selected.Value="Half Day - PM" &&_startWeekday<>1&&_startWeekday<>7, Set(_numPartialWeekdays, _numPartialWeekdays-0.5));
 Set(_workDaysInRequest, _numFullWeeks * 5 + _numPartialWeekdays); 
 Set(_holidaysInRequest, CountIf(Holidayss, cr72e_startdate >= LeaveStartDatePicker.SelectedDate, cr72e_startdate <= LeaveEndDatePicker.SelectedDate));
 Set(_requestedDays, _workDaysInRequest - _holidaysInRequest)
);

The live balance counter works correctly:

Untitled video - Made with Clipchamp.gif