Skip to main content
Nintex Community Menu Bar
Solved

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

  • August 24, 2021
  • 6 replies
  • 41 views

Forum|alt.badge.img+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!

Best answer by Aleximo

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

 

So thats ur "source view": Calender Month 🙂

 

 

 

6 replies

Forum|alt.badge.img+8
  • 93 replies
  • August 25, 2021

Hey,

 

u have to enter ur listview name here:

 

 


Forum|alt.badge.img+4
  • Author
  • 26 replies
  • August 26, 2021

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


Forum|alt.badge.img+8
  • 93 replies
  • August 26, 2021

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 🙂


Forum|alt.badge.img+4
  • Author
  • 26 replies
  • August 26, 2021

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?


Forum|alt.badge.img+8
  • 93 replies
  • Answer
  • August 26, 2021

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

 

So thats ur "source view": Calender Month 🙂

 

 

 


Forum|alt.badge.img+4
  • Author
  • 26 replies
  • August 26, 2021

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.