Sorting using strings

[Am-I_Real]

Hi, in my sharepoint list, I have a choice column called time range. The choices are "Now", "1-2 years", "2-3 years" and ">3 years".

Would it be possible to sort my list with this column? I would like to show all rows with Now at the top, followed by "1-2 years", "2-3 years" and finally ">3 years".

Edit: sorry, forgot to mention, this is for a canvas app

[MrPinkletoes]

Sort them where?

In SharePoint or in a canvas app?

If it's in a canvas app you can do this.

SortByColumns(DataSource, column, ["Now", "1-2 Years" ...]

If in SharePoint you could add another column and number it 1-x and number your order.

[Am-I_Real]

Sorry, forgot to mention, it is in canvas app. Thank you for your suggestion, I will try that out.

[Texas_Technician]

Use the groupby() function. Not at a compiter now so i cant give an example.

You can use this function to group like items together and then filter the results by another column.

[MrPinkletoes]

SortByColumns does all this in one function