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

• Necesito el código ZB para mi cuenta

  Hice cambio de servidor y no encuentro el codigo unico de cname.

• Privacy error

  Privacy error on Chrome for all embedded forms and reports, this is a huge issue: "Your connection is not private Attackers might be trying to steal your information from creator.zohopublic.com (for example, passwords, messages, or credit cards). NET::ERR_CERT_COMMON_NAME_INVALID"

• Automate Backups

  This is a feature request. Consider adding an auto backup feature. Where when you turn it on, it will auto backup on the 15-day schedule. For additional consideration, allow for the export of module data via API calls. Thank you for your consideration.

• Bug - OTP (email) and No Duplicates

  Scenario: Form with an email field, Validation: "No Duplicates" (because I want to ensure 1 entry per email). Embedded form into website (JS option). Enabled email based OTP. 1st test (via my website) - entered my email address - sent OTP - entered pin,

• Customise Search Bar in CRM

  Is there a way to customise this search bar in the CRM to add fields?

• Counting downloads of a file

  Hello Could anyone help me, I would like to use a custom script to count how many times a file contained in a record has been downloaded. Is that something that is possible in Creator? Thanks Estelle

• Is there any way to prevent emails from being sent from zoho crm without pressing email opt out?

  When I left my desk yesterday I excitedly thought I had fixed my problem, by making use of the "Inactive" field ... However after contacting the support chat, they have advised to stop emails being sent I need to update the "Email Opt Out" field - which

• New Search Function

  Hey Team, The search function updated in our CRM about a week ago, so I assume it was an automated update across Zoho. It no longer displays leads/deals etc in Chronological order so that the most recently created or updated is the first to display which

• New permissions for accessing emails sent via Zoho CRM

  Last modified on Nov 4, 2024: Permissions for accessing emails sent via Zoho CRM have now been extended to the IN DC. With this rollout, the feature is now available to all users across all DCs. Resources: Data sharing for emails, Configuring email compose

• is it possible to add more than one Whatsapp Phone Number to be integrated to Zoho CRM?

  so I have successfully added one Whatsapp number like this from this User Interface it seems I can't add a new Whatsapp Number. I need to add a new Whatsapp Number so I can control the lead assignment if a chat sent to Whatsapp Phone Number 1 then assign

• Request for Alerts on Workflow and Function Changes.

  I want to get an alert whenever a new workflow or function is added or an existing workflow or function is edited. Is there any way to do that? I need to log all changes whenever updates are made or new ones are added.

• Transfer Amount from One Vendor to Another Vendor

  One of the vendors, who has a balance with us, has closed the business and has started a new business; Now he wants me to transfer the outstanding from the old account to the new Vendor Account. I am trying to do this using Payment Settlement a/c, But

• Been getting this error, every now and then "Get count limit exceeded, please try again after 3 mins"

  it is really annoying.

• How to make Branch compulsory in Zoho Books invoice?

  How I make Branches compulsory in Zoho Books invoice?

• Regarding GST Report Issue in Zoho Books

  Hi, Right now, the very important point from my end is this Zoho Books issue. Here, you can see that we have created the invoice with the items of account sales and expenses. The journal is also correct. The profit and Loss statement is also correct.

• Default Ship To Address on Purchase Orders cannot be different than Organization Address

  Our organization address is not where we want shipments delivered, it is just a mailing address. We would like to change the Ship To address on our PO's so that by default it is our warehouse (not the mailing address). I understand that when creating

• Function #57: Automatically group items in invoices based on categories

  Hello everyone, and welcome back to our series! As a business expands and new product lines are launched, it becomes important to organize the items for better inventory management. The Category field in Zoho Books helps here by allowing you to add and

• Fixed asset management

  I want to know if there is any individual module for fixed assets management

• Suppress "spreadsheet will not be saved" message on published sheet

  I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheet

• Differences between Zoho Books and Zoho Billing

  Without a long drawn out process to compare these. If you were looking at these Books and Billing, what made you opt for one and not the other. Thanks

• unable to import transactions into zoho books

  I download a csv with separate columns for deposit and withdraw. The sample has zero's in the blank spaces so I ensure mine does too. When I try to import it says the fields must have values greater than zero.

• Zoho Forms Unable to Save Account Numbers with a Leading Zero

  We are using Zoho Forms to for rental applications. It is working well, except for one thing:  when a user enters their bank account information, and that account number actually starts with a ZERO (like 00123456) the Zoho form will return the value without

• How to include GST% in PO amount?

  Currently when I raise PO, the basic price of the item is used. However, the GST is not calculated and added along with the basic amount. I have added a Custom field for GST in the PO but I need Zoho Inventory to calculate the GST amount and add it with the Basic price to give me the final PO price.

• sitemap in zoho sites not updating

  I checked my sitemap and it has not added any updates. Do I have to generate one manually all the time or is zoho sites suppose to generate and update it?

• I trying to connect our PM tool but API shows failure

  Hi All, in ZOHO CRM when an enquiry stage is moved to WON then I have created a rule to trigger POST URL to thrid party AP and then create a function for mapping with below code void automation.kytesfunctions(String enquiryId) { // Fetch enquiry details

• 2 serial numbers for 1 item (Mac address and Serial number)

  There is a way to track 2 serial number type for 1 Item. Ex: Some electronic devices have a MAC address and a serial number. I need to track those 2 numbers

• Sample Ticket - Created from Bot Preview

  Why is Zoho desk adding bot created tickets?

• Webhook data is not being received

  We’ve set up the webhook with a public URL that returns a 200 status on Postman. However, when we ran a test, we didn’t receive anything in the req.body object or see any data from the POST request. As a team of freshers still learning the ropes of development,

• Number of Workflow runs

  Is there a way in Zoho desk to see statistics regarding workflows, rules and other automation objects? Would be nice for several reasons: You could ensure that your workflows are actually running. You could determine which ones weren't being used so you

• Mail is no longer populating CRM contacts

  Hi! For the last few days, my mail hasn't been populating my CRM contacts. Even people I email multiple times per day. In fact, it keeps trying to send mail to myself. Notice, I started typing Amy and only got as far as, "Am" and it suggested myself.

• Zoho Support is indeed shocking and difficult to get a response with

  All our business emails have an auto-foward set up on them so that they also go to our GMAIL accounts so that we receive them to the relevenat people. The emails are indeed auto forwarding and arriving to our GMAIL accounts but when you log into your

• How to get a list of selected records into a button-function? Here is how!

  So, you might know already how to get a button on a page somewhere and perform actions with a function when pressed, but how about a button that only works with the records you selected in the list view? The button selected is a custom button in the modules

• How to Add Break line / Return on button click

  I need to return the text concate with difference field from lead with line break i try "\r" ,"\n" "<br>" return "ali \r\n <br> baba"; None of above work.  i expected result something like this  ali baba but got this  ali \r\n <br> baba so, how can i

• How to get batch number of item by api?

  Hi there, Is there any way to get batch number of item by api? Batch number is the batch reference number in https://www.zoho.com/inventory/help/advanced-inventory-tracking/batch-tracking.html . When I call the https://www.zoho.com/books/api/v3/#Items_Get_an_item

• Serious question: Are there actually "solo-preneurs"/small business owners who made Zoho-one work well for them?

  L.S. After already many years of continued struggle with Zoho-One, I am seriously wondering if there are actually solo-preneurs (one person small business owners - without a large, dedicated IT dept.) who got it (Zoho-One) to work well for their businesses.

• Announcing new features in Trident for Windows (v.1.18.6.0)

  Hello Community, Trident for Windows is here with some new features to elevate your workplace communication. Let's take a quick look at what's new. Ask and send read receipts for emails You can now request read receipts for specific emails while composing,

• Dialing Microsoft Teams Phone Service via Zoho CRM

  I am using the VOIP option in Microsoft teams for my office phone system. I was hoping to have a way to dial numbers directly from Zoho CRM, but don't see anything in the Teams Integration or in the Telephony integration that will enable this. Does anyone

• Increase subscription prices for existing subscriptions

  Hi, Does anyone know how we could achieve the ability to increase the subscription fee for our existing customers based on a % increase. We are not yet using Zoho Billing (Subscriptions) and I'm not sure if it is a good fit for us. But we would need to

• Why developing custom function development made so difficult for Zoho Projects!!

  Hi Zoho Team, I am trying to write function to automate a process but whatever API name or Column Name I use, the API isn't populating certain fields. Even the standard fields aren't getting populated through API. It's already exhausting to find all API

• Delete / Modify Default Career Site - Zoho Recruit

  Hello, It would be very useful if we could delete a default career site or change which of our career site is the default. Our Career site was created when there were issues with Zoho Recruit creating English CTA buttons on French Career sites. The only

• Next Page