Create Folder In SharePoint List Using Microsoft Flow

Microsoft Flow is a Cloud based automation service available as a component in Office 365, that enables us to build the workflow process across different applications / services.

Microsoft Flow is a Cloud based automation service available as a component in Office 365, that enables us to build the workflow process across different applications / services. There are n number of Microsoft and Third party applications that can associate with the Flow to develop the seamless process across different applications.

For each application, Microsoft Flow provides  different activities and trigger points to automate the business process. Microsoft Flow also provides unique activities and trigger points for SharePoint. The below link provides the details about each action and trigger.

https://docs.microsoft.com/en-us/connectors/sharepointonline/

Though it has a lot of actions, Flow still has limited services which don't allow us to achieve some functionalities. To over come some of the limited areas, recently Microsoft added a new action to the Microsoft Flow for SharePoint that enables us to send SharePoint REST API requests to achieve most of the SharePoint functionalities using the action called Send an HTTP request to SharePoint

Follow the below steps to use the Send an HTTP request to SharePoint action to create a folder in SharePoint List.

Scenario: We have two lists called Employee List and Employee Contents List. Whenever a new item is created in Employee List, a folder will be created in Employee Contents List with the same name as the title of Employee List.

  1. Select Flow from Office 365 App Launcher, to navigate to Microsoft Flow page

    Microsoft Flow

  2. In the Flow site, click Create from Blank button to initiate the Flow creation,

    Microsoft Flow
  1. Select the "when an item is created" button to open a workflow designer page. We can also select Create from blank to navigate to the workflow designer page.

    Microsoft Flow

  1. In the designer page, name the flow as Create Folder
  2. In the designer page, provide the trigger information by selecting Site URL and List name from SharePoint,

    Microsoft Flow

  1. Click the New Step button and  the click on the Add an Action button. This will open a list of available actions in a popup, from the list of actions, select Send an HTTP request to SharePoint action

    Microsoft Flow

  1. Selecting the HHTP action opens a parameter box in the same page. There enter Site Address, select request method, Enter REST API url in URI and Headers
Site Addresshttps://tenant.sharepoint.com
MethodPOST
Uri_api/web/GetFolderByServerRelativePath(decodedurl=’/lists/listname’)/AddSubFolderUsingPath(decodedurl=’foldername’)
Headers{  "accept": "application/json; odata=verbose"}

After filling in the details, the request action should look like the below screenshot:

 Microsoft Flow

We have selected Title from the dynamic content from the Triggered List. So after creating the item, the title from the item is used as a folder name.

  1. After filling up the inputs, click Save button to save the Flow.

To test it, create a new item in Employee List and navigate to Flow to check the status of the instance.

Microsoft Flow

 

The green tick represents the success status. So, both of the actions in our Microsoft Flow instance are successful  and the ShanthaKumarT folder is created under Employee Contents SharePoint List.

Hence, using Send an HTTP request to SharePoint enables a lot of possibilities to work against the SharePoint objects through Microsoft Flow.