Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Data connection to Infopath from a calculated column in Sharepoint

  Asked By: Michael    Date: Aug 17    Category: Sharepoint    Views: 2069

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?



No Answers Found. Be the First, To Post Answer.