ComboBox Sort+Filter breaks search function

(0) Share

Report

Posted on by gjeh

432

Hello All,

I'm running into a tiny issue with a combobox with searchfield.

The combobox is filled as such:

If(!IsBlank(ComboBoxNaam.SearchText);(DataSource)

However my results are not sorted in any particular way and I wish to sort them based on A-Z.

I tried this:

If(!IsBlank(ComboBoxNaam.SearchText);SortByColumns(DataSource;"Naam";Ascending)

However once I change the code to include the sortbycolumns the [allow search] attribute is automatically turned off. I can switch it back on but the searchfield won't work regardless of the [allow search] attribute's value.

Having the same problem in a different ComboBox where the working (non sorted) code looks like this:

If(!IsBlank(ComboBoxOrg.SearchText);Filter(Distinct(DataSource;Titel);Result <> "a"))

Perhaps I am doing something wrong with the expressions but perhaps not, im not entirely certain.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gjeh

What is the Items property of the combobox?
gjeh 432 on at

Like
a
(0)

Report
Copy link

Link copied!

the datasource is a sharepoint list, the items are list items.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@gjeh

Sort the list at the datasource level for the combobox.

Sort(SPlist,Naam,Ascending)
gjeh 432 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your reply.

But if i edit this code:

If( !IsBlank(ComboBoxOntvangerINK.SearchText);'Office365-gebruikers'.SearchUser({searchTerm:ComboBoxOntvangerINK.SearchText}) )

to

If( !IsBlank(ComboBoxOntvangerINK.SearchText);Sort('Office365-gebruikers'.SearchUser({searchTerm:ComboBoxOntvangerINK.SearchText});Ascending) )

my result is this: (After turning setting 'allow search' back to true because for some reason this keeps turning off everytime i edit the formula)
as you can see it is not sorted alphabetically, unless it is sorted on a different column than name.
bcampbell13 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Look for the setting and turn it off and see if it fixed the problem? I've found that with that setting off, the it creates a problem with sorting or filtering. I don't fully know why, it has something to do with how it limited the fields it understands exists (for performance reasons) under the hood.

in my experience, that setting is broken, as much as I'd love to turn it on for performance, I can't.