Microsoft Sites Document Library Data Destination


This feature is available on the following tiers: Enterprise, Advanced.



The Microsoft Sites Document Library Data Destination sends submitted forms to Sharepoint Online using the Office 365 Connection.  Create custom file and folder names based on data in the form to logically organize and manage files.

To set up a destination, follow the instructions here: Creating and Maintaining Data Destinations

Data destinations automatically back up data collected in the field.  They reduce the need to visit the web portal by making submitted forms available through the services you already use.  Different documents can also be sent to different services with a single form submission.  Read here for more information on data destinations.


Microsoft Sites (also known as Sharepoint Online) is a part of the Office 365 suite of tools and services. Document Libraries are file repositories on users' collaborative Sites.


Basic Set Up


  1. Create the data destination following the instructions here.
  2. Set up the File Configuration tab as discussed below.

[ top ]


File Configuration

This tab is where you set up where ProntoForms sends your form submissions. As long as the connection is configured, the form submission will be sent regardless of whether the site path (Data Record Document Folder Expression) is correct. For more information on fallback locations for form submissions, please jump down to read: Fallback Locations



Send attachments in separate files, alongside the Data Record Document.

Optionally choose to send attachments (images, signatures, barcodes, etc) as separate files.

[ top ]


Site Prefix 

The site prefix is the part of your site path that tells us where the Document Library you're trying to send form submissions to is, relative to the main site. There are three types it could be:

  • / : The Sharepoint URL, e.g., aka the root site.
  • /sites/: A sub-site to the main company Sharepoint, e.g.
  • /teams/: A team site created for a specific group of people on the main company Sharepoint, e.g.

[ top ]


Folder Expression

The folder expression tells ProntoForms where to deliver your documents. This section details how you find and enter the folder expression when setting up the Document Library Data Destination. You can find the URL for your Document Library in your browser address bar, or in the Settings listing, as shown below.


The folder expression should be in this format:

<site/subsites>/<document library>/<folders>

So, in the case of our example screenshot:

engineering/Health and Safety Demo/Forms

While all of these are optional, you must provide at least one. You may also create the folder expression using Data Record Expression Language (DREL).

Note: The Folder Path Expression does not accept special characters such as '.' and ','. Using these may lead to destination failure.

[ top ]


Custom Metadata

Make your files more searchable in your Document Libraries by adding custom metadata to the document sent to Microsoft Sites. Metadata consists of key: value pairs that belong to files. For example, an invoice  document may have a key:value pair of invoice_id: %r[id] 

  • Key:  Enter static text.  This is limited to 255 characters.
  • Value: Value expressions usually include Data Record Expression Language. Use data from submitted forms as the value; collect the answers to specific questions with unique IDs.  

ProntoForms does not support writing custom metadata to a metadata column set to the "Managed Metadata" type in Sharepoint. 


[ top ]


Fallback Locations

If your folder expression is incorrect but the Connection is functional, ProntoForms will still send the form submission to your Sharepoint site. If you cannot find a form submission in the target folder or document library, please:

  1. Check your file path to ensure the file prefix and folder expression are both correct.
  2. Check the following locations:
    • the root site or base sharepoint URL (/) if a site is not found or provided.
    • Documents (Shared%20Documents) if a document library is not found or provided.
  3. Depending on where you find the form submission, re-check your file path and whether the document library exists. ProntoForms cannot create a document library, only folders within that document library and/or site.

[ top ]


Testing and Troubleshooting Data Destinations

Data destinations should be configured and tested carefully before using them in production. This is key to ensuring that ProntoForms data is received correctly. Please consult the recommendations for testing and troubleshooting data destinations.

Read here for common error messages you may encounter with this integration and how to resolve them.

[ top ]

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request