Zoho Folder Creation in Sharepoint with Sub Folders [Tutorial]

During a recent ZUG meetup in Auckland, New Zealand, I shared how I could use Zoho Flow to create a folder in Microsoft SharePoint, along with its subfolders. As I am not a developer, I thought it would be helpful to post a guide for users who want to explore this option without writing extra code.

So, here's the scenario. Whenever a lead becomes a deal, we must create a new folder for the client in SharePoint. We have chosen SharePoint as our document management system for our company, hence the reason for creating the folders in SharePoint and not Zoho.

This guide can be followed by any user who wants to know how this can be done with little technical skills. 

During this process, you will be creating Variables and a variable is defined as

"In programming, a variable is a named storage location that can hold a value, which can be changed during the program's execution. It's like a container that can store different types of data and can be referenced by the name."

Steps to follow:
First, we have a trigger for the Flow to work, and that would be when the lead is converted to a Deal. 

After this, you need to create a New connection to your SharePoint and authorise the connection:
Create Folder

1. Name of your Connection
2. Variable Name - This is what you will be creating so that you can use it in future steps. I named it "make_base_folder" 
3. Name - will refer to the Folder name, which can be dynamic by using VARIABLES, and in my case, the Folder will be called "The Deal Name_Company Name". You can search for these under "Insert Variable."
4. Site - This will be the Selected SharePoint site you are using.
5. Drive - Will be the location of your Document Folder in SharePoint Site
6. Folder - This will be the Base folder where the new folder will be created. 

Optional - Send a message to Teams on error: 
I use this to notify me if the trigger fails so I can fix it


Team - will be the Teams Channel to post the message.

This is where I got stuck creating the flow. How do I create a subfolder? I could not use the Folder name that I created as, in my case, our Sharepoint Site has so many folders, so searching for "Folder Name" will not work as there could be other Folders with the same name. Therefore, instead of looking for the Folder Name, you need to look for the Folder ID, as this is a unique Field.



In the Step when you create a "New Folder", variables are created, and one of them is the "Folder ID" of the newly created Folder. 
Variable Name - this is a new variable you are creating to be used in steps after this. I used "fetch_new_folder".
Name - refers to this variable you created before with the ID, use "make_base_folder.id"
Folder - remains the base folder in your site as this is where the New Folder was created.
Optional: you can send an email or post to teams if there are errors. 

Now that we have the Folder ID, we can create a new Sub Folder using "create folder"



Variable Name - my new variable will be the subfolder I am now creating, and I called it "create_sub_folder_client_docs"
Name - Will be the Sub Folder, and my example was "Client Documents"
Drive - remains Documents
Folder - Since we are creating a subfolder in a folder from a previous step, we need to "Use a Custom Value" from the drop-down. This would be the variable we used before "make_base_folder.id"

This Step can be repeated multiple times to create other folders by calling the "make_base_folder.id" each time. You can create a Subfolder of a Subfolder using the variables you have created for each folder. 

Optional: Send a Post to Teams to say the Folder has been created.

This is my Final Flow for reference: 



A suggestion to Zoho will be to add the ability to create and upload files to Sharepoint, which will be a great addition to Zoho Flow. 

I hope this helps others who are trying to achieve the same outcome. 
Please let me know if it helped you and add to the discussion for more ways to use the SharePoint Flow connector. 

Shane Symons
Auckland New Zealand

• Topic Participants

• Shane Symons

• Javier Yebenes

  

• Recent Topics

• Directly Edit, Filter, and Sort Subforms on the Details Page

  Hello everyone, As you know, subforms allow you to associate multiple line items with a single record, greatly enhancing your data organization. For example, a sales order subform neatly lists all products, their quantities, amounts, and other relevant

• Create custom rollup summary fields in Zoho CRM

  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

• How can I create individual records from a subform

  Hi, I am collecting subform data into a Lead record and I need to create individual records for each row associated to the account when it is converted. How can I do this?

• What is the Desk API?

  I'm trying to fetch a lookup field data from desk to our creator application and it doesn't work. I'm guessing that my search parameter is wrong? On my trial function fetch if I use these: tickets = invokeurl [ url :"https://desk.zoho.com/api/v1/tickets/351081000145244764"

• How to choose other payment methodes than creditcards

  We have connected stripe as a payment provider in zoho books, booking, commerce and checkout. In stripe we selected al major payment methodes for Belgium (mainly bancontact). However, at checkout customers seems to have only the possibility to pay with

• Why is Zoho support so terrible?

  I've spent the last week trying to get zoho to fix sudden SSL certificate issues with our desk and project portals. I've raised a ticket and constantly been told the issue is on our side despite it being exceedingly obvious it's not. After finally convincing

• Custom "Filter By" in Client Portal

  Currently our client portal only shows items for that specific person that is logged on to the portal, we want the current logged user to see all items for that user's company. An example would be invoices, so the current user would see all invoices for

• Ticket Views: filter criteria -> dynamic date values in relation to the current date

  Hello all, It would be very helpful if you could build custom views in such a way that you do not have to adjust the criteria daily or at whatever interval in order to change the fixed date value as needed. For example, I would like to create a view that,

• Unlocking New Horizons: A Year in Review

  As we bid farewell to 2024, let's celebrate and revisit the key highlights of the year. From adding a new edition to cross-platform enhancements, here’s a roundup of all the feature updates designed to simplify accounting, optimize financial management,

• Introducing 'Queries' In Zoho CRM

  Hello everyone! We are here with an exciting feature - Queries in Zoho CRM! A little context before we dive right into the feature specifics :) In today’s fast-paced business environment, immediate access to relevant data is essential for informed decision-making.

• Enable Sending Direct Messages to Self in Zoho Cliq

  Hi, I would like to request a feature enhancement for Zoho Cliq to allow users to send direct messages to themselves. Currently, Zoho Cliq does not have the option to send a direct message to oneself. While creating a channel with just one member (the

• Admin Access to Direct Messages in Zoho Cliq

  Hi Zoho Cliq Team, We would like to request a feature enhancement to enable admin access to one-on-one conversations (direct messages) conducted through Zoho Cliq. Use Case: As administrators, there are situations where it becomes essential to access

• Need help with KPI Widget on Dashboard

  What I am trying to accomplish seems simple, but I cannot figure it out.  Please help. I would like to show in a KPI Comparison Widget: Number of Meetings (CRM) Held in Last 30 Days compared to Number of Meetings Held the previous 30 days (from the date

• Need to send message to slack channel from zoho people form

  - I have setup slack connection in zoho people, it is successfully showing connected - I am using connection name to send message view custom function, but it is not working: response = invokeurl [ url :"https://app.slack.com/client/T78002gHF/C089773324"

• User tiers

  I am trying to add tiers of users. I would like: Me - CEO Next Tier down - Managers Next tier down - All the salepeople reporting to each manager I can only seem to add myself with mansagers below. Surely I can add more tiers?

• Flow to follow up on trade fair contacts

  Hi, Before we moved to Zoho we had some flows (sequences) in HubSpot to follow up on trade fair contacts. To explain further on this it had the following characteristics: New contacts could be added to the sequence When added a flow of communication started.

• Queries filtered by current page/record

  I have been trying to use the new queries feature, and I can filter the query, but I'm coming unstuck because I don't understand how to make the query dynamically include the filter of the current record. ie if I'm on a deal, to filter all the records

• Article Numbers for KB articles

  Hello, I was wondering if it's possible to turn on article numbers/ part numbering for KB articles. If this is not already a feature, we'd like to request it. Frequently a solution will require multiple articles so tracking which articles are referenced

• Audit Log Export via API

  Hello, Based on the documentation here https://www.zoho.com/crm/developer/docs/api/v7/create-export-audit-log.html I need to specify the scope ZohoCRM.settings.audit_logs.CREATE to create a log export. I've created a Self Client app but when I specify

• Zoho CRM API Credits & Limits for Workflow

  Hi Team, Just wanted to clarify how the API credits work for Zoho CRM and workflows with custom functions. API Credits are based on your subscription and are set at the account level. You can buy additional credits if needed. For Enterprise customers,

• How to easy change layout in existing records in Deals?

  Hello, So far i have used only 1 layout in Deals. I have about 1000 records. Now i want to make new layout. So i have 2 layouts: Layout Old (1000 records) Layout New (0 records) How to easy change layout from Layout Old into Layout New for existing records?

• "Copy Field Values from one Module to another" how to use?

  Hi everyone! I'm sorry if this question was already asked, I didn't find it! So let me explain:  In my Tickets module, we have the custome field "customer type" where we indicate if it's a lead, user, etc... In the Contact module I used the "type" field with exactely the same entries. I would like when in the tickets module an operator choose an option that it automatically update it in the contact module. I found the "Copy Field Values from one Module to another" custom function which seems perfect

• New Leave Type: Compensatory off

  Hi, there is a new Leave Type: Compensatory off. Can someone tell me how to use it, because it sounds it could work for overtime compensation for our techs. Thanks Andreas

• Introducing bot filtering for accurate analytics

  Dear Zoho Campaigns Users, We're happy to introduce bot filtering to enhance the accuracy of your email campaign analytics. This new feature is designed to help you filter out bot-generated opens and clicks, which will ensure your campaign reports reflect

• Introducing Zia LLM: Zoho’s in-house Generative AI solution for CRM's AI capabilities

  Hello everyone, We're excited to announce the launch of our in-house Large Language Model (LLM) by Zia to power our AI offerings. What is LLM? LLM stands for Large Language Model, a powerful AI technology that processes and generates human-like text based

• How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

  How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

• Zoho Desk Validation Rule Using Custom Function

  Hi all, I tried to find the way to validate fields using custom function just like in Zoho CRM but to no avail. Is there a way to do this?

• Archive Option in Conversation View

  Hello, I have a suggestion\request to add an "Archive Thread" button in conversation view of Zoho Mail. The best suggestion I have is to put an "Archive Thread" button next to the "Label Entire Thread" button in conversation view. Most users don't just

• Possible to backdate Stage shifts in Deals module?

  I want to enter my organisation's historical dealflow data into the CRM and it's important that the Stage history is showing the correct dates in the past of when it happened. Is there a way for me to modify the "Modified Time" in the Stage History Related

• Layout Prompt when creating an oportunity

  Hi There, Is there a way to create a pop-up prompt when I create a new Deal giving me the option of what layout to use based on a certain requirement? So, if the prompt had two options 1. is a new business Deal 2. is a renewal Deal Thanks in advance

• Conditional layouts - support for multi-select picklists

  Hi, The documentation for conditional layouts says the following: "Layout Rules cannot be used on the following field types: Auto Number Lookup Multi Select Lookup User Lookup Formula File Upload Multi Line" I have a custom module with a multi-pick list

• Elevating Email Security on Zoho Desk: DKIM Now Mandatory

  Hello Zoho Desk Users! It has been a wonderful journey with you on Zoho Desk. As we welcome 2025, we are strengthening our efforts to ensure a secure and seamless experience for you. To enhance email security, DKIM configuration will be mandatory for

• How to upload mass inventory quantity adjustment with batch number?

  I wanted to clean-up our inventory list; however, I have trouble performing the task as I don't know how to mass upload inventory adjustment with batch numbers. I don't want to do it manually as there are if not thousands at hundreds of inventory tr

• Product sale report with margins

  we unable to get the data as per product sale report with margins so we need help in this

• CLIENT PORTAL (If clients can place orders directly on the portal)

  Zoho client portal is excellent. Everything is there except one thing. Client should be able to place orders directly on the portal. This would enhance the portal and end users will be extremely happy. This suggestion infact came from one of our client.

• Is there provision to charge the attendees to join the webinar?

  We want to host some webinar of public interest and want to charge them to participate in this. Does this feature in-build in the application? Offcourse, we will be having Razor pay account activated for these purpose.

• Zoho Vault App for Windows

  Hello, is there a Windows app that can be used to access the passwords saved in Zoho Vault? Thank you

• Emails take up to 14 hours to arrive and often never arrive at all.

  I've been on hold on your support phone for two hours. I spent an hour waiting to talk to somebody somebody finally picked up. They asked me to give them my ID number and when I found it, they were gone they didn't hang up. They just walked away from

• Emails take up to 14 hours to arrive and often never arrive at all.

  I've been on hold on your support phone for two hours. I spent an hour waiting to talk to somebody somebody finally picked up. They asked me to give them my ID number and when I found it, they were gone they didn't hang up. They just walked away from

• Print PO receipt

  Hi I would like to print the PO receipt. There does not seem to be any way to do this. I track batch numbers and printing the PO does not show this. Only the receipt would show the details of the receipt. Currently I print the screen which does not have

• Next Page