Answered

Adding Alphabetical order to a filter

(0) Share

Report

Posted on by TobiasSQA

Hey!

I have a Gallery that's sorted based on if a text field is populated, I need to somehow make it always sort in alphabetical order in addition to the already existing filter.

^ This is the Items property of the gallery.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Use the sortbycolumns and descending.

If(!IsBlank(txtsearch.Text), SortByColumns( Filter( PotentielleKunder2, txtsearch.Text in Title & Postnummber), "Title",Descending) , If( !IsBlank(KategoriFilter.Selected.Value), SortByColumns( Filter( PotentielleKunder2, KategoriFilter.Selected.Value = Kategori.Value ),"Title",Descending), SortByColumns(PotentielleKunder2,"Title",Descending) ) )

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Verified answer

Gochix 1,937 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @TobiasSQA ,

Probably something like this:

If(!IsBlank(txtsearch.Text), SortByColumns( Filter( PotentielleKunder2, txtsearch.Text in Title & Postnummber), "Title",Descending) , If( !IsBlank(KategoriFilter.Selected.Value), SortByColumns( Filter( PotentielleKunder2, KategoriFilter.Selected.Value = Kategori.Value ),"Title",Descending), SortByColumns(PotentielleKunder2,"Title",Descending) ) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No