Microsoft SharePoint List Data Destination

A Microsoft SharePoint List Data DestinationClosed 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. creates or updates items in a SharePoint list based on the data from a submitted form. You can use this destination to send data from Regular sections or from 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.. This topic describes what a SharePoint List Data Destination is, how it works, and the steps to configure it.

Available on the Advanced and Enterprise tiers:

Essentials
Advanced
Enterprise

Contents

What is a Microsoft SharePoint List Data Destination?

A Microsoft SharePoint List Data Destination is an out-of-the box integration point between TrueContext and SharePoint.

Use this destination to:

  • Map selected data from TrueContext to specific columns in a SharePoint list.

  • Dynamically sort submitted data into different lists in SharePoint.

  • Automatically create new SharePoint lists based on submitted form data.

  • Choose whether the destination should create new items (rows) in a list or update existing items.

Configuration options for a SharePoint List Data Destination

The following sections describe the different configuration options and how your choices affect the items in your SharePoint list.

Site Prefix and List Path

SharePoint List Site Prefix and List Path

When you set up your destination, you select a Site Prefix and enter a List Path. These depend on the location of your existing SharePoint list or, for a new list, where you want to add the list.

  • The Site Prefix tells us where the SharePoint list is, relative to the main (root) site.

  • The List Path tells us both the name and the location of your list, relative to the site prefix.

SharePoint List Data Destination path configuration for an existing list.

Tip:In SharePoint, the Web Address helps you determine the Site Prefix and List Path.

SharePoint List Web Address as shown on the SharePoint List Settings

To find the Site Prefix and List Path:

  1. Navigate to your SharePoint list. Select the settings icon, and then select List settings.

    Result: SharePoint displays the list Web Address.

  2. Does your Web Address include /sites/ or /teams/?

    • If yes, use the one that’s shown as your Site Prefix in TrueContext.

    • If no, use / as your Site Prefix.

    In this example, the Web Address includes a /sites/ prefix.

    SharePoint List Web Address as shown on the SharePoint List Settings

  3. Find your site name, which follows the site prefix. In this example, the site name is Inspections.

    Tip:
    • If your list is not in a site, you only need the name of the list.
    • If your list is in a subsite, take note of the whole path, including all of the subsites.
  4. Find your list name. The list name follows /Lists/ in your Web Address. In this example, the list name is Warehouse Inspections.

    Note:
    • Do not include /Lists/ when you enter the List Path.
    • If you change your list name, you must update your List Path.

Create or update lists

When you configure your List Path, you can decide if you want to create or update a SharePoint list.

Info:We’re now TrueContext.
Option What to enter in the List Path Result
Update an existing list The name of your SharePoint list
  • The destination creates the ProntoForms ID column and populates it with the Form Submission Reference Number.

  • The destination updates the columns you configure in the Column Mapping section.

Create a new list

A new name that’s not already one of your SharePoint list names.

Tip:You can use 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. in the List Path field to name the list based on information in the submitted form.

  • The destination creates the ProntoForms ID column and populates it with the Form Submission Reference Number.

  • The destination creates the columns you configure in the Column Mapping section.

Data from different form submissions routed to different lists

You can use DREL expressions to specify which list you want to send form data to. For example, if you have a different SharePoint list for each customer, you could configure your File Path as follows:

List Path configuration with a list name represented by a DREL expression. The List Name changes depending on the answer to the question with the Unique ID CustomerName.

When a user submits a form, the destination sends the data to the list with the same name as the customer. If a user enters a new customer name, the destination creates a new SharePoint list.

Column mapping

In TrueContext, you map submitted form data and metadata to your SharePoint list columns, as shown in the following example. Use a DREL expression to get the data from the submitted form.

Column mapping example. DREL expressions map data and metadata to SharePoint list columns.

Note:Consider the following:

Create or update items

For existing lists, you can configure a Microsoft SharePoint List Data Destination to either create or update items. To update an existing item, use the Match column to set up your matching criteria. If no match is found, the system creates a new item.

Example of a Data Destination column mapping for a SharePoint List.

Note:Due to a limitation of the Microsoft API, 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. can’t match on the SharePoint “ID” column. If you try to match on the “ID” column, the system creates a new item instead. If you need to match on an ID-type column, create a custom column in SharePoint.

In this example, the destination updates the item in SharePoint that matches the serial number.

SharePoint list example with data from a submitted form.

On the List Configuration tab, in the Column Mapping section, you select if you want to create or update items.

Option Behavior
Always create a new item

The system creates new items each time the destination executes.

Note:This doesn’t apply to different submissions within a single Form Submission life cycle. For example, incomplete TrueContext TeamworkClosed TrueContext Teamwork is an Enterprise tier feature that enables mobile users to transfer incomplete forms for other users to complete as part of a multi-user workflow. This can be useful for jobs that require someone else's expertise or that span multiple shifts.-enabled forms or forms sent for editing could result in updated items in SharePoint.

Update an existing item

The system displays the Match column as part of the column mapping table. When the destination executes, it updates the item that matches the selected column values.

Note:
  • When the destination finds a match, it updates the item.
  • If a mapped question is unanswered or missing, the system clears any existing data in the mapped column.
  • If you select more than one match column, the system must match all values.

  • If more than one item matches the value, the system only updates the first match.

Data from Repeatable Sections

You can create multiple items in a SharePoint list with data from a Repeatable Section. When you configure your destination, you can select an option to use it as a Repeatable Destination.

For example, when a user submits a form with a list of parts:

Repeatable section in the ProntoForms Mobile App with a list of parts.

The destination sends the data from each row in the repeatable section to the SharePoint list:

SharePoint list with items for each entry from the Repeatable Section. The list shows the ProntoForms ID and ProntoForms Row ID columns.

Note:All SharePoint destinations automatically create the ProntoForms ID column. Repeatable Destinations also create the ProntoForms Row ID column.

Supported SharePoint List column types

Use the following table to check the SharePoint List column types that TrueContext Data SourcesClosed Data sources, also known as "Lookups", are external sources of data that you upload or connect to TrueContext. You can reference this data in a form to populate answers or answer options. Data sources save typing, reduce errors, and make it easy to provide mobile users with only the relevant, most current data. and Data Destinations support.

SharePoint column type Data Sources Data Destinations
Single line of text
Multiple lines of text

Choice

Note:TrueContext doesn’t support columns that allow multiple selections.

Number

Currency

Date and time
Yes/No

Note:If the value in TrueContext is "yes" or "true", then the value in SharePoint will be "yes". Any other values will result in "no" in SharePoint.

Person or Group    
Hyperlink    
Calculated Only supported as a column to match on. You can’t send or edit data in Calculated columns.
Image    
Location

 

Prerequisites to configure a SharePoint List Data Destination

Steps to configure a SharePoint List Data Destination

  1. Go to MANAGE FORMS > Data Destinations > CREATE DATA DESTINATION > Microsoft SharePoint List.

    Result: The system opens a new Microsoft SharePoint List Data Destination in edit mode.

  2. Enter a Name and a Destination Unique Identifier.

  3. Do you want to send data to a SharePoint list from a Repeatable Section?

    • If yes, select Use as a Repeatable Destination for a Repeatable Section, and then enter the Repeatable Section Unique Identifier.

      Destination Basics tab, with option to "Use as a Repeatable Destination for a Repeatable Section" selected

      Tip:Ensure that you enter the correct ID. Remember, if you change a section unique ID, the linked destination does not automatically update.

    • If no, select Use as a Regular Destination for a form.

    Note:Once you link the destination to a form, you can’t change the destination type.

  4. On the Filtering tab, configure the conditions that each submitted form must meet for the Data Destination to execute.

    Info:Refer to the following topics for details about Data Destination filtering depending on your Data Destination type:
  5. On the Connection tab, select an existing Microsoft 365 Connection or create a new one.

  6. On the List Configuration tab:

    • Enter the location and name of the SharePoint list you want to create or update.

      Tip:Vanity URLs are a Microsoft SharePoint legacy feature.

      If your company hosts SharePoint lists in a domain different from sharepoint.com, select Site has a Vanity URL. Enter your custom domain name in the format my.company.com.

      • To create a new list, enter a new list name or DREL expression.

      • To update an existing list, enter the name of an existing list.

      Info:The section Site Prefix and List Path describes how to enter the list location and name in more detail.

    • In the Column Mapping section:

  7. Create your Data Destination.

    Tip:Remember that you need to link the Data Destination to each form that you want to trigger this destination.