SharePoint Online: Create an InfoPath Form with both Non-repeating and Repeating Sections to submit multiple items

In this article, I will show you How to create an InfoPath Form with both Non-repeating and Repeating Sections to submit multiple items.

*Requirements: SharePoint Site, Microsoft InfoPath 2010

In order to have repeating sections – which means you will able to create/edit multiple items in just only one form – you will need to have a list created in InfoPath and has the option Manage multiple list items with this form checked. If you are customizing a list that has been created in SharePoint, then you will need to start over to create a new list in InfoPath. There is no way to change this property once the list has been created.

Let’s start.

Step 1 – Create a new SharePoint List in InfoPath. Open InfoPath → Create a new SharePoint List → Enter your site and list information → Remember to tick on the Manage multiple list items with this form  Finish.

This slideshow requires JavaScript.

 

Step 2 – Create Repeating Section. By default, all the fields are repetitive. All you need is to drag the field from the right panel into your form.

6
Repeating Section

 

These fields are wrapped in a repeating section, which indicates that we can have this section many times. To allow inserting this section in order to submit multiple items, Right click on the section → Repeating Section Properties → Check on “Allow users to insert and delete the sections” and “Show insert button and hint text” → OK.

7

Step 3 – Create Non-repeating Section. For some reasons, you may want some fields just need to be entered once and all other items inherit the same value. For example, the Title for all items are the same, the difference between items are the Item ID. Then, you will want the Title field to not repeat when insert a new section. Otherwise user will have to enter the Title again and again for each item they insert.

In order to create a Non-repeating Section, follow the same step as you create a Repeating Section, but don’t check the two options that allow user to insert new sections.

Select the Repeating Section that contains the Title field → Manage Rules

8.PNG

Add a new Formatting Rule → Set the condition as follow

count(preceding-sibling::my:SharePointListItem_RW) > 0

(explanation: if you press on Show advanced view at the bottom of the Fields panel, you will see the Repeating Section name – my:SharePointListItem_RW. So we count if this section has repeated, then hide it)

9.png
Add a new Formatting Rule
10.PNG
Set the condition

Press OK → Tick on Hide this control in the Rules panels.

That’s all. Now you can have both Repeating and Non-Repeating Sections in one form to submit multiple items.

I hope that this tutorial has helped you to achieve your goals.

Anh Vo

10 Comments Add yours

  1. MUHAMED RAFEEQ says:

    Hi. Thank you so much for this info. I have been breaking my head for this for the past 1 week. I have made a material request form published in sharepoint list. I made the form in infopath and it looks great. One small problem I am encountering. When the users submit the form with multiple line items (using repeating table), sharepoint shows each line item as a separate form. For eg: If they have listed 5 line items in the form, I am seeing 5 different entry in sharepoint. Entry 1 showing line item 1, entry 2 – item 2 and so on. How can I have 1 entry with all the line items in the same form.

    Like

    1. Anh Vo says:

      Hi,

      I have faced the same issue. My solution is that you should group the list items by their common field for example the id, or the name. Then when being displayed on SharePoint, it will only show the group title which is the common field (id/name). When clicking on one items, all other items should appear in the same form.

      Like

      1. AMber1984 says:

        hey! did you find a solution for creating 1 entry with all the line items in the same form? i didn’t really understand ANH VO answer 😦

        Like

  2. Jasmin says:

    Hi, this helps me with my problem right now. Thank you. There’s just one more thing I need to do – to see the non-repeating items into rows in a sharepoint list. I’d like to see the data items in my sharepoint list columns. I am a newbie user so I’m sorry if it’s a stupid question.

    Like

  3. Konstantinos says:

    Thanks for this helpful post!
    Unfortunately, the fields in the Non-repeating Section, are inserted/submitted only in the first list item. All the other items (the ones from the repeating Section, except for the first one) get the default values and no the ones of the Non-repeating Section… For some reasons, they does not inherit the same value.

    Like

    1. Page says:

      I am having same issue. Did you find a solution?

      Like

      1. Konstantinos says:

        Unfortunately no… 🙄

        Like

  4. Travis Pluff says:

    Solution for the Repeating fields only being submitted for the first item here: https://www.infopathdev.com/forums/t/39570.aspx

    Like

  5. Sakshi says:

    Hi, I need to have multiple repeat and non repeat sections. When I insert item for first repeat section, another repeat section automatically repeats. I do not want that. Please help!

    Like

  6. Hyelin Lee says:

    Thanks for this post! It’s really helpful. It’s working when I have one column for non-repeating tables!
    But, I have several columns for non-repeating tables. If I use this condition [count(preceding-sibling::my:SharePointListItem_RW) > 0] for all columns, the InfoPath form can’t be submitted anymore. Any solution to accommodate my needs? Thank you!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s