locked
InfoPath data connection and dropdown list population RRS feed

  • Question

  • Hi,

    What am I trying to achieve?

    Based on the field, department (D1) - I am trying to populate all employees in a drop down list (E1) [D1 is retrieved dynamically]

    Based on the field, department (D2) - I am trying to populate all employees in a drop down list (E2) [D1 is retrieved dynamically]

    Result

    Drop down list E1 is populating, but drop down list E2 is not populating.

    Observation

    Irrespective, E1 is always populating.

    If department D2 is hard-coded, it retrieves values and populated E2, but if I dynamically retrieve department D2, E2 is blank.

    Any help would be greatly appreciated. Thank you in advance.


    Best Regards,
    Gagandeep Singh
    http://mscrmnovice.blogspot.com

    Thursday, January 3, 2013 11:00 AM

Answers

  • I have had problems filtering on dropdown menus in InfoPath 2007. To fix, I sometimes create a hidden text field to store the dropdown value, and then filter on text field rather than the dropdown. For example, if the user selects "HR" from D2, I would store "HR" in a hidden text field and then retrieve the E2 values by filtering on the hidden text field (rather than on D2). Hope this helps. Sorry, if I have misunderstood the problem. :)

    Friday, January 4, 2013 2:37 PM