Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Data connection to Infopath from a calculated column in Sharepoint

  Asked By: Michael Smith         Date: Aug 17, 2008      Category: Sharepoint      Views: 324
 

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.

Tagged:                  

 

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

 


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].