Solved

List Lookup Needs to Filter in Look Up List order in Dropdown vs Alpha Order

  • 24 August 2021
  • 6 replies
  • 16 views

Badge +4

Hello!

I have a classic on prem form for SharePoint 2013 where I have a look up used for a cascading lookup below it which is working fine.  The issue I am having is my look up list is showing up in alpha order and I need it to show up "Calendar Month" view or as it shows up in my look up list.

My look up list is this:

19440i4A86DA30B94DE247.png

Then in the form the look up is this:

19441i145BE7B4BCDB3C95.png

But the Dropdown is like this:

19442i14A3741C1FA77B0E.png

How can I get this to view in "Calendar Order" or as it shows in look up list.

Thanks!

icon

Best answer by Aleximo 26 August 2021, 21:20

View original

6 replies

Badge +8

Hey,


 


u have to enter ur listview name here:


 



 

Badge +4

So I have tried putting the Qtrly Request Month Column, the Actual look up column and nothing works.  Still displays same.

Badge +8

The source view should be: Calendar Month or Calender Order (dont know how ur view is named)


 


U have to enter the name of the view 🙂

Badge +4

Sorry I am not understanding.  My look up list is shown above and the column I need and that order is Month of Request.  I have the Lookup control on page but that is attached to a Single Line text field called Qtrly Request Month.  Does that help?

Badge +8

U wrote: "I need it to show up "Calendar Month" view"


 


So thats ur "source view": Calender Month 🙂


 



 


 

Badge +4

Ahhhh Ok, you got me on the right path but it is tricky because you have to un-connect field first to get to the list info.



then you re-connect field and it hides all this so that is what was messing me up.


Reply