Binding Multi-selection Listbox in Infopath Form 2010

Question

I came across a sceneario where I need to bind Multi-selection Listbox control present in Infopath form 2010 with text field having comma seperated values .

Note : I am deploying my Infopath form 2010 to SharePoint List so I cant use any custom code.

Below is an example of what I am trying to achieve :

eg : TextField data : test1,test2,test3,test2 then the values of multiselection List box ( need to bind only unique values) will be : test1 test2 test3

Thanks for helping.

Answer 1

Edited

If you are looking for no code solution I don't believe it is possible.

Only workaround I can think of is to write some custom webservice that will get your data, parse it from comma separated values and then use it as external data source to populate choices in listbox. I used back on 2007 similar technique when working with no code browser forms.

Original answer - opposite solution

You can easily put selected Multiselection Listbox values to text field by using this formula:

eval(eval(field1[. != ""]; 'concat(., ", ")'); "..")

(where field1 is name of your listbox binded repeating field)

You can set some other field to this value by using rule when you submit your form or on button click. After that you can propagate this field to list - but it really depends on your infopath form logic.

I don't quite understand why you need to bind only unique values since if your listbox contains same values when you select one you will select all items with same value. However if that is the case formula above will get only one.

You can find some more info on InfoPathDev Forum here.