Hey! I am working on Time off app. I have this issue, hope someone can help.
If an employee asks for a vacation, it saves the info in the sharepoint list and it shows in my gallery. The thing is that the gallery is not refresing in real time, meaning I have to refresh the whole app to see the request. Could someone help?
The gallery:
And the sharepoint list:
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.
WarrenBelz
250
Most Valuable Professional
MS.Ragavendar
126
stampcoin
110