Re: Filter on Dropdown list box

WiReLaD — Tue, 04 Sep 2018 14:44:12 GMT

Fix it! -

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

I need a lie down...

Thanks

Filter on Dropdown list box

WiReLaD — Tue, 04 Sep 2018 12:22:41 GMT

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

InfoPath 2010

Re: Filter on Dropdown list box

Filter on Dropdown list box