Integrating With SharePoint

Mike Salyga
Mike Salyga
  • Updated

Integrating SharePoint with Ziflow lets teams run online proofing directly from SharePoint. You can create folders, upload files for new proofs, comments, and decisions. The result is a smoother review process and fewer handoffs in one familiar workspace

Before setting up the integration between Ziflow and any third-party tool, you need to connect Ziflow with the application. 

Connect with SharePoint

To connect to Sharepoint, you must have Sharepoint administrator rights to authorize access.

  1. Log into Ziflow. From the main navigation pane, select the Connect tab.
  2. Select Applications to open the applications list. Find the Sharepoint application and select Connect.

    Sharepoint-connect.png
  3. Authenticate with SharePoint credentials and then authorize Ziflow to access the SharePoint account.
  4. Select the Sharepoint tile again, choose the Settings tab, and select Show next to the Application fields on a proof to enable Sharepoint fields at the proof level.

    Sharepoint-show-application.png

 

Set up SharePoint automated flows

Once Ziflow and SharePoint are connected, you can set up automated flows to send information to Sharepoint.

Before you begin, connect your Ziflow app. See Connect your Ziflow app.

  1. Choose Connect and select Create Flow in the upper-right corner of the window.

    create-new-automated-flow.png

  2. Select Ziflow as the Application and choose which Event you want to start the integration. For more information, see Ziflow events.

    choose-Ziflow-event.png
     

  3. Add a SharePoint Zibot action to continue.

SharePoint Zibot actions

After choosing a Ziflow event, choose a SharePoint Zibot action that will pass the information from the Ziflow event directly to SharePoint.

Setting up Sharepoint Zibot action in Ziflow

If you're combining a Sharepoint flow with a webhook Zibot in it (For example, Event > Upload file to SharePoint> Search SharePoint file > Send Webhook), place the Webhook action right after the Upload file to SharePoint Zibot (Trigger > Upload file to SharePoint > Send Webhook) and skip the Search SharePoint file action. This ensures that the Webhook Zibot contains all details from the previous action.

 

Search SharePoint file 

Use to search for SharePoint files. Enter a file name or use a token, and Ziflow will look through SharePoint files for matching file names.

Field Description
Site The Sharepoint site
File name Enter a file name or use a token

 

Search Sharepoint file Zibot configuration

 

Search SharePoint folder

 Use to search for SharePoint folders. Enter a folder name or use a token, and Ziflow will look through all SharePoint folders for matching folder names.

Field Description
Site The Sharepoint site
Folder name Enter a folder name or use a token
Search Sharepoint folder Zibot action

Create SharePoint folder

 Use to create new folders in SharePoint. You have the freedom to choose the name of the folder and its location within the SharePoint folder structure.

Field Description
Site The Sharepoint site
Where the folder should be created Choose the root folder, or from a previous action or direct ID
Folder ID Choose the Resource ID token 
Folder name Choose PROOF.FOLDER.NAME token

Upload file to SharePoint 

Use to send the Ziflow asset file to the selected SharePoint folder.

Field Description
Source file (URL) The proof download link (already filled in)
Site The Sharepoint site
Target folder path The path to your Sharepoint with a subfolder that where you want to store your proofs. 
Target file name The name of the file (already filled in)

Upload file to Sharepoint Zibot configuration

In order to successfully upload a file to SharePoint, the Download of the original file option must be enabled at the proof level. Without this setting, SharePoint will not be able to access the file from Ziflow.

Download of the original file option

 

Search SharePoint library

Use to search for SharePoint libraries.

Field Description
Site The Sharepoint site
Name Enter the name or select the token
Search SharePoint library configuration

 


Connect Ziflow proofs with SharePoint files

Once you've connected SharePoint to Ziflow, you can start linking proofs with the SharePoint files from the Integrations tab while creating proofs or editing proof details.

If you do not see SharePoint in the Intergrations tab, enable it in the application settings. Go to the Connect tab, select the Sharepoint application, choose the Settings tab, and select Show next to the Application fields on a proof to enable Sharepoint fields at the proof level.

Show Sharepoint integration on a review level

To connect proofs in the Integrations tab, during the proof configuration, open an Integrations tab and select the SharePoint file (site & file).

Connecting Ziflow review with Sharepoint file

 

SharePoint flow examples

 

Automatically upload the Ziflow proof file to the SharePoint folder when a final decision is submitted on the proof and seamlessly populate application fields

 

Before you start configuring the flow, please make sure to read the Ziflow internal Zibots article. This step is necessary because you need to connect Ziflow as an internal application in order to use it to update proofs.

  1. Start creating a flow by selecting an event trigger which will be a Decision made. I selected the Approved decision made on a proof level as an event trigger. You can also set the event to be triggered only when a decision is submitted on a proof in a specific Ziflow folder (I selected the SharePoint reviews folder).

    Start creating flow by selecting Decision made trigger

     

  2. Choose the Search SharePoint folder from the Zibot list:

    Search Sharepoint folder Zibot

     

  3. Please ensure that all required information is provided in the Zibot configuration. In my case, I utilized a proof folder token as the Ziflow folder name corresponds exactly to folders in SharePoint. 

    Search Sharepoint folder Zibot configuration

     

  4. Now you can add an Upload file to SharePoint Zibot. It will send an asset file to a designated folder in SharePoint.


    When configuring Zibot, choose a site and enter the target folder path. You can provide the SharePoint folder path manually (e.g.: /your/sharepoint/folder/path) or use a JSON query to collect it from the previous action, such as the SharePoint folder search.

    Upload file to Sharepoint Zibot configuration

    JSON query:

     #{$.zibot[0].data.value[0].hitsContainers[0].hits[0].resource.webUrl ~> $replace(/.*Shared Documents/, '')}#

     

  5. Please add another Zibot to the workflow. This Zibot should be an internal Ziflow Zibot (Add proof integration property), and its purpose is to populate the site ID field of a proof with information sourced from SharePoint.

    Add proof integration property Zibot


    Fill out the Add proof integration property Zibot configuration. 

    Add proof integration property Zibot configuration

     

  6. At the end of your workflow add internal Ziflow Zibot (Update proof integration property), and its purpose is to update the proof integrations tab with the file ID field from SharePoint.

    Update proof integration property


    Fill out the Add proof integration property Zibot configuration. 

    Add proof integration property Zibot configuration
  7. In order to test the automation, start a proof in Ziflow and approve it manually. When the flow is activated, it will locate the appropriate SharePoint folder, upload the proof file, and populate the Ziflow proof integrations tab with relevant details about the file in SharePoint.

    Test flow scenario for uploading files to Sharepoint

     

Related to

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.