Submit InfoPath Each Repeating Table Data to SharePoint List as Individual Item

Submit InfoPath Each Repeating Table Data to SharePoint List as Individual Item

I received a requirement to create a time card entry and keep track of the number of hours consumed in their activities. Below is a sample of the form.

I had to design the form in such a way so that individuals can make multiple entries for a week and on different types, like, Project, Holiday, if it is Project then What is the name of the project and whether it is Design or Lab hours. So, I added all my controls on a repeating section. Initially I thought of merging the records in comma separated value but reporting is complicated. I decided to save them in a list as individual item to make life easy. Below are the steps which can help you achieve the same.

1. Create a List and add all your fields which are required on the form.

2. Open the InfoPath Form designer, Select SharePoint List form template and Select Design Form.

    

3. Provide the Site URL

4. Select the List and continue

5. Now before you click finish, notice there is a check box says, "Manage multiple list items with this form".

6. Select the checkbox and click on finish.

7. This would open the Form with all controls added inside a repeating section.

8. If the repeating section is not enabled to add sections at run time, click on the repeating section property and enable them.

For me the end result look like below.

Hope this helps ! Feel free to suggest any other alternative you know.

Cheers !