Create List in SharePoint Using Power Automate and HTTP Post

In today’s post, we will see how we can create a list in SharePoint site using Power Automate and an HTTP Request.

First, we must be administrators with the required permissions to create a new site.

We need to log in to our active M365 subscription and then select Power Automate.

At the top left, select New Flow, and then choose Instant Cloud Flow.

In the next step, enter a new name.

Select a new action of type Send an HTTP request to SharePoint.

Fill in the right-hand panel with the following details:

Site Address: URL of your site
Method: POST
Uri: _api/web/lists
Headers:
- accept: application/json;odata.metadata=none
- content-type: application/json;odata.metadata=none
Body:

{  "__metadata": {    "type": "SP.List"  },  "AllowContentTypes": true,  "BaseTemplate": 100,  "ContentTypesEnabled": true,  "Description": "My new list created via Power Automate",  "Title": "MyNewList"}

Key Parameters Explained

BaseTemplate: * 100: Custom List (Most common)

101: Document Library
105: Contacts
107: Task

Pro Tip: Handling the Response

When you create a list this way, SharePoint returns a large JSON object containing the Id (GUID) of the new list.

If you need to add columns to this list immediately after in the same flow, you can use an expression to capture that ID: body('Send_an_HTTP_request_to_SharePoint')['d']['Id']

Save the Automate flow.

Then test it to confirm everything works properly.

Select Run Flow.

And it executes successfully.

The list has now been created.