Versions Compared

Old Version 3

changes.mady.by.user Former user

Saved on

compared with

New Version 4

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

 

The frevvo SharePoint Connector and wizard, make it easy to create forms and approval workflows that validate information, route for signatures as required and save the data and documents to a secure SharePoint website. The Connector was designed to integrate with Office 365 SharePoint Online.

All customers need a valid Office 365 SharePoint account.

Submissions can contain multiple files of different types - Invoice, Receipt, PO etc. You may want to save these files in different locations on your SharePoint site.

The SharePoint Connector wizard, allows you to:

  1. Save the form/flow data and metadata to a SharePoint destination. The destination could be a folder in a document library and/or a list item.
  2. Designers select the SharePoint destination from a dropdown
  3. Map form/flow control values to the SharePoint columns.
  4. Configure two destinations for your data.

The SharePoint wizard guides you through connecting your forms/flows to SharePoint.

Column
width300px

On This Page:

Table of Contents
maxLevel2

...

  1. Cloud Customers Connecting to SharePoint Online - This configuration had been certified by frevvo. Follow these steps:
    1. Configure Live Forms as a SharePoint Add-in
    2. Configure SharePoint for your Live Forms tenant.
    3. Connect your Forms/Flows using the SharePoint wizard.

  2. In-house Customers connecting to SharePoint Online - This configuration scenario has been certified by frevvo. Follow these steps:
    1. Configure Live Forms as a SharePoint Add-in
    2. Configure SharePoint for your Live Forms tenant
    3. Download the SharePoint Connector. Rename it to sharepoint.war. Copy it to the <frevvo-home>\tomcat\webapps folder
    4. Connect your Forms/Flows using the SharePoint wizard.

  3. In-house customers using SharePoint On-premise - this configuration is supported but not certified.
    1. Customers using SharePoint On-premise also need an Office 365 SharePoint Online account. This is necessary to obtain an authorization token. There is no data transfer from the SharePoint On-premise to SharePoint Online.
    2. Customers are responsible for configuring the On-premise installation and the integration with SharePoint Online.
    3. The On-premise version of SharePoint must be version 2013+.
    4. Refer to this Microsoft website for information about how to use Office 365 to allow  to authenticate.

  4. Live Forms Cloud customers connecting to SharePoint On-premise - This configuration is supported but considered unlikely as SharePoint On-premise requires your On-premise SharePoint to be exposed to the Cloud.
    1. Customers are responsible for configuring the On-premise installation and it's exposure to the Cloud. 

Configuring the SharePoint Connector

...

  1. Login to as the tenant admin

  2. Click the Edit Tenant link.

  3. Click the  blue arrow to expand the SharePoint section.

  4. Enter the Connector URL. - This URL is needed if you are using  in the cloud and installing the connector locally. Enter the URL where your installation that is configured for SharePoint is located. This URL must use the https protocol.

    The URL in the Connector URL field will override the connector URL that is specified as an installation parameter in the configuration property in the <frevvo-home>\tomcat\conf\catalina\frevvo-config.xml properties file. In some cases you can leave this field blank.

    Info

    The default value is shown below:
    <Parameter name="frevvo.sharepoint.connector.url" value="http://localhost:8082/sharepoint" override="false"/>

  5. Enter the Client Id and the Client Secret that you saved in Step 1 into the respective fields.



  6. Enter the SharePoint Domain Name e.g. <Your SharePoint tenant name>.sharepoint.com - there is a dot between the SharePoint tenant name and sharepoint.com
  7. To determine the realm for your SharePoint site :

    1. Navigate to https://<tenant>.sharepoint.com/_layouts/appprincipals.aspx - change the <tenant> to the name of your SharePoint tenant - e.g. https://frevvo.sharepoint.com/_layouts/appprincipals.aspx

    2. Find your registered application in the list and and look at the App Identifier column. The unique identifier after the @-sign in the App Identifier is the app realm and must be entered in the Realm field.



  8. Click Submit

...

All tenant admin(s) in your tenant or flow admin(s) configured for specific workflows will receive a Doc Post Failure notification email to alert them that an issue has occurred.

...

Max file size

The maximum size for files uploaded to the frevvo cloud is 1Mb. Since users are prevented from uploading files to that exceed the maximum file size value, the files will not be posted to SharePoint either.

Uploading a file to your form/flow that is bigger than the specified size, displays this message:

Image Removed

In-house customers can control the max file size by configuring the frevvo.attachment.maxsize parameter in the <frevvo-home>\tomcat\conf\Catalina\localhost\frevvo.xml file.

SharePoint Connector does not display under Document Actions

The Save to SharePoint wizard is not visible to the designer user if the tenant is not configured for SharePoint or  is not configured to run under https. Configure the tenant for Sharepoint or configure Live Forms to run under https to resolve the issue.

 

 

 all fevvo connectors is set to unlimited. Any size file can be uploaded to and posted to SharePoint.