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)

raks on at

Like (0)

Report
Copy link

Link copied!

Finally, it works. Maybe I've to add the sortOrder columns in TabList.
Thanks for your help and investment to find a solution.

Was this reply helpful? Yes No
Verified answer

Anchov 1,986 on at

Like (1)

Report
Copy link

Link copied!

The '.' notation enables you to specify the column you wish to display as labels in your tab list. It comes after the closing parenthesis of your SortByColumns function and is not an argument of this function. This effectively "creates" a 1-column table instead of displaying multiple columns from the entire SharePoint list.

Custom Sort:

I've observed that without using this approach, I lose my custom sorting, and the behavior reverts to what you've described (PowerApps determines the columns and sort order).

The custom order is lost, and it defaults to sorting by 'id'.

This looks to be the cause of your issue: The Items property has to be in the format of a 1 column table.

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 don't understand your remark in red. SortByColumns doesn't take an argument with a '.'
And if I try, no error but nothing is shown.
In meanwhile, I'll ask my scrummaster if it's acceptable with a number in the label.

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

Like (0)

Report
Copy link

Link copied!

In my experience, I have seen this control be a little glitchy (it is still in preview after all). Try adding a brand new modern tab component to the screen, then and copy and paste the Items code you entered above to see if you see the same results .

Was this reply helpful? Yes No
raks on at

Like (0)

Report
Copy link

Link copied!

@Anchov
I've exactly done the same but still not work:

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
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
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
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