79318107

Date: 2024-12-30 16:39:14
Score: 0.5
Natty:
Report link

Fixed it. The issue was in the look up.

If(
!IsBlank(Dropdown_Employee_New.Selected) && Slider_Days.Value > 0,  // Ensure a valid employee and positive days

// Update the TotalLeave in EmployeeLeaveBalances
Patch(
    EmployeeLeaveBalances,
    LookUp(EmployeeLeaveBalances, EmployeeEmail = Dropdown_Employee_New.Selected.EmployeeEmail),
    {
        TotalLeave: LookUp(EmployeeLeaveBalances, EmployeeEmail = Dropdown_Employee_New.Selected.EmployeeEmail).TotalLeave 
                    - Slider_Days.Value  
    }
);
Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Stanners