Hello, I'm relatively new to InfoPath development but at a reasonable level. What I have is an InfoPath form that allows users to submit up to 4 items from the same SP lookup list. The fields are name1, name2, name3 and name4. Each field also has a category which states what part of the business they are in but that's not currently used. When I create a list item using workflow I also email each name field (when not blank) an alert... simpe but limited to only 4. I know I could manually add more but I want the user to not be limited to any fixed number of names.
What I want to do is have a combox display the business areas (done and working) which then will populate a multi-selection tickbox with all the names in that area allowing the user to multi-select (done and working) - so far so good. BUT when I publish the form and get to the dialog box asking which fields I want to make available I can select the group of names (which I call SelectedNames) and it offers me 4 'functions' (first, last, count or merge). Now I want all names selected so I picked merge. The workflow in the library detects a new form and creates a list item in a separate SP list but when I do this for the SelectedNames I get a concatenated (merged) list like "Andrew Ball Chris Deacon Eric Fowler" space separated between names but also between first and last names.
So my question is how do I write the SelectedNames to a sharepoint list in such a way that I can iterate through them and send an email to each selected name?