Solved: How to refresh gallery in real time

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:

Categories:

Connecting to Data

General Questions

Dataflows

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.