Attempting to build a cascading menu in SharePoint 2010, using info path. Basically I have 3 menus as shown below. All 3 menus are tied to a sharepoint list of info. Menu 1 is the first selection (Line of Business) – when I select that, menu 2 (major group) populates based on an infopath filter/data source I set using this link and it works fine! For sake of simplicity, Line of Business could be COUNTRY, Major Group could be STATE, and Job Role would be City. Each would populate on the prior level. https://blog.salamandersoft.co.uk/index.php/2011/11/implement-cascading-drop-down-for-forms-in-sharepoint-2010/

enter image description hereWhat I'm trying to do now is populate a third menu (job role), based on info in the 2nd menu. No matter which way I try and filter it, its blank. Can someone guide me in the right direction?


Make sure you have created four lists for the relationship structure, then you can filter the 3rd menu like the 2nd menu.

In addition, you can also achieve it using jQuery.

Reference for you.

  • Yep I have 4 lists for the relationship. Would rather do this with InfoPath versus jQuery
    – dmj12508
    May 4 '18 at 10:47

Figured it out.

2/3 of my lookup lists were using lookup columns, in the 3rd list, for some reason I typed everything in manual, versus using a lookup. Well the InfoPath formula filter didn't like that. Once I redid the list using column lookups versus manual entries, it worked!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.