Unanswered

How Best to sort and filter within a Gallery.

(0) Share

Report

Posted on by Darren11

In PowerApps, I am creating a Gallery connected to a list for employees to add vacation/leave time, this list also includes holidays.

In the gallery, I am trying to filter by the current logged in user and sort by the date of the vacation/leave and built-in holiday.

This code will bring me the Filter part "(Filter('VacationList','Creator Email'=User().Email)" but I don't get any response from the holiday column.

SortByColumns(Filter('VacationList','Creator Email'=User().Email),"Holiday", Ascending)

Please let me know what I need to change in the code so I can get the list of holidays to show.

Any help would be great.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Darren11

To troubleshoot do two things

Put SortByColumns('VacationList', "Holiday", Ascending) as the items property of your gallery and see if the holiday column populates.

Put a label in the gallery with its text property: ThisItem.'Creator Email' to see if that field gets displayed or errors out.
Darren11 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Drrickryp,
Thank you for responding. I tried what you suggested and Yes, it is returning all the correct data for the, SortByColumns('VacationList', "Holiday", Ascending). I do already have a label with ThisItem.'Creator Email' and it is working as it should.

Allow me to explain a bit deeper into my attempt here.
Overall, as a user enters a vacation/leave request through a form, they pick from a dropdown and enter a start and end date. The result displays on the Work Schedule list. No issues there.
When any user views the Work Schedule, they should only see their entry and not everyone else's. Blended in with the list of entries are the standard holiday dates. These should appear for everyone.
I am able to get the list of Holidays to appear and I can get the Vacation/Leave list to appear, but it includes all users in every view. As a result, I am not able to get the vacation list of just one user's choices along with the Holiday list. Below is a sample image of what it might look like.
General idea of list results.

A bit of an explanation on the code I am using.

Blue is the filter that pulls the vacation/leave for each logged in user. Green is, what I thought would pull all the holidays and place them in ascending order.
I have tried numerous variations of this line, but I am not able to get both to display. I thought perhaps I should use an "And" or "&&" to get the holidays, but that didn't work either.
Sorry for the long entry, I'm just trying to be clear about the issue.

Thanks.
Darren11 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Being new to Power Apps, I knew this would be a challenge. I am still trying to resolve this issue after several days of trying to resolve this code. I feel I am very close, but it just isn't coming out properly.
I can get all the data to display, but I need it to filter by the logged-on user and be in ascending order.

Any suggestions, anyone?