Sort entries by status - how?

(0) Share

Report

Posted on by PowerSäm

775

Hi all,

I have a short question regarding the filter function.

I have built an app where on the home page all requests can be filtered by status. If I click on "All", all applications appear and that is correct. But now I want that when I click on the button "By status" (marked red in the pic) also all appeared but sorted. That means, first all with the status "Beantragt", then "Genehmigt", then "Abgelehnt" and then "Storniert". What is the best way to filter or rather sort them in this order?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Do this for all buttons:
Beantragt's Button OnClick
Set(varFilter,"Beantragt")

On your gallery item property:
SortByColumn(Filter(ListName,Status.Value=varFilter),"Status",Ascending)

Was this reply helpful? Yes No
PowerSäm 775 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your quick reply, @zmansuri.

Unfortunately it does not work. But in itself I have already set everything.

In the "Nach Status" button for filtering it says:
Set(varFilter; "Nach Status").

And in the Gallery I have written this:
If(varFilter = "By Status"; true; Status.Value=varFilter).

This all works as well. But now all entries are displayed and not sorted by status. How can I define that they have to be sorted by "Beantragt", "Genehmigt", "Abgelehnt", "Storniert"?

Thanks in advance

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

On the gallery use this filter:

If(varFilter = "By Status"; true; Sort(Gallery; NachStatus; Ascending))

This will organize all your itens by alphabetical order

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

"Beantragt", then "Genehmigt", then "Abgelehnt" and then "Storniert"
if this are all status values then it will sort this column like this:

Abgelehnt
Beantragt
Genehmigt
Storniert

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

SortByColumn(Filter(AddColumn(ListName,"StatusTxt",Status.Value),Status.Value=varFilter),"StatusTxt",Ascending)

Was this reply helpful? Yes No