How to refresh gallery in real time

[Filistyn]

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:

[WarrenBelz]

@Filistyn ,

What are the Items of the gallery and what is the OnSelect of the Accept and Decline buttons?

Please supply in Text.

[Filistyn]

For the whole gallery its: 

SortByColumns(Filter(VacationTracker; DepartmentCopy = lblDepartment.Text; Title <> User().Email); "Approval"; SortOrder.Descending)

Most of the items are just ThisItem.SharePointData.

If you press the button it's 

Patch(VacationTracker; ThisItem; {Approval:"Accepted"});;

same goes for the decline button.

The code, that show the date is 

If(ThisItem.TypeOfVacation = "Vacation" || ThisItem.TypeOfVacation = "Business Trip"; ThisItem.StartDate & " to " & ThisItem.EndDate; ThisItem.TypeOfVacation = "Overtime" || ThisItem.TypeOfVacation = "Halfday"; ThisItem.StartDate)

Here it just depends on what type of Time off you want to take

[WarrenBelz · Accepted solution]

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.

[Filistyn]

Hello! Thank you for your tip.

I have tried to put this code into the Gallery 

With(
   {
      wList:
      Sort(
         VacationTracker; 
         ID;
         Descending
      )
   };
   SortByColumns(
      Filter(
         wList; 
         DepartmentCopy = lblDepartment.Text; 
         Title <> User().Email
      ); 
      "Approval"; 
      Descending
   )
)

My friend asked for a Vacation while i had the gallery open and still nothing have popped up. I had to refresh the app 😞

[WarrenBelz]

@Filistyn ,

A few questions

• Are you in "Play" mode from the Design function or actually playing the app - If in the first, things do not always refresh as expected.
• Is your friend on another PC - if so does it refresh when you change something yourself actually playing the app?
• If you go out of the screen and back in again, does it refresh after a change?

You can also add a refresh button Refresh(ListName) - I have to do this at times when the filter is a bit complex.

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.

[Filistyn]

I suppose I am playin the app. I just start up Powerapps and turn the app on.

Yes, my friend is on different PC and rn we can't really test out, if things refresh for him, cuz he is a regular user so he has limited possibilities in the app.

I though about refresh button as the last option, but I think I had to add it, cuz there is no effective solution I suppose.

Gonna try few things and come back with the results.