Hey!
I have this code, which worked just fine, but now, when I use SP list called "VacationTracker", it says "the specified column DateOfRequst does not exist". First thing is that it exists and second thing is that I am not even using it in this code. Could someone help?
Switch(
typDovolene,
"Doctor",
Collect(
VacationTrackerDone,
{
Title: User().Email,
Name: User().FullName,
StartDate: StartDate.SelectedDate,
EndDate: StartDate.SelectedDate,
TypeOfVacation: Text(typDovolene),
DepartmentCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Department
),
PositionCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Position
)
}
), "Business Trip", Collect(VacationTrackerDone, {Title: User().Email,
Name: User().FullName,
StartDate: StartDate.SelectedDate,
EndDate: StartDate.SelectedDate,
Date: DateAdd(Today(),540,Minutes),
Description: txtDescription.Text,
TypeOfVacation: Text(typDovolene),
DepartmentCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Department
),
PositionCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Position
)},
"Home Office",
Collect(
VacationTrackerDone,
{
Title: User().Email,
Name: User().FullName,
StartDate: StartDate.SelectedDate,
EndDate: StartDate.SelectedDate,
TypeOfVacation: Text(typDovolene),
DepartmentCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Department
),
PositionCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Position
)
}
),
"Vacation",
Collect(
VacationTracker,
{
Title: User().Email,
Name: User().FullName,
StartDate: StartDate.SelectedDate,
EndDate: EndDate.SelectedDate,
LenghtInDays: Value(lblDaysOfVacation.Text),
TypeOfVacation: Text(typDovolene),
DepartmentCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Department
),
PositionCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Position
)
}
),
"Overtime",
Collect(
VacationTracker,
{
Title: User().Email,
Name: User().FullName,
StartDate: StartDate.SelectedDate,
EndDate: StartDate.SelectedDate,
TypeOfVacation: Text(typDovolene),
HoursOvertime: drpOvertime.SelectedText.Value,
DepartmentCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Department
)
}
),
"Halfday",
Collect(
VacationTracker,
{
Title: User().Email,
Name: User().FullName,
StartDate: StartDate.SelectedDate,
TypeOfVacation: Text(typDovolene),
HalfdayType: drpHalfday.SelectedText.Value,
PositionCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Position
),
DepartmentCopy: Text(
LookUp(
Employees,
NameOfEmployee = User().Email
).Department
)
}
)
);
