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?
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: