My Sort function is taking the Value digits as text and sorting them as text and not as real Values.
and not as
Any ideas on what I can try to fix this?
You could use AddColumns to convert your text to numbers and sort by that. In the example below, a table of numbers as text are converted to numbers with Value for sorting (confusing but the name of the column of the initial table is also called Value).
SortByColumns(AddColumns(["100", "1", "22", "33"], "numbers", Value(Value)), "numbers", Descending)
Thanks for the replies, I think I know what the issue is
Im using a switch in the Sort which takes the UpdateContext of the Sort Icon OnChange of varSortG1 and denote the value, which then assign the sorting column. All sorting columns are Text, except for the 'Contract Amount' one with the issue. But if I swap the 'Contract Amount' at 1st, the sorting works on the Digits without issues.
&& Agreement_x0020_Type = Dropdown_AgreementType_PSA.SelectedText.Value
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.