web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter option: Sort in...
Power Apps
Answered

Filter option: Sort in a specific way - SortByColums

(0) ShareShare
ReportReport
Posted on by 775

Hello all,

 

I want to filter a list/table by status. Until now I have built the filters for "Alle", "Beantragt", "Genhemigt", "Abgelehnt" und "Storniert"

 

"Alle"= All applications are displayed

"Beantragt"= All requests with the status requested will be displayed.
"Genehmigt" = All requests with the status approved are shown
"Abgelehnt" = All requests with the status rejected are shown
"Storniert"= All applications with the status canceled are displayed
"Nach Kategorie" = All requests are filtered by category

 

Now I would like to program the last button "Nach Status" as well (See Image below). This should filter all requests by status and show the applications in the following order: First all requested, then all approved, then all rejected and then all cancelled.

 

PowerSm_0-1643624632533.png

 

Until now I had programmed it like this for the Button "Alle" (see image)

 

Items of the Gallery:

PowerSm_1-1643624633020.png

 

 

Now I want the same to happen for the "Nach Status" button, only that it sorts the entries at the same time, i.e. first all entries with the status requested are displayed, then all entries with the status approved, then all entries with the status rejected and finally all entries with the status cancelled.

 

How can I do that? Is this a good approach? (See image below)

PowerSm_0-1643625026821.png

 

I hope I could explain my question in an understandable way...

 

Many thanks in advance!

PowerSäm

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @PowerSäm ,

     

    I'm afraid there is no way to achieve your need, Sort and SortByColumns function could not be used neither for complex columns (LookUp/Choices/People) nor on hardcoded custom sequence.

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • Verified answer
    PowerSäm Profile Picture
    775 on at

    Thank you @v-jefferni  for your answer.

     

    I thought so too, but then I found an answer or solution to my problem in a similar thread.

     

    In the following thread this was explained particularly well:

    Click here for the solution 

     

    Nevertheless, I thank you for your effort and help.

    Many thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 136 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 109 Super User 2026 Season 2

Last 30 days Overall leaderboard