Send Data from a Repeatable Section to a SharePoint List

This recipe shows you how to send multiple rows of data from quality checks recorded in TrueContext to a SharePoint list. You’ll set up a form to include a Repeatable SectionClosed A Repeatable Section is a subform that contains a set of related questions. The data captured is “repeating”, because the field user can complete the same subform more than once, which creates multiple entries. so your technicians can enter multiple line items. Then, you’ll create a Microsoft SharePoint List Repeatable DestinationClosed A Repeatable Destination is a TrueContext Data Destination that sends data from a Repeatable Section to a field-based, third-party system. to map each entry from the Repeatable Section to a SharePoint list.

Available on the Advanced and Enterprise tiers:





Your field users perform random quality checks on a number of boxes of produce. They answer the same questions for each box when performing the quality checks. Your back office maintains a SharePoint list with records of all quality checks.They also store PDF documents for each quality check in a Microsoft SharePoint Document Library to capture rich data, such as images.

You can use TrueContext Repeatable Sections and Repeatable Destinations to:

High-level process

System Action Result
SharePoint Navigate to an existing site to find the site name. This site stores the SharePoint list that the Repeatable Destination creates.
TrueContext Build a form with questions in a Regular SectionClosed A Regular Section is a set of related questions grouped together for easy reference. The data captured is “non-repeating”. That is, field users enter a single instance of each answer.. When a technician fills out the form, they only need to answer the questions in the Regular Section once.
Add a Repeatable Section to the form with the Unique Identifier QualityQuestions. The technician adds the quality checks as entries in the Repeatable Section.
Create a Microsoft SharePoint List Repeatable Destination. This Repeatable Destination sends each entry in the Repeatable Section as a new item in a SharePoint list.
Configure your destination to create a new list in your Inspections site. The system automatically creates the list in SharePoint.
Map the data from the Regular and Repeatable Sections in your form to your SharePoint list. The destination adds an item in SharePoint for each entry in the Repeatable Section. It also adds the answers from the Regular Section on every item.
Add the Data Destination to the form, and then deploy the form. When a technician submits the form, the destination creates the SharePoint list and creates items based on the data from the form.


In SharePoint

Navigate to an existing site. In this example, the site name is Inspections.

Result: The site URL includes the Site Prefix and Site Name.

SharePoint site URL showing the site prefix and site name. The site prefix is /sites/ and the site name is Inspections.

In TrueContext

  1. Create a new form.

    New form named "Quality Check". The form has two questions with the Unique IDs InspectorInitials and DateInspection.

    1. Name the form Quality Check.

    2. Add questions with the Unique IDs Inspector and DateInspection.

  2. Add a Repeatable Section to your form:

    ADD A SECTION > Repeatable

    New repeatable Section called Quality Check, and with the Unique Identifier QualityCheck.

    • Enter QualityQuestions as the Repeatable Section Unique Identifier.

    • Add questions to your Repeatable Section. Take note of their Unique IDs.

  3. Create a Microsoft SharePoint List Data Destination (MANAGE FORMS > Data DestinationsClosed A Data Destination specifies where to send data from a submitted form. You can use Data Destinations to automate data sharing and storage, routing data to a specific service (such as email or cloud storage) in several different formats. > CREATE DATA DESTINATION > Microsoft SharePoint List).

    On the Destination Basics tab:

    1. Select the option to use as a Repeatable Destination.

    2. Enter the Repeatable Section Unique Identifier QualityQuestions from step 2.

    Use the Data Destination for a Repeatable Section, and enter the Repeatable Section's Unique Identifier.

  4. On the List Configuration tab, enter the Site Prefix and List Path as follows:

    Site Prefix and List Path configuration. The Site Prefix is /sites/ and the List Path is Inspections/%f

    1. Site Prefix—Select /sites/.

    2. List Path—Enter the site name, and then use a DRELClosed Data Reference Expression Language (DREL) is used to get form data and metadata and add it to a string, such as dates, usernames, or answers to questions in forms. expression to reference the form name.

    Result: When the Data Destination executes, it creates a list called “Quality Check”, which is also the form name.

  5. Map the questions in your form to columns in the SharePoint list:

    Column mapping using answers from the form's repeatable section and regular section. The option to always create new items is selected. Each answer is mapped to a column that the system creates in SharePoint.

    1. Select the option to Always create new items.

    2. Use the %a[UniqueID] DREL expression to reference answers from Repeatable and Regular Sections.

    • The system adds answers from the Regular Section to each new item in the SharePoint list.

    • When creating new lists, the destination creates the columns you enter when it first executes.

  6. Attach your Microsoft SharePoint List Data Destination to your form.

    1. Open the form “Quality Check” in edit mode.


    3. Select the destination you created in step 2.

    4. SAVE AND DEPLOY your form.

  7. In the Mobile App, open the form, enter data, and submit the form.

    Result: The Data Destination creates a SharePoint list with items for each entry in the Repeatable Section.

Alternative configuration options

Update an existing SharePoint list

  1. Enter the name of the list in the List Path field.

  2. When you map answers to the list columns, enter the names of existing columns. TrueContext can’t create new columns in existing lists.

    Result: The system maps data from submitted forms as items in an existing SharePoint list.

Update items in SharePoint

  1. In the Column Mapping section, select the option to Update existing items.

    Result: The system displays the Match column.

  2. Select one or more columns to match on.

    Result: The system updates the items with a matching value in the selected column.

Related topics