Select Section...

Note: This solution is released as ‘Beta.’ It has not been tested with a large numbers of audits.

Setting up MS Flow and SharePoint

Step 1. Install a sync application supported by MS Flow (One Drive for Business, DropBox, Box). We have installed One Drive for Business. DropBox and Box can also be used as they are cross-platform.

Step 2. Setup MS Flow to connect the chosen sync application with your SharePoint site.

Step 3. Install SafetyCulture’s audit exporter tool.

Step 4. Configure the audit exporter to save audits in the sync folder.

Done! Audits are automatically pushed to One Drive for Business…

…and then to SharePoint.

 

Supported platforms

You can connect to SharePoint Online or to an on-premises SharePoint 2013 or 2016 farm using the On-Premises Data Gateway to manage documents and list items (source)

Caveats

The solution will break down after more than 5000 items get imported to the same folder in SharePoint. A workaround is to manually move files to other folders inside SharePoint or modifying the audit exporter code slightly to export files in a folder structure organized by date or other suitable criterion.

MS Flow can be expensive when large quantities of files will be transferred. At the time of writing, you can purchase 50,000 extra runs for $40/month.

SharePoint sites containing some characters will not work (e.g. single quote characters in site name such as “Dimitri’s Site”).

Filenames that are not accepted by SharePoint will fail to be imported. More information on restrictions and limitations is available here.

You would have to manually ensure that the exporter tool is running e.g. set it to automatically restart when the computer is restarted.

You have to ensure disk space does not run out, as downloaded reports and application logs grow.