I have set this problem aside for now, but I then thought I would
throw it out here and see if anyone else had a solution.
In SharePoint I have a list with 5 columns of data, and a 6th column
that concats all those columns together using a calculated column.
In InfoPath I created an XML secondary connection to this list using the
List GUID to access the calculated column. Then I associated that Data
connection with a dropdown list.
This whole thing works pretty good except for the fact that it appends
"string;#" to the beginning of every list item in the form dropdown, and
I am not sure where it is coming from or how best to get rid of it. I
have looked in the XML resource file to see if the code is throwing it
in there then, but it looks clean.
In the end I ended up just copy/pasting the concatenated column into a
different list, and then having the admin associated with the form
update that single line of text field manually as needed. That isn't
Ideal, I would rather keep the list dynamic.
Has anyone else seen behavior like this?
Do you know someone who can help? Share a link to this thread on twitter, or facebook.