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

• What is Attendee Status 0 and 1?

  Hi there, I recently stumbled upon the API to get the attendee list and in the return value, there is a parameter called "status", and 0 supposed to mean not_attending, and 1 means attending. I cannot find this representation anywhere in the attendee

• How to add a Data Updated As Of: dynamically in text?

  I need to add a "Data Updated As Of" in the dashboard to show when was the last date the data was updated. I tried to create a widget but it does not look really good, see below. Is there a way I can do this through the text widget and update it automatically

• ZOHO BackStage

  How to get list of events, using ZOHO BackStage APIs. Is it possible OR not?

• Email with attachments saving attachments into Zoho CRM from Zoho Mail

  Hi, I get a lot of emails from prospective clients asking if we would bid their project. Those projects usually have many documents associated with them that I link to.  I would like to have those documents be saved as an attachment in my Potential or Contact or Account. I don't see a way to do that that isn't multi-step. As of now I do the following: 1.) Open email 2.) If email sender isn't in my Zoho CRM database I enter them creating a Potential 3.) I download the attachment and save it to a different

• 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

• Request For Quotation (RFQ) module

  Hello, Do you have any plans to implement a RFQ module in to ZOHO Inventory? I would like to chose items that I require a price for, select a number of different suppliers to e-mail and have them submit there pricing online. I would then like to see a

• How to Customize Task Creation to Send a Custom Alert Using JavaScript in Zoho CRM?

  Hello Zoho CRM Community, I’m looking to customize Zoho CRM to send a custom alert whenever a task is created. I understand that Zoho CRM supports client scripts using JavaScript, and I would like to leverage this feature to implement the alert functionality.

• Lookup Fields not Converting

  I manage holiday properties. I have a lookup to the Accounts (Properties) in the Leads module. The lookup is connected to the property address field. When I convert it the lookup field does not update in Deals, although the property address does. There

• Zoho Meeting iOS app update - Join breakout rooms, access polls, paste links and join sessions, in session host controls

  Hello, everyone! In the latest iOS version(v1.7) of the Zoho Meeting app, we have brought in support for the following features: Polls in meeting session Join Breakout rooms Paste link in join meeting screen Foreign time zone in the meeting details screen.

• Calculate hours between 2 date/time fields

  Hi, Does anyone know if it is possible to get the number of hours between 2 date/time fields in a zoho crm custom function? Thanks, Michael

• External ID validation.

  I added an external ID field as below in one of my custom modules: When creating records via the API using some value (eg: 762115b2-097e-43b2-bdba-f3924a5371a6) for this field, it works without any problem. I can create and even see the records on the

• Sales Order, what are the statuses under Confirmed and Closed

  Hi, I have to build a workflow in Deluge which should be triggered when Sales Order status is Confirmed or Closed. But these 2 states don't exist when you fetch a sales order. Which of the statuses are considered as Confirmed or Closed ? Here is a list

• CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

  Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

• Remove Address from credit card payment

  I would like to remove the need to add address when paying by credit card. I only want the customer to have to add their credit card details.

• Copy Widget to another Dashboard

  I can see the option to clone a widget to the same dashboard but is it possible to copy it to another dashboard?

• Create a button that executes a customized function

  Hello, I have created a summary view in which I combine the data from my items table and suppliers table. I would like to know if there is the possibility of adding a button somewhere in the view to be able to execute a function when clicked on it. I

• Custom field doesn't fill when converting sales order to invoice

  Hi, When I convert a Sales Order to an Invoice one of the custom fields on a product line names "Subsidie" does not seem to fill in automatically. I manually have to select the product again by clicking on the product name in the order line en re-select

• Can I use ZOHO calendar to schedule a Youtube video that is already in my youtube account, but listed as private or unlisted?

  I am creating Youtube videos and shorts and then uploading them to our Channel so others can view and approve. Once approved I would like to just schedule them over the next few days within Zoho. So far it looks like I have to re-upload the video to Zoho

• How to Display a Logo Image on a Public Form?

  I would like to display a logo image in the header of a form. To achieve this, I added an Add Notes field to the form. The code below works perfectly for Zoho users accessing the form. However, when the form is made public, the image does not load properly:

• Advice for my first project in Zoho

  Hello, how can I design and implement a customized ERP and CRM system using Zoho to automate and manage core business functions, including customer relationship management, property inventory, sales tracking, and financial processes. This is one of my

• Associate Email API Internal Error

  I am trying to associate an already existing email within a function using the Related Emails API. To provide more context, I also have admin permissions and have ensured that the fields are correct and that I have admin permissions when associating the

• Profit on Sales order

  Hi, would it be possible to implement a column at the Sales order overview of Purchase amount? So a field with the amount of all purchase related to this Sales order? This is very usefull so you will see the profit you made on this deal. I tried to get

• Subform Data in v2 REST API

  What is the mechanism for adding subform data in the Creator v2 REST APIs?  There is nothing documented in the Data APIs documentation (https://www.zoho.com/creator/help/api/v2/).   I was able to determine how to GET the subform data by adding it to the

• ZOHO Widget SDK not loading in html

  I have this code below, I have imported the widgetsdk however I get the error shown in the image, I have tried many different ways of importing and initiating the function ZOHO but nothing is working. can someone explain what I'm doing wrong, if I am

• Information problem

  ZOHO Guys, I am trying to evaluate your product as a serious business tool. However your attitude to providing key information such as 1. CRM Data Model 2. Product Roadmap and Enhancement promises 3. Complete and accurate help make it very difficult to recommend as a serious choice for small business. You may be cheap, but I would prefer to pay if it means not being kept in the dark! Kind Regards Andrew Copley

• How to create comparison time periods like these examples

  In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selected

• Overwrite Option for custom modules

  Hi Team, I noticed that the overwrite option is unavailable in Zoho Books when importing data for custom modules. This limitation makes it challenging to bulk update old data, as the only option is the 'bulk update' feature, which is restricted to 25

• Zoho Creator - Zoho Analytics

  I am facing an issue in Zoho Analytics where I am still seeing deleted data from the Zoho Creator form I created. Could you please look into this and let me know what needs to be done?

• Important updates to Zoho CRM's email deliverability

  Last modified on: Jul 24, 2024 These enhancements are released for all users across all data centers. Modified on: Oct 30, 2023 Organisations that are in the Enterprise and above editions of Zoho CRM, and have not authenticated their email-sending domains

• Unable to send emails

  I have this email parth@mrcolumbus.in, but I couldnt send outgoing email. Can you please help?

• Notifications push : Encourager le réengagement et renforcer la fidélité des utilisateurs efficacement

  Vous avez déjà souhaité engager et communiquer de manière proactive avec les utilisateurs, y compris lorsqu'ils utilisent votre application de manière peu active ? Zoho Apptics vous offre déjà des fonctionnalités qui vous permettent d'évaluer la performance,

• Easy way to delete attachments

  I've reached my data limit and would like to run a view/report, and mass delete attachments. Is there an easy, fast way to do this? Moderation Update: Post Summary: There are two features the post discusses a) Easy way to remove Email attachments Will

• How to add new deal to existing contact

  Hi, I want to add new deal to existing contact.

• Domain verification is in progress... (How long do I need to wait?)

  Trying to setup my first email domain by connecting with GoDaddy. Have been here for quite some time and the screen is not changing. How long should this take?Send DataSend Data

• Linking an email to a Contact when the email is sent in deluge via sendmail

  The "to:" address in this code is a CRM Contact. Email address is forced unique in CRM This sendmail gets sent via a workflow which is in a custom module. It works, except that the outbound email does not appear (i.e, get linked to) the Contact such that

• How to restore deleted Field

  I edited a field in zoho form and by accident I deleted a field (email address). The form is ongoing to be filled by respondent. Then, when I checked to the all entries and report, the email address is gone. I checked in audit log, there is a record that

• How to select multiple notes at once in the PC client?

  In the PC client, you can select notes using ctr+LMB. But why can't you use shift+LMB? PC version 3.2.0

• Feature Request: Search in the PC client. Some thoughts about the search.

  Hi all. I'm really excited to start using Zoho Notebook, but I'm missing some of the search capabilities on my desktop. There are also some thoughts on improving search in general. Search is very important to me, without it it is difficult for me to use

• Create Your Own Issue Management System

  Effective issue management is a cornerstone of project success. Every bug or issue, no matter how small, needs to be tracked and resolved in time to maintain project momentum. In this post, we’ll explore how an issue management system in Zoho Projects

• How I can add customized Invoice

  Hi, I wanna use a customized Invoice, how i can add that

• Next Page