Upload a file to SharePoint when a new file is uploaded to a LawVu contract record

Upload a file to SharePoint when a new file is uploaded to a LawVu contract record

Upload a file to SharePoint when a new file is uploaded to a LawVu contract record

This automation is designed to back up a copy of all extra files saved to the supplementary files tab of a contract record to SharePoint. e.g. emails, spreadsheets, images, appendices, or schedules, that are stored separately in the files tab of that record.

This automation targets the supplementary files tab on a contract record. The other four flows in this series are designed to back up the main contract document at the core of a contract record. See other flows that work in combination with this one under the Getting started section.

Trigger

-->

-->

Action(s)

How it works

1

Workflow is triggered when a file is added or updated in the supplementary files tab of a contract record.

2

Get information about the contract record and the file, and grab a copy of that file.

3

Check in SharePoint if there is already a folder with the relevant name and a file with the same name.

4

Save the file in SharePoint or update the file with a new version if it already exists.

5

(Optional) Add a status message to the LawVu contract record to confirm that the automation has saved a copy of the file to SharePoint.

Getting started

To use this template, you must make some changes.

Modifying the template

Required:

  • Set the SiteAddress variable.

  • Set the Library variable (the name of the library where contracts should be backed up).

  • Set the LibraryFilePath variable (the URL version for that library, which might be different from the library name).

Optional:

  • Set the LegalContracts variable, renaming with your desired subfolder for your contract backups within SharePoint: the default name for the top-level subfolder is “Contract Backup”.

  • Set the FolderName variable, which is the naming format for the structure of the subfolder created for each contract record.

  • Modify the status message posted to that contract. This is the last action in the flow and acts as a notice on the contract record in LawVu that a copy of the file was successfully saved to SharePoint.

Folder structure and file naming

When backing up copies, think about naming conventions for the files and folder structures for the subfolders in which each file is saved. Note: these templates back up all files with the file name they already have.

Saving a file in the same location with the same name will save it as a new version of that SharePoint file. Our suggested folder structure for saving files from the supplementary files tab of a contract record (see flow Upload a file to SharePoint when a new file is uploaded to a LawVu contract record) within a root SharePoint folder is:

Contract Backup

    [contract type]

        Contract record ID [ID] - [name]

The flows that back up the main contract file suggest having a subfolder for the main contract file and its subsequent versions. Changes to the file name in LawVu will result in separate files within this subfolder. Our suggested folder structure for saving the main contract document within a root SharePoint folder is:

Contract Backup

    [contract type]

        Contract record ID [ID] - [name]

            Contract document

Other flows to combine with this flow

If you want to have every single version of any contract record backed up to SharePoint (or some analogous location), use a combination of the contract flows:

  • Upload a file to SharePoint when a contract document is updated in LawVu and

  • Upload a file to SharePoint when a new contract record is created in LawVu

If you want a copy of only the executed contracts backed up to SharePoint (or some analogous location), use a combination of the contract flows:

  • Upload a file to SharePoint when an already executed contract is uploaded to LawVu and

  • Upload a file to SharePoint when a contract is executed in LawVu

This is because the trigger for flow Upload a file to SharePoint when a contract is executed in LawVu only captures existing contract records that progress from another lifecycle stage to Executed. You’ll need the flow Upload a file to SharePoint when an already executed contract is uploaded to LawVu to also capture contract records created directly into that lifecycle stage.

This is because the trigger for flow Upload a file to SharePoint when a contract is executed in LawVu only captures existing contract records that progress from another lifecycle stage to Executed. You’ll need the flow Upload a file to SharePoint when an already executed contract is uploaded to LawVu to also capture contract records created directly into that lifecycle stage.

Pricing

Free

Author

LawVu

Categories

Contracts

File backup

Power Automate

Requirements

Power Automate, part of Microsoft 365 Power Platform, is a low-code automation platform which allows users to create bespoke workflows that customise and connect their legal workspace, creating effiicency through automation and standardized workflows.


The LawVu connector for Power Platform is required to use this workflow template.