In LookupTables, enable Sort By a field other than Value or Display
I am regularly running into this limitation. I have an item # (value) and an item name (display) in my Lookup Table. I also have an item category, which is what I'd like to use for the Sort By - but the options currently limit Sort By to either value or display.
This can't be too hard for them... But 8 years later, I guess I could be wrong.
I'm with you. Display/Value/None for sorting is way too limited. I run into this problem with almost every datapage I create.