You’re offline. This is a read only version of the page.
Announcements
1,265
I have two SP Lists. One is VehList (Vehicle List) and the other VehInsp (Vehicle Inspection). VehList contains a text column/field (VehNo) that identifies the Vehicle No. VehInsp contains a lookup column/field (VehNo) where the user identifies the inspected vehicle. In VehInsp, the control for VehNo is...Choices([@VehInsp].VehNoLU). The following shows the Combo Box drop dropdown results.
My question is, how do I sort the Combo Box values?
They are being sorted, but as text, not numbers. You need to somehow wrap the values displayed in the "Value" expression to cast them as numbers. As a test, I created a single-column table (called "colNumbers") of the same values from your screenshot. This formula in the Items property of a combobox puts them in numeric order:
Sort(colNumbers,Value(Value))
Share
Report
All responses (
Answers (
