How to sort tab list (Modern Controls)

(0) Share

Report

Posted on by raks

Hello,

I'm using the new component tab list and get my values from a SP List (no other way with a multilanguage App).

Tab list keep always the alphabetical order. I try to put a Sort in the query but that have no effect.

The only workaround I found is the put a number before each label but no solution to have my tab labels without the number.

Any ideas or should I suggest to Microsoft to activate sort on tab list?

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

I was able to sort the modern tab list using a Sort function, see example below:

Try showing what you have tried in your app by sharing a screen shot or copy and paste your code?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
raks on at

Like (0)

Report
Copy link

Link copied!

Here is my query with the order I wish:

And here is the result (alphabetical order is applied):

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I am a bit confused, it appears the sort on alphabetical order is working then (based on your second screen-shot)?

Was this reply helpful? Yes No
raks on at

Like (0)

Report
Copy link

Link copied!

I want the order based on my first screenshot, that could be based on the ID too.
If I remove the Sort, the tabList is always ordered in alphabetical order:

I don't understand why because, based on the ID, the first item created in the list was "Informations de contact".

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
Alright, to achieve this, you'll first need to create a column in your data source named 'SortOrder.' Assign numerical values to the fields in the order you desire (e.g., 1, 2, 3...). Afterward, utilize the Sort function to sort based on this 'SortOrder' column:

Sort(Filter('Contactbook-Lavels', Screen=TeamTabbladen", CBLanguage.Value=varLoan), SortOrder, SortOrder.Ascending)

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
raks on at

Like (0)

Report
Copy link

Link copied!

I've already test like this:
Still no effect:

Was this reply helpful? Yes No
raks on at

Like (0)

Report
Copy link

Link copied!

@Anchov
Something interesting:
I put the same query in a Combo Box Modern Controls and have the same result:

But with a classic ComboBox, I have the good result:

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

It likely sorting by ID (and the order you put it in the alphabetical order). Using the Sort Order column will allow you to sort on a different column and not have to prefix your labels with 1, 2, etc.)

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

Here is an example:

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!

Here is an example:

Was this reply helpful? Yes No