Unanswered

Sort Function

(0) Share

Report

Posted on by andydwall

Hi,

I have a power app for a SharePoint task tracker. The sort function (Up down arrow) on the app sorts by alphabetically. I want it to sort if the progress is "in progress" or "complete"

What code do I need to change? I need the progress value to be the sorting item.

SortByColumns(Filter([@'Work progress tracker'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @andydwall ,

You can add an extra condition to the filter function:

SortByColumns( Filter( [@'Work progress tracker'], StartsWith( Title, TextSearchBox1.Text ) ), Progress.Value = "in progress" || Progress.Value = "complete" "Title", If( SortDescending1, Descending, Ascending ) )

Was this reply helpful? Yes No
andydwall 9 on at

Like (0)

Report

Still getting errors. Everything disappears when this code is put in.

Was this reply helpful? Yes No
andydwall 9 on at

Like (0)

Report

I need the sort function in the app to sort by in progress or completed.

Was this reply helpful? Yes No
andydwall 9 on at

Like (0)

Report

Please see other replys.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @andydwall ,

I assumed the status column was a choice type, but if it's not, indeed that will cause issues. What is the error you are getting?

Was this reply helpful? Yes No
andydwall 9 on at

Like (0)

Report

Hi,

See the photos below. Pulling from the list and app is to track tasks. I just need the sort function to sort based on Progress value which is "body" and not alphabetical order of the title. I added a few more items to the code cause progress has possibility of being other options.

SortByColumns(
    Filter(
        [@'Work progress tracker'],
        StartsWith(
            Title,
            TextSearchBox1.Text
        )
    ),
    Body = "In Progress" || Body = "Completed" || Body = "Blocked" || Body = "Not Started" || Body = "Behind"
    "Title",
    If(
        SortDescending1,
        Descending,
        Ascending
    )
)

this is code under the sort function tab.

If(SortDescending1, "Sort list in reverse alphabetical order", "Sort list in alphabetical order")

Was this reply helpful? Yes No