submit multiple entries to one list with one infopath form

Question

Is there a way to create a single infopath form to submit multiple rows of data to one list (as opposed to making one single entry/filling out one form at a time)?

Answer 1

If you choose to use Infopath Sharepoint List Form type/compatibility, then you should create it from Infopath Designer 2010 by choosing Sharepoint List template (on ribbon File > New ) and at the end of publishing wizard choose:

• Manage multiple list items with this form
  This will create repeating fields and add a repeating section to enable usersto edit multiple list items in a single form

Then it will be possible to drag'n'drop data fields on design surface as repeating controls from under or right-click on my:SharepointListItem_RW in Fields pane and select Repeating Table or Repeating Section with Controls

It is not available if you create the same by clicking Customize Form button on ribbon (under Customize List < List tab < List Tools) in browser as well as it is impossible to change such form after it was created with this option unchecked.

The Infopath forms created from a template published to a sharepoint library form can submit multiple rows into a sharepoint list as well as there are other (non-straightforward thanks to MS) methods of submitting multiple items to a list or to multiple lists