When Line Item is added create customer folder in SharePoint

Hi Everyone,

I’m looking for some help setting up SharePoint folder automation based on new line items added in my Monday.com board. I have two specific queries:

1st Query – Subfolder Creation

When a new line item is added and triggers the creation of a SharePoint folder, is it possible to automatically generate multiple subfolders within that newly created main folder?
For example, upon line item creation, I’d like the folder structure to look like this:

Main Project Folder

  • Photos
  • Designs
  • Reports
  • Docs

2nd Query – Folder Placement by City

Within my SharePoint site, my folder structure is already organised by:
Region > City
I also have a “City” column on my Monday.com board.

Is there a way to automate the creation of a new folder inside the correct city folder, based on the value selected in the City column when a new line item is created?

Thank you

Hello, Great questions! Here’s how you can approach both with Monday.com and SharePoint automation, usually involving Monday.com’s native automations plus integration tools like Power Automate or Zapier, since Monday.com’s native automations don’t directly support complex folder/subfolder creation on SharePoint out-of-the-box.


1st Query – Subfolder Creation

Is it possible to create multiple subfolders automatically inside the main folder when a new item is added?

  • Direct Monday.com Automation: Monday.com’s built-in SharePoint folder automation creates one folder per new item but doesn’t natively create multiple subfolders inside it.
  • Solution: Use Microsoft Power Automate (formerly Flow) or Zapier to extend functionality:
    • Trigger: New line item created on Monday.com (via Monday.com API or integration connector).
    • Action 1: Create main folder in SharePoint (using SharePoint connector).
    • Action 2: Create subfolders (“Photos”, “Designs”, “Reports”, “Docs”) inside the main folder programmatically.

This way, when a new item is added on your Monday.com board, Power Automate will create the main project folder and immediately add the subfolders inside it.


2nd Query – Folder Placement by City

Can the new folder be created inside the correct City folder based on the City column value in Monday.com?

  • Yes, this is possible with Power Automate or Zapier:
    • Trigger: New line item in Monday.com.
    • Action: Read the City value from the line item.
    • Logic: Based on the City, the automation navigates to the correct SharePoint folder path (Region > City).
    • Action: Create the new project folder inside the appropriate City folder.

To implement this:

  1. Map City column values in Monday.com to SharePoint folder paths.
  2. Use conditional logic in Power Automate to select the correct folder path.
  3. Create the folder in the right location.

Summary

Feature Monday.com Native Automation Power Automate / Zapier Solution
Create main folder on item creation Yes Yes
Create multiple subfolders inside main folder No Yes
Create folder inside City folder dynamically No Yes, with conditional folder path logic