Power Platform Community Forum Thread Details

Is it possible to sort a gallery that contains both numbers and text so that all numbers are listed at the top, descending, and all text is listed after them, ascending, like this:

2023

2022

2021

ABC

DEF

HIJ

(The PA-Gallery only has one column and is connected to a SharePoint list, also with only one column)

Thanks

Categories:

Building Power Apps

Hi @AbcdEfg123

You can sort a gallery containing both numbers and text in the order you describe by using a formula that differentiates between numeric and text values. You can achieve this by using the SortByColumns, IsNumeric, and Value functions.

SortByColumns(
AddColumns(
YourSharePointList,
NumericValue, If(IsNumeric(YourColumn), Value(YourColumn), Blank()),
IsNumber, IsNumeric(YourColumn)
),
"NumericValue", SortOrder.Descending,
"IsNumber", SortOrder.Descending,
"YourColumn", SortOrder.Ascending
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.