Repeating Tables and Sections in InfoPath

Learn how to add rows, remove rows, fill, filter, and perform other actions on repeating tables and repeating sections in InfoPath.

Repeating Table Basics

InfoPath Basics: Repeating control basics in InfoPath

This article explains the basics of repeating tables and repeating sections in InfoPath.

Video Tutorial: What is InfoPath repeating table

Learn what an InfoPath repeating table is and how an InfoPath repeating table works.

2 Ways to place a Date Picker in a Repeating Table in InfoPath

Learn how you can add or convert a text box control that is located within a repeating table on an InfoPath form template into a date picker control.

Video Tutorial: Add people picker to repeating table in InfoPath 2010

Learn how you can add a person/group picker or people picker control to a repeating table control on an InfoPath 2010 form.

Can you put a repeating table in a repeating table?

Step-by-step instructions for adding a repeating table in a repeating table on an InfoPath form.

Check for duplicate values in repeating table rows in InfoPath 2010

Learn how you can use formulas that use sum(), count(), preceding-sibling, and following-sibling to determine whether a field in rows of a repeating table on an InfoPath 2010 form contains duplicate values.

Choice field with maximum selections in InfoPath 2010

Learn how to create a group of check boxes and allow users to select a maximum of choices on an InfoPath 2010 form.

Display the same repeating table in different places in InfoPath

Learn how you can display data from a repeating table in other repeating tables that are located on different places on an InfoPath form.

Video Tutorial: Highlight rows of a repeating table in InfoPath 2010

Learn how to use conditional formatting to highlight rows in a repeating table based on a text string that is typed into a text box.

Video Tutorial: Multi-select list box to show/hide columns in horizontal repeating table

Learn how to use a multiple-selection list box on an InfoPath 2013 form to show and hide columns in a horizontal repeating table.

How to check all check boxes in a repeating table in InfoPath 2010

Learn how you can use rules on a Select All check box to check all check boxes in a repeating table in InfoPath 2010.

Video Tutorial: InfoPath repeating table sum

Learn how to calculate the sum of two different repeating tables in InfoPath 2010.

Video Tutorial: InfoPath sum function to calculate repeating table sum

Learn two ways to calculate the sum of multiple fields in InfoPath using the InfoPath sum function in a repeating table.

Video Tutorial: Count persons selected in a people picker in a repeating table

Learn how you can use the count() function to count the amount of people that were selected from a person / group picker control that is located in a repeating table control on an InfoPath form.

Video Tutorial: People picker data merging in InfoPath 2013

Learn how you can use a formula in InfoPath to merge or concatenate the information from one or more users that have been selected in one or more people pickers in a repeating table and display the information of all of the users in a text box.

Select the latest date from a repeating table in InfoPath

Learn how you can use the max() function in a formula and conditional formatting in InfoPath to select and/or highlight the latest (newest) date in a repeating table.

Using InfoPath Math functions with repeating fields as input

Learn how to use the avg, sum, min, max, and eval functions in InfoPath together with repeating nodes to perform calculations.

Demo Video: Shrinking drop-down list in a repeating table

This InfoPath demo is the completed solution for recipe 116 of InfoPath 2013 Cookbook in which items are removed from a drop-down list box as the items are selected and added to rows of a repeating table on an InfoPath 2013 form.

Add or Delete Rows of a Repeating Table

4 Ways to programmatically add a row to a repeating table in InfoPath

Learn how to take advantage of the 4 overloads of the AppendChild method to programmatically add rows to repeating tables in InfoPath.

How to create a hidden column in an InfoPath repeating table

Step-by-step instructions describing two ways to hide a column in a repeating table in InfoPath.

How to pre-fill a repeating table in InfoPath with rows of data

Learn how you can add default rows to a repeating table in InfoPath, so that when you open the form, the repeating table already contains a certain amount of rows with data.

Programmatically add a row to a repeating table using an XmlWriter object

Use the XmlWriter object that is returned by the AppendChild method of the XPathNavigator object to add a row to a repeating table.

Programmatically delete the first row of a repeating table in InfoPath

Learn how to use C# or Visual Basic code to programmatically delete the first row of a repeating table in InfoPath.

Programmatically delete all of the rows of a repeating table in InfoPath

Learn how to use C# or Visual Basic code to programmatically delete all of the rows of a repeating table in InfoPath.

Programmatically execute code when a repeating table row is inserted or deleted

Learn how to add events to rows of a repeating table instead of its fields.

Programmatically hide the first row of a repeating table in InfoPath

Learn how you can use a hidden field and conditional formatting to programmatically hide the first row of a repeating table in InfoPath.

Programmatically prevent users from adding more rows to a repeating table in InfoPath

Learn how you can use the Changed event of a repeating node and the DeleteSelf() method to programmatically prevent a user from adding more rows to a repeating table in InfoPath when the repeating table already contains a certain amount of rows.

Demo Video: SharePoint list CRUD operations using an InfoPath repeating table

This InfoPath video is a demonstration of a repeating table on an InfoPath 2013 form that can be used to add, update, or delete one or more SharePoint list items with one call to SharePoint 2013.

Populate, Filter, or Loop through Rows

InfoPath 2003

Filter a repeating table on a date range using rules and filters

Use rules and filters to filter Microsoft Access database table records being shown in a repeating table on a date range using two date pickers.

InfoPath 2007

Auto-fill a repeating table with data from a SharePoint list when a row is inserted

Learn how to use rules and filters to automatically fill a repeating table row in InfoPath with data from a SharePoint list when the row is inserted.

Auto-populate a repeating table in InfoPath with sequential dates

Learn how you can use a function and formulas in InfoPath 2007 to populate rows in a repeating table with sequential dates by entering one date and having the rest of dates automatically calculated and displayed.

Autonumbering fields in a repeating table in InfoPath 2007 using VB.NET code

This article shows an example of using the Changed event of the row of a repeating table to programmatically autonumber a field in the repeating table using VB.NET code.

Copy a SharePoint list to an InfoPath repeating table using XSLT

Use XSLT and the XslCompiledTransform class in C# to transform the data stored within a SharePoint list (secondary data source) and copy the transformed data to a repeating table in the Main data source of an InfoPath form.

Filter a SharePoint list in a repeating table in InfoPath on a date range

Use conditional formatting on a repeating table in InfoPath to filter a SharePoint list on a date range using two date picker controls.

How to check whether the values of all fields in a Repeating Table in InfoPath have been set

This article shows you how to use Data Validation rules and Conditions on Rules in InfoPath to check whether all of the fields in a repeating table on an InfoPath form contain a value.

How to loop through items in a repeating table in InfoPath 2007

Use the XPathNodeIterator class with C# or VB.NET code to loop through the rows and items in a repeating table.

How to display images in a repeating table in an InfoPath browser form using a Rich Text Box control

While the Picture control is not available in InfoPath browser forms, you can write code to programmatically add a link to an image to a Rich Text Box control to display images in browser forms.

Programmatically copy rows from a SharePoint list to a repeating node in the Main data source in InfoPath

Learn how to use C# or Visual Basic code to copy the rows from a SharePoint list to a repeating node in the Main data source of an InfoPath form.

Programmatically create a custom SharePoint list from a repeating table in an InfoPath web-based form

Learn how you can use data from a repeating table in an InfoPath web-based form that you open on a SharePoint site to create a custom SharePoint list.

Selecting the minimum date in an InfoPath repeating table using formulas (no code)

Learn how you can use a formula (no code) in InfoPath to find and highlight the rows in a repeating table that contain the date that falls before all other dates in one of the repeating table's columns.

InfoPath 2010

Cascading drop-down list boxes in InfoPath 2010 - the non-traditional way

Learn about a non-traditional way of setting up cascading drop-down list boxes in InfoPath 2010 and how you can avoid infinite loops when running rules on fields that set each other's values.

Demo Video: SharePoint list lookup in an InfoPath repeating table

Watch a demonstration of how you can use data that is stored in a SharePoint list to look up and display data in a repeating table whenever data is entered into the repeating table control on an InfoPath 2010 form.

InfoPath 2013

Demo Video: Disable following rows if preceding row is empty in an InfoPath repeating table

This InfoPath video is a demonstration of how you can use conditional formatting to disable rows in a repeating table on an InfoPath form when a particular row has the focus and is empty thereby forcing users to sequentially enter data into the repeating table.

Demo Video: SharePoint Designer 2013 workflow to loop through InfoPath repeating table

In this InfoPath video you'll see how you can use a SharePoint Designer 2013 workflow to loop through rows of a repeating table on an InfoPath form and create SharePoint 2013 list items.

Demo Video: Update SharePoint tasks by looping through a repeating table on an InfoPath 2013 form

Watch this demo video of how you can use a SharePoint 2013 workflow to loop through items from a repeating table on an InfoPath 2013 form to update SharePoint tasks by reassigning them to a different user that has been selected through a people picker control on the InfoPath form.

InfoPath eval and sum functions to get the total length of strings in a repeating table

Learn how to use the sum, eval, and string-length functions in InfoPath 2013 to calculate the total amount of characters that have been entered into all of the fields in all of the rows of a repeating table on an InfoPath form.

Submit Data to SharePoint or a Web Service

How to submit the rows of a repeating table in InfoPath to a SharePoint list

Programmatically add items from a repeating table in InfoPath to a SharePoint list by submitting a CAML update batch to the UpdateListItems method of the Lists web service that comes with Windows SharePoint Services (WSS).

How to submit rows of a repeating table in InfoPath to a web service

Learn how you can create a .NET web service that accepts data from the rows of a repeating table on an InfoPath form.

Use Control Events

InfoPath 2003

Programmatically retrieve the value of another field in the same row of a repeating table

Use the Source property of the DataDOMEvent object in the OnAfterChange event of a field in a repeating table to retrieve the value of another field in the same row of the repeating table using JScript.

InfoPath 2007

Count the total amount of sections in a Repeating Section in InfoPath on insert or delete

Learn how to programmatically count the amount of sections in a repeating section control on an InfoPath form whenever a section is inserted or deleted.

How to get the current row number of a repeating table in InfoPath using VB.NET code

This article shows how you can use Visual Basic .NET code in an event handler on the row of a repeating table to automatically number the rows of the repeating table and then retrieve the number of the row in a repeating table in which the value of a field has been changed.

Programmatically retrieve the value of another field in the same row of a repeating table in InfoPath 2007

Use the Site property of the XmlEventArgs object in the Changed event of a field in a repeating table that is bound to a SharePoint list to retrieve the value of another field in the same row of the repeating table.

 

 Subscribe for updates via RSS or Email
InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services