David Simpson Apps

Copy all assets from column to SharePoint folder for subitem

This automation block copies all the files from a column of type File on a subitem into the configured SharePoint folder for that subitem.

It works the same way as Copy all assets from column to SharePoint folder for item (L), but for subitems: you choose a File column from the subitems board, and the files go into the subitem's own folder rather than the parent item's.

You can also create a folder structure of subfolders, based on the column values from monday.com, as required.

Prerequisites

The subitem must already have its own SharePoint folder. Create it with Create folder for subitem in SharePoint, which nests the subitem's folder inside the parent item's folder.

If the subitem has no folder yet, the automation stops with a message saying that no folder has been configured. No files are copied.

The subitems board needs at least one column of type File.

For automations

Use the "Create from scratch" automation builder to select a subitem trigger, for example "When a subitem's status changes", then add "Copy all assets from column to SharePoint folder for subitem" in the Then section.

Automation sentence

In the sentence:

  • subitem files column lists the File columns on the subitems board. Choose the column that holds the files to copy. If the list says "No subitem file columns found", add a File column to the subitems first.
  • this (folder structure) is optional. Leave it empty to copy the files straight into the subitem's folder, or enter a structure such as /{Group.Name}/{Item.Name}/ to create subfolders inside it.

Select the correct Microsoft 365 account for the automation block, then save the automation.

For workflows

Create a workflow and for the action, select the "Copy all assets from column to SharePoint folder for subitem" automation block as a new action.

Workflow sentence

Workflow configure

How it works

Here’s a walkthrough video to show how the automation block works:

Things to know

  • Every file in the column is copied each time the automation runs.
  • Files are copied in the background, so large files or many files can take a little while to appear in SharePoint.
  • A file with the same name as one already in the folder replaces it.