Mapping Infopath fields to Sharepoint columns
Solution 1
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.
Solution 2
When you are promoting fields within a repeated section into SharePoint columns, the options available are to promote the column as:
- first (i.e. only the first selection is promoted)
- last
- count
- merge (I believe this merges all the selected values together into a single entry)
screenshot http://img4.imageshack.us/img4/5539/repeatinggrouptr3.png
Estus Flask
Updated on July 01, 2022Comments
-
Estus Flask almost 2 years
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.
-
Estus Flask over 15 yearsThanks VonC. So do you have any idea if this is doable?
-
VonC over 15 yearsI checked and so far, I do not find an easy way to do it. That does not mean it is impossible though, just that I am not familiar enough with SharePoint.