How to sort a collection by 2 values to return highest date at top

[sienna28]

I have a collection and am trying to sort it.

How can I sort by the NameID and get the highest date alongside each name?

For example NameID 1 would be highest date 15/02/2022,  Name3 would be 26/11/2022

NameID  DateValue

1             01/02/2022

2             17/06/2022

3             26/11/2022

1             12/02/2022

1             15/02/2022

1             04/02/2022

3             11/05/2021

3             02/02/2022

Any help appreciated.

Thank you

[365-Assist]

Does this help?

SortByColumns(colItems,"Title",Ascending,"Date",Descending)

[Drrickryp]

@sienna28 

This formula for the gallery removes the duplicate Titles in the above screenshot and has only one Title and its most recent date.

//Produces a table sorted on Title field, containing a table of dates sorted descending
//For the items property of the gallery:
Sort(
     GroupBy(
              SortByColumns(
                             colitems,"Date",Descending
               ),"Title","Date"
      ), Title, Ascending
)

// Inside the gallery, add two labels:
ThisItem.Title 
First(ThisItem.Date).Date
 

[Drrickryp]

@sienna28 

This formula for the gallery removes the duplicate Titles in the above screenshot and has only one Title and its most recent date.

//Produces a table sorted on Title field, containing a table of dates sorted descending
//For the items property of the gallery:
Sort(
     GroupBy(
              SortByColumns(
                             colitems,"Date",Descending
               ),"Title","Date"
      ), Title, Ascending
)

// Inside the gallery, add two labels:
ThisItem.Title 
First(ThisItem.Date).Date
 

[sienna28]

Many thanks for your help.

One question....
When I do the following I would like to display more values from the collection it is working on.
This will currently output name and date, but I also have another date in the collection it is using.

//Produces a table sorted on Title field, containing a table of dates sorted descending
//For the items property of the gallery:
Sort(
     GroupBy(
              SortByColumns(
                             colitems,"Date",Descending
               ),"Title","Date"
      ), Title, Ascending
)

So I have...

ClearCollect(
col3,
Sort(
GroupBy(
SortByColumns(
Col2,
"cr583_startdate",
Descending
),
"cr583_nameid",
"cr583_startdate"
// "cr583_enddate"
),
cr583_nameid,
Ascending
))

There is a column called EndDate in col2 that I need to bring across

[sienna28]

Just to explain further - the first gallery has collection 1 which has the sorted recs.
The 2nd gallery has the sorted and grouped values - I would like to bring the EndDate into it also for the grouped item.

[Drrickryp]

@sienna28 

ClearCollect(
             col3, Sort(
                        GroupBy(
                                SortByColumns(
                                               Col2,   "cr583_startdate",  Descending
                                 ), "cr583_nameid", "cr583_startdate", "cr583_enddate"
                         ), cr583_nameid, Ascending
                    )
)

and in the gallery put three labels:

ThisItem.nameid
First(ThisItem.StartDate).StartDate
First(ThisItem.StartDate).EndDate

[sienna28]

Thanks very much

Nameid comes through in the gallery, but this does not appear

First(ThisItem.StartDate).StartDate

I can only use First(ThisItem.cr583_startdate).cr583_startdate and it says invalid use of "."

[sienna28]

Also in the code, when I add the extra 

cr583_enddate

I notice the grouping is lost and it shows all records

[Drrickryp]

@sienna28 

Try this

ClearCollect(
             col3, Sort(
                        GroupBy(
                                SortByColumns(
                                               Col2,   "cr583_startdate",  Descending
                                 ), "cr583_nameid", "restofdata"
                         ), cr583_nameid, Ascending
                    )
)

and in the labels

First(ThisItem.restofdata).cr583_startdate

First(ThisItem.restofdata).cr583_enddate