...

Customers are responsible for configuring the On-premise installation and the integration with with SharePoint Online. The On-premise version of SharePoint must be version 2013+. Refer to this Microsoft website for information about how to use Office 365 to allow  to authenticate.

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. 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 <frevvo-home>\tomcat\conf\catalina\frevvo.xml 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.

SharePoint Token - under construction

...

Step 3 - Connect Forms and Flows with the SharePoint wizard

1. Login as a  designer user.

2. Create your form or flow with controls that capture the data that you want to store in the columns configured in the Lists and Libraries on your SharePoint website

3. Click on the what happens to my data? icon on the designer toolbar.

4. Select the Sharepoint Connector option. If the tenant is not configured for SharePoint, the Save to SharePoint wizard will not display.
   
   
   Enter a valid SharePoint id and password in the Save to SharePoint wizard
   
   
5. You’ll be redirected to login to SharePoint or Office 365 if you are logging into your account for the first time.
   
   1. On successful login, you will be asked to grant or deny access for your  SharePoint add-in.
      
      
      
      
   2. Click Trust It to authenticate and grant permission to . You will not see the trust screen on subsequent logins. The wizard will display.
      
      
6. You can set up a single Document Action to write to multiple places (SharePoint Library and List). Add a route for the second destination by clicking the Route 2 icon.

   1. Select a format for the Snapshot to be saved in SharePoint. The choices are: PDF, PNG or JPEG. If you do not check the Snapshot checkbox under the Destination Type section, you can leave this field empty.

      
      
      

   2. Enter the site URL - this is the SharePoint site or subsite containing the destination e.g. https://frevvo.sharepoint.com - Remember this URL must specify the https protocol. This value is read in from the SharePoint tenant configuration screen for Route 1.

   3. Set up the first location (route) where you want to save your files in SharePoint. SharePoint destinations can be a Library (and optionally a Folder), or List. Select Library or List from the Destination Type dropdown.

   4. The wizard pulls the list of Libraries and Lists configured on your SharePoint site to populate the Library/List dropdown. Select a choice from the list. Only destinations that the user has access to are displayed.

      1. If your Library has folders configured, the wizard will display a dropdown listing them. Select the destination folder from the list.

   5. Select a Content Type from the dropdown. The wizard automatically pulls the content type choices from your SharePoint site. The Content Type determines the available metadata column names for mapping. For example, if the destination is a Document list you would see Item as a choice for the Content Type. This means your submission is saved as a new item on your SharePoint list. Document Libraries show Document.as the Content Type.

   6. Check the types of files to be saved to the selected destination. The choices are:

      1. Data - checking this includes the XML document to be saved

      2. Snapshot - checking this includes a snapshot of your form/flow in the format selected in the Snapshot Format field to be saved

      3. Files - checking this includes attachments uploaded to your forms/flows to be saved. The wizard automatically lists the Upload Controls in your form/flow by name when Files is checked. The attachments for the selected Upload Controls will be saved in the configured destination. 

      4. Gen Forms - this checkbox appears if you have mapped PDFs associated with your form/flow e.g. W-4 and I-9 filled out by a new employee. Select the mapped PDFs that you want to store in SharePoint.
         
         

   7. Map the Control Names in your form/flow to the column names in your SharePoint destination. The wizard will populate the Column Name dropdown with all the columns in the destination but a maximum of 15 controls can be mapped.

      Tip
      When mapping Message controls with templates to the SharePoint Connector, the Save Value property should be checked.

7. Click Submit.

8. Click the save and test icon to save the form/flow and bring up Test mode popup.

9. If you configure a second Route, clicking the Clear Route button removes the information for Route 2 only.
   
   

...