Flow: Create SharePoint List REST API with Power Automate

Automating the creation of SharePoint lists can be handled in many ways.

At times, a need arises to pass on the ability for another to create the SharePoint list to a pre-defined specification, for a customer perhaps when working from a design.

Below are the steps you would use to create a list using Microsoft Power Automate.

Here is the full Flow:

As detailed above, start with a button and "Manually trigger a Flow", unless of course you want to adapt this and use a recurrence, HTTP POST or whatever you suits your use case.

Next, I am initialising 2 variables that include the SharePoint Site URL and one for the list name. Again, not required, you could just add them to them in to the "Send an HTTP request to SharePoint" action but this is a little neater and can help for changes in the future.

Now for the all important REST POST call.




Accept | application/json;odata=verbose

Content-Type | application/json


"AllowContentTypes": true,
"BaseTemplate": 100,
"ContentTypesEnabled": true,
"Description": "This is a SharePoint list called @{variables('ListTitle')}",
"Title": "@{variables('ListTitle')}"

Just name everything in the way I have, paste in the code, amend your naming to suit and a SharePoint list will be created.

More information on the creation of SharePont lists using the REST API can be found here.

Thanks for reading, AlanPs1

Do you need assistance building this Flow?

Visit the Get Help section of the Power Automate Community