Filter on Dropdown list box - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Filter on Dropdown list box

Last post 09-04-2018 07:44 AM by WiReLaD. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-04-2018 05:22 AM

    Filter on Dropdown list box

    Hi,

    Sorry if this has already been covered but I'm really struggling to get this to work.

    I thought I'd mastered these simple InfoPath filters and yet this one has me stump'd

     

    I have a repeating table in which I have defaulted 3 rows. In each row in the first column I have a textbox called [GasilMill] where I've written [Plant Assets]

    row 1 "No.1 Microniser",

    row 2 its "No.2 Microniser" 

    row 3  "No.3 Microniser".

    These are the values I want to filter on.

    Then I have a dropdown list box in which I have a secondary data connection to a product list in SharePoint. The idea is, when the form opens each row dropdown listbox is populated based on the asset stream, No.1 Microniser, No.2 Microniser or No.3 Microniser

    In my view this should work: contains(current()/my:GasilMill, ../d:Plant_x0020_Asset/Value) 

    The SharePoint Product List can consist of products which can be made on all 3 asset streams which Is why I'm using the contains statement.

    It works fine but only for 1 product, 1 asset - products made on 1 & 3 Microniser are not showing in the dropdown list.

    Any help be most appreciated.

    Thanks

    Mike 

     

      

     

  • 09-04-2018 07:44 AM In reply to

    Re: Filter on Dropdown list box

     Fix it! -

    By not using the contains and making it equal to - seems to somehow fixed it.

    I need a lie down...

    Thanks 

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.