InfoPath Dev

 I am new to InfoPath and SharePoint 2013 but I am picking things up quickly and really enjoy the flexibility of the platform. I am however stuck trying to get a Shrinking list filter to work on my dropdown list in a repeating table. I am trying to follow this example here but just can't get it to work. My data source for the dropdown list is a SharePoint List. I only pull in ID and Title from the SharePoint list. The value and display for the drop down is Title for both. Is there something different with 2013 version of InfoPath?

 Hello noodleNT,

Check to make sure that the filter is on the dropdown list box in the repeating section in your main data source. You want to use the expression outlined in the example to limit the selections, it should not be different in InfoPath 2013. If that does not work, attach your form and well take a look at it.

Thanks

Bre 

 So the filter should be on the combo list in Main and not on the actual data source?

 

Screen cap of the drop down filter config.

http://1drv.ms/1l4nUlY 

 Attached is my attempt at the example posted here.

I found that THIS post works.  The main difference is the use of preceding-sibling and following-sibling instead of xdXDocument:get-DOM() in the filter. Only draw back is you have to make two filter rules instead of one.

I have tried this method and I don't get errors but it still doesn't work. I have tried putting in the following expressions: not(my:type = current()/preceding-sibling::my:GeneralInventory/my:deviceType) AND not(my:type = current()/following-sibling::my:GeneralInventory/my:deviceType) The data is pulling from an xml file which was added to the form as a resource file. I have attached a copy of my form. I need the value of the drop down to be "type" and display as "display". The comments will populate using rules once I get the drop down to shrink. Any help is appreciated.

Hello Dawndev,

This was a rather tricky filter. Because the filter applies to the main DS we must use the full xpath to the node in the main DS. Here is the filter that was on your last form:

not(. = current()/my:deviceType)

and the new:

not(. = xdXDocument:get-DOM()/my:myFields/my:InventoryInformation/my:GeneralInventory/my:deviceType)

Please find our form attached with the change.

Thanks!
Bre

 

Bre Huston:

Hello Dawndev,

This was a rather tricky filter. Because the filter applies to the main DS we must use the full xpath to the node in the main DS. Here is the filter that was on your last form:

not(. = current()/my:deviceType)

and the new:

not(. = xdXDocument:get-DOM()/my:myFields/my:InventoryInformation/my:GeneralInventory/my:deviceType)

Please find our form attached with the change.

Thanks!
Bre

 

Thanks! That worked beautifully.