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 can associate with the Flow to develop the seamless process across different application without moving away.

For each application, Microsoft Flow provides the different activities, 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 actions, triggers,

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

Though it has lot of actions, still Flow has limited services and that didn’t allow us to achieve some functionalities. To overcome 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 the 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 in the same name of title in Employee List.

  1. Select Flow from Office 365 App Launcher, to navigate to Microsoft Flow page
  2. In the Flow site, click Create from Blank button to initiate the Flow creation,
Create From Blank
Img1: Create From Blank
  1. Select When an item is created button to open a workflow designer page. We can also select Create from blank to navigate to workflow designer page.
Template Selection
Img 2: Template Selection
  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 the SharePoint,
Action for Triggering Flow
Img 3: Action for Triggering Flow
  1. Click New Step button and click on 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
Send an HTTP request to SharePoint - Action
Img 4: Send an HTTP request to SharePoint – Action
  1. Selecting the HTTP action opens a parameters box in a same page. There enter Site Address, select request method, Enter REST API url in URI and Headers
Site Address https://tenant.sharepoint.com
Method POST
Uri _api/web/GetFolderByServerRelativePath(decodedurl=’/lists/listname’)/

AddSubFolderUsingPath(decodedurl=’foldername’)

Headers {

“accept”: “application/json; odata=verbose”

}

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

Action Details
Img 5: Action Details

We have selected Title from the dynamic content from the Triggered List. So that after creating the item, the title from the item 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.

Success Status of MS Flow Instance
Img 6: Success Status of MS Flow Instance

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

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

Add new folder in SharePoint List using Microsoft Flow
Tagged on:         

Leave a Reply

Your email address will not be published. Required fields are marked *