Reordering gallery item

[Filistyn]

Hey! I have this gallery

Which is taking data from this Sharepoint list

 What I want want is that everytime I click on the "accept" button in the Gallery, the Gallery item, that I have clicked on will automatically reorder to the bottom of the Gallery.

Could someone help, please?

[JR-BejeweledOne]

What is the items property in the gallery?    When someone clicks accept, what happens?  Does it set a value somewhere?

[StalinPonnusamy]

This is possible when we set some value in the data source when the user click on "Accept"

• Patch the record when the user clicks "Accept" button (It should flag something like 1 or 0)
• Sort the Gallery by this flag and another field (Propabbly title)
• Refresh gallery

So this 

[Filistyn]

Hi, this button just sets the value of the "Approval" column to "Accepted"

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

also I have set, that the button dissapears after you click on it

!(ThisItem.Approval="Accepted" || ThisItem.Approval = "Declined")

I will even add a label, that after you press some of the buttons, it will display, that the request was "Accepted" or "Declined"

[JR-BejeweledOne · Accepted solution]

Try sorting your gallery on the approvals column in descending order.   This will show your pending items at the top of the gallery and your accepted items at the bottom.  If you need additional sorting options, then you would need to use SortbyColumns.

https://manueltgomes.com/reference/powerapps-function-reference/sortbycolumns-function/

[StalinPonnusamy]

Hi @Filistyn 

Please let us know if any help on this and post the outcomes.

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

[Filistyn · Accepted solution]

Thank you for the answer, I came up with this line of code, which works perfectly

SortByColumns(Filter(VacationTracker, DepartmentCopy = lblDepartment.Text), "Approval", SortOrder.Descending)