Mapping Infopath fields to Sharepoint columns

Sam picture Sam · Dec 11, 2008 · Viewed 17.1k times · Source

Any one has any idea how to map an infopath field to a sharepoint column of type choice? The infopath field is a repeating field, so the user can select multiple options, I want to be able to map those to the choice field in sharepoint. Any ideas?

update: What I'm trying to do is the following. I have a choice column in sharepoint which allows user entered values. In infopath, I have a repeating field. I'm binding the field to a dropdownlist. The dropdownlist gets filled by a webservice. This dropdownlist is in a repeating section, so the user can choose to select from multiple dropdownlists. So lets say the user adds 2 dropdownlists, and selects an option from each dropdownlist. I want to be able to add those selections as choices in the sharepoint choice column.

Answer

Toni Frankola picture Toni Frankola · Dec 15, 2008

SharePoint list is a flat structure, and because of that Infopath does not allow you map repeating sections to list columns.

You might wanna consider the following workaround:

  • Store Infopath form to one library (along with non-repeating fields)
  • Use one of these custom activities to extract data from repeating table and copy it to another list
  • Create a custom data view or a web part to display these items (if necessary)

This approach can be useful if you need to do some additional tasks with the repeating data.