Hi there.
So I have a gallery set up in Power Apps that sorts on Ticket ID to always have the newest ticket at the top of the app.
Problem I am facing is, that I now have 10 + tickets and the sorting on ID now goes like this from bottom to top: 1,10,11,2,3,4,5,6,7,8,9 instead of 1,2,3,4,5,6,7,8,9,10,11
The gallery gets its ID info from a excel sheet where ID isn't configured as numbers, but just "standard".
This is the gallery code:
Sort(
Search(TicketsCollect; TextInput2.Text; "Accountname";"Description";"Subject"; "Priority"; "Owner");
ID;Descending)
This is the code used to save to the excel sheet
Collect(TicketsCollect;{ID:Text(Max(TicketsCollect;ID)+1);Owner:Dropdown1.SelectedText.Opretter;Accountname:ComboBox1.Selected.Name;Priority:Dropdown2.SelectedText.'Work Area';Subject:TextInput1.Text;Description:TextInput4.Text;DateCreated:Text(Today())});;
So the question probably boils down to:
How do i get my Gallery to function so highest ID is shown first and then in descending order from there.
Thank you in advance
