Form Connector – OneDrive for Business

Form Connector – OneDrive for Business

This article provides details on linking your app to OneDrive storage using the built-in connector after Connecting to OneDrive (Personal) and authenticating a connection for the connector to use. Alternatively, you can use Connecting to Microsoft Graph.

For more detailed information on the OneDrive service, consult the official support documentation.

Adding the Connector

Follow these steps to add the connector to your specific form:

  1. Navigate to App Workshop > Forms.
  2. Hover over your desired form and click the Connect icon.
  3. Click the Add Connector button (top-right).
  4. Select OneDrive for Business from the options.

Remember to Save

The page will refresh with the connector added. Changes are not live until you click Save.

Configuring the Connector

Using Connection

If you have more than one OneDrive for Business or MS Graph Connection, you will need to choose which connection you’ll use for this form connector.

Send Form Answers

You can choose what format you want your Form entry data to be sent as. 

File FormatDescription
CSVSend form data in a .csv attachment.
Customizable using a Text file template.
JSONSend form data in a .json attachment
Customizable using a Text file template.
ExcelSend form data in an .xlsx attachment.
Customizable using an Excel template.
WordSend form data as a .docx attachment.
Customizable using a Word (.docx) template.
PDFSend form data as a .pdf attachment.
Customizable using a Word or Excel template or a built-in template.
WordSend form data as a .docx attachment.
Customizable using a Word (.docx) template.
XMLSend form data as an .xml attachment.
Customizable using a Text file template.

Send Media Files

If this is checked, you will be able to select the individual media files to send/attach.

These could be signature images, photos, or other attachments.

Anonymize Personal Data

If the this ption is enabled, media files marked as Personal Data will be excluded.

Site Name

This field is required if you use an MS Graph connection to authenticate this form connector; then you will need to provide a Site Name. This field value can be either the SharePoint site URL (e.g., tenant.sharepoint.com/sites/mysitename), or simply the Site or Subsite name.

App-only MS Graph Configuration

If using an App-Only Microsoft Graph Connection with restrictive permissions (e.g., Sites.Selected), site search is disabled; you must provide the full SharePoint site URL (e.g., tenant.sharepoint.com/sites/mysitename) to establish the connection.

File Name

Optionally enter a custom Microsoft OneDrive file name of your choice.

You can also create a dynamic attachment name using fields from your Form – hit the hammer icon to build it.

The file extension (.pdf, .xlsx, .docx etc) will be added to your name automatically.

Disable Random Code

Disable the default system behaviour of appending a 6-character random code to the generated file name.

e.g., instead of ‘FileName-abc123.pdf’, the file would be generated as ‘FileName.pdf’

Folder Path

Optionally, enter a folder path on Microsoft OneDrive for the exported file to be placed in. Path should be entered in the following format:

‘FolderName/AnotherFolder/FileGoesInThisOne’

Anonymize Personal Data

If enabled, data from fields marked as Personal Data will be converted to a non-human-readable format to aid privacy.

You may be interested in the information in our knowledge base on Outputting Data with Templates and Run Conditions.

    • Related Articles

    • Data Source Connector – OneDrive for Business

      After adding and authenticating a OneDrive for Business or MS Graph Connection, you can pull data from an Excel or CSV file in your OneDrive for Business account on a timed refresh using Data Source Connectors, which is the focus of this article. ...
    • Connecting to OneDrive for Business

      MS Graph Connections Preferred We highly recommend connecting your Microsoft services using the Microsoft Graph integration. As the unified gateway to Microsoft 365, a single MS Graph connection securely authenticates SharePoint, OneDrive, and Excel ...
    • Form Connector – Excel Online

      The Excel Online connector automatically pushes form-captured data as new rows into an Excel worksheet. Feature Details Availability Premium Feature Requirements Active MS Graph Connection Action Create/Update Excel Rows Adding the Connector Follow ...
    • Form Connector – Power BI

      This is a Premium connector that directly connects to Microsoft Power BI. Power BI is a business analytics solution that includes multiple tools and building blocks to visualize your data and share insights across your organization. Our platform ...
    • Form Connector – Box

      Box is a Secure Cloud Storage Platform used to store your data files. It allows you to easily share these files with others, similar to the way you would with other cloud file storage services like Dropbox, Google Drive, and OneDrive for Business. ...