Sorting in list box not working

[#1]

Hi Gurus,

I have list box with name of users, I want to sort by first name. Looks so trivial but nothing seems to be working.

Attached is the screenshot.

Thanks

DV

[sunny_talwar]

Try removing the check from State and text and see if that helps.

[#3]

Tried. Does not work

[#4]

I create sample list box with full_name and do sorting and it works. Wondering if it is because of the expression I have it does not work

=if(len(dual(full_name,aggr(only({<user_id =,full_name=>}user_id),full_name)))>=20,
mid(dual(full_name,aggr(only({<user_id =,full_name=>}user_id),full_name)),1,20),
dual(full_name,aggr(only({<user_id =,full_name=>}user_id),full_name)))

[sunny_talwar]

Would you be able to share a sample?