SharePoint Integration

Re: Infopath form does not fill sharepoint site column as expected

DaveD — Fri, 02 Jul 2010 12:31:37 GMT

Chris, I'm having the same issue, although my setup is a bit simpler:

I've got a Form Library with a few custom columns added. One of these custom columns is a lookup to another list on the same site (linked on the Title field, not ID).

Then I created a simple InfoPath test form, and using it I can submit to the Form Library and every field except for my lookup works 100%. The lookup column in SP just ends up blank.

I've tried binding that lookup column to a dropdown list in InfoPath which is populated with all of the Title fields from the related list, and I've also tried just making it a Text Box and entering in a known value (in case the value being returned from the Drop-Down List control wasn't the displayed string). Either way, the value in the lookup column is just blank.

Re: Infopath form does not fill sharepoint site column as expected

rdubbelman — Tue, 01 Dec 2009 09:21:51 GMT

Have you promoted the field in infopath to a sharepoint column?

Tools->Form Option -> Property Promotion

Source: http://blog.ksenthil.net/archive/2009/07/25/promoting-properties-e28093-expose-infopath-fields-as-site-columns.aspx

Cheers Rody

Re: Infopath form does not fill sharepoint site column as expected

Patrick Halstead — Wed, 25 Nov 2009 14:31:32 GMT

Hi Chris,

I don't think separate content types can use the same column. Try defining a separate column for InfoPath and then usng a rule in the view to display contents of one column or another depending on the type.

Infopath form does not fill sharepoint site column as expected

chris04 — Tue, 24 Nov 2009 16:03:40 GMT

Hi guys,

finally I found an Infopath forum with an active user base! That's great!

Here is my first problem:

I have one Sharepoint List containing all projects of a company with some metainformation. Additionally I have a document library, where all project related documents should go. Since I want to put all documents of all projects in there I want to assign related projects to the documents. Normally I would simply add a column to the document library defining it as a lookup on the project name.

But in this case I have to different content types allowed in this document library. One word document (e.g. Statement of Work) and one Infopath form (Checklist). For both the metainformation "related project" shall be mandatory. That works fine for the Word document, the related project column is defined as site column and added to the word content type. When I create a new document I have to choose a related project.

For the Infopath document it does not work. I mapped one field of the infopath form to the same site column "related project". The field within Infopath is a lookup on the same project list like before. However, when I create a new Checklist and choose the related project within Infopath, this information is not written in the related project field within sharepoint. It's empty instead.

Within the Document Library settings, I can verify that both content types have mapped the "related project" column.

I think, I'm missing something here, since I guess it should be possible. One goal of all this is to connect the respective webparts using the related project column.

Cheers Chris