InfoPath Dev

Hi all, i have a field with Ids connected with semicolons like 3;54;2;6;4. I want that the values in a Dropdown shows only the ListItems with this Ids So I need some filter definition with expression that compares the values from my field with d:ID and fill the dropdown When I use substring-before(xdXDocument:get-DOM()/my:myFields/my:DebugInfoTexte/my:KostenstellenIdsToShow, ";") = d:ID it takes the first one i need to but every value from the field. I hope it is clear what I mean. Thank you very much for any help Martin

 Hi Martin,

What I would do is load all of your list items into the data connection behind the dropdown (I assume your values are from an external data source) and then use the Filter Data option to put a filter the data source entries as follows - my:KostenstellenIdsToShow contains d:ID.  This should cause the dropdown to display only the values for which the ListItem ID is contained in your KostenstellenIdsToShow field.

 Let me know if that works for you or if you need more detailed steps.

EDIT: just realized this won't work! because if 54 is in your field with Ids, but 4 isn't, it will still think that 4 is in there!  Well here's a possible hack: is there any way that you can surround the entire string of Ids with semi colons?  For example instead of:

3;54;2;6;4

could you make it:

;3;54;2;6;4;

That way every Id number is preceded by a semi colon and followed by a semi colon, and then your filter can be:

my:KostenstellenIdsToShow contains concat(";", d:ID, ";")

Which would prevent confusion between 4 and 54, for example.

Hi Jennifer, thank you for your reply. I should try it and post my feedback immediately. Thank you and Regards Martin