I have a list where I track my inventory. So it's just a list of items. The specific column that I care about is formatted as a Number field to allow for proper sorting.
On another list, I want one of my site columns to be a lookup to that specific number column from the inventory list. Everything works perfect in my computer browser, but when I tried to select from the lookup column via SharePlus, the dropdown list is blank. Meaning, I don't see any of the items from my inventory list.
The site column in the Inventory list that I want to populate as my dropdown is set to "Number". When I test the lookup in SharePlus, the dropdown is blank. I changed the same site column in the Inventory list from Number to "Single line of text". Then, in SharePlus, I get the same result - dropdown list is blank. Then, I changed the same site column in the Inventory list to "Calculation" with the returned result as a "Number". Same result, does not work in SharePlus. Finally, I changed the same site column in the Inventory list to "Calculation" with the returned result as a "Single line of text". It finally works - I can now see my inventory items as part of my dropdown.
Although I'm excited that the dropdown is now populated, the data in the dropdown list is sorting as text as opposed to sorting by number. I need to see the dropdown list sorted by Number.
Is this an error in functionality or behaving as intended?
Hello and thank you for posting!
I believe that you should try setting the field as a number a gain, then go to both lists in SharePlus and tap & hold the list, then Edit Settings, and finally Reset All. This will force the app to read both lists again, to prevent using cached data.
I hope this helps.
Looking forward to hearing from you,
When you created a calculated column in your inventory list, it was still returning numerical values. SharePoint treats calculated columns shell shockers differently from regular columns when used in lookup columns. This could be why it didn't work as expected.