srudenko:Using InfoPath 2010 how do you import data from a specific column into a repeating table?
I already have a connection setup to the SharePoint list and I can pull in the data into a List Box. I would like to do the same but with a repeating table but I am not sure how. Only the first cell populates with the first entry from the SharePoint list column.
In the list box properties the entry is /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW and Value is d:Title
Sharepoint List Form data fields is directly associated with list fields, so
creating/changing a list schema in sharepoint is reflected in such form
(main data connection), upon its refreshing/reopening, and
changing/adding data fields in the main data connection of this form is
reflected in a list, after its publishing. So, the term "import" is
improper to use in this context.
In order to have repeating sections or tables you should have checked
- Manage multiple list items with this form
while creating Sharepoint List Form template (Main Data Connection).
If you have not done this at the moment of creating form/Main Data connection, IMO, it cannot be changed, so you should recreate list form (which implies recreating main data connection)
For existing list, having already published sharepoint list form, you should disassociate list from already published template, for example, in list advanced settings. In browser navigate to list > List tab > List Settings > Form Settings > check both Use the default Sharepoint form and Delete the Infopath Form from the server > OK
Don't use "Customize Form" button from sharepoint but from Infopath Designer 2010 Design Form < Sharepoint List < New < File, on ribbon to have ability to check
- Manage multiple list items with this form
at Infopath Sharepoint List Form and (Main) Data connection creation
