Hi @Filistyn ,
Firstly, the issue is not obvious presently as the gallery Items
SortByColumns(
Filter(
VacationTracker;
DepartmentCopy = lblDepartment.Text;
Title <> User().Email
);
"Approval";
SortOrder.Descending
)
are directly querying the list and should refresh. One issue here is that the <> operator is not Delegable, so you could try this
With(
{
wList:
Sort(
VacationTracker;
ID;
Descending
)
};
SortByColumns(
Filter(
wList;
DepartmentCopy = lblDepartment.Text;
Title <> User().Email
);
"Approval";
Descending
)
)
The Patch code should work although I tend to be record specific
Patch(
VacationTracker;
{ID:ThisItem.ID};
{Approval:"Accepted"}
);;
The Date should refresh as long as the gallery contains the current record details
If(
ThisItem.TypeOfVacation = "Vacation" ||
ThisItem.TypeOfVacation = "Business Trip";
ThisItem.StartDate & " to " & ThisItem.EndDate;
ThisItem.TypeOfVacation = "Overtime" || ThisItem.TypeOfVacation = "Halfday";
ThisItem.StartDate
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
