Reverse order of items in Gallery

(0) Share

Report

Posted on by kevtun1982

136

Hi all,

I have been asked if there is a way to change the order of items shown in my Gallery. I have attached a picture. ID 1 is at the top meaning that any new item is at the bottom. Is there a way to reverse this so that the newest entries are at the top?

Kevin

Categories:

Building Power Apps

All responses (13)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

You need to sort the Gallery. What code do you have on the items property of the Gallery?

Try:

Sort(Datasource,ID,Descending)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
kevtun1982 136 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24
I think that would work but... Where do I put it amongst my current code??

If(
StatusDropdown.SelectedText.Value="All",
NewNCR,
If(
CategoryDropdown.SelectedText.Value="All",
Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value),
Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value && Category.Value = CategoryDropdown.SelectedText.Value)
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

@kevtun1982

Use this:

Sort(
If(
StatusDropdown.SelectedText.Value="All",
NewNCR,
If(
CategoryDropdown.SelectedText.Value="All",
Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value),
Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value && Category.Value = CategoryDropdown.SelectedText.Value),ID,Descending)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
kevtun1982 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24
That didnt work. I tried to put in exactly as you suggested. I am not sure what the problem is.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Where does the error points to as i cant see the full picture?

Also do you have ID as part of the columns in your datasource?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
kevtun1982 136 on at

Like
a
(0)

Report
Copy link

Link copied!

The ID is automatically generated every time there is a ticket raised. It is in the SP list though.

Below is another image of the errors

Kevin
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@kevtun1982

Please consider changing your Formula to the following:

Sort( Filter(NewNCR, (StatusDropdown.SelectedText.Value="All" || Status.Value = StatusDropdown.SelectedText.Value) && (CategoryDropdown.SelectedText.Value="All" || Category.Value = CategoryDropdown.SelectedText.Value) ), ID, Descending )

Also, you should consider getting rid of the .SelectedText property on your Dropdowns in the formula as the property has been deprecated and should not be used going forward.

Example, It should be : StatusDropdown.Selected.someColumn

The "someColumn" name will be determined by the Items property of your dropdowns.

I hope this is helpful for you.
kevtun1982 136 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @RandyHayes
I am not sure what you mean by that. This is my first app and I have never used any code before. I am learning by using videos and people in the community helping me along with bits of code or editing my code for me to use.
Sorry

Kevin
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@kevtun1982

Luckily PowerApps is a no-code platform, so you don't have to look at it as such 😉

What part don't you understand? And, did using the formula work for you?

Be careful with the videos out there...there is a LOT of bad practices shared in them. They confuse a lot of people.
kevtun1982 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes

I tried the Formula that you suggested but it just left everything on the screen blank. I have made my app live now and hope to make a few changes as I get the information.
Kevin