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:
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.
A few questions
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.
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 😞
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.
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
What are the Items of the gallery and what is the OnSelect of the Accept and Decline buttons?
Please supply in Text.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional