Create a SharePoint List quickly | Power Automate

Learn how to use the Graph API via the SharePoint V2 API to create a new SharePoint list with dynamic columns and datatypes via a single Power Automate Action. This is an incredibly useful solution for those that build prototype lists for their Power Apps. Create a column definition and fire up a list in seconds. In this video I will demo how to create a list fast using the SharePoint REST API in Power Automate, explain how it works via the Graph API, highlight some key documents and explore how the flow is built and how it works. You will also see how to create an item on that newly created list - all part of the same flow!

Would you be interested in combining this with batch data loads? What's your use case? Let me know in the comments below.

00:00 Intro
01:06 Demo creating a list via Power Automate
03:00 Graph Explorer
06:10 Microsoft Docs
07:02 Exploring the flow build
10:50 Outro

#PowerAutomate #SharePoint

[bi-ome]

OMG this is so awesome. Thank you so much for putting this together. It looks like it will be extremely useful for creating/moving lists where we don't have PowerShell available as an option.

❤ Thanks Damien, great demo as always 👍🎖️

[franknielsen]

I have had so many problems creating lists with the http request with date/time columns, but this was the trigger to solve it. Thanks again for very good PA videos. It seems so easy when you show it 👏👏👏👏

[joannadzieglewska]

I really needed such a solution!
Thank you very much!❣

[esbenk.d.jensen]

Thanks - I’ll give this a go and see if I can solve an deployment issue :)

[MrLemmo]

Ace as ever, can you create a lookup column?

[AdiCristea]

What an awesome... Damo! 😉. Would be interesting to understand if we can grab the list schema, for example if we add/remove columns after we create it this way and we want to create a similar list in Test/Prod using the latest schema.

[Andychubs]

I’m getting a bad request error for the action/ step after getting the site id. I think this is where the issue comes from. When I try to select the id from the dynamic content option in the next step I only have the option for body and not id.

[tonjewaasj]

Great video! You say you are going to make a video where you use an Excel file as the source for the list. I did not find it. Have you made that video?

[moyura]

@9:20 Find this section useful for cloning global navigations to a new SP site; but got stuck with the nested navigation. Thanks for sharing.

[mariocesena]

Great video! I have a question, can I start this flow using a web part? For example, a button on my SharePoint site that says "Create a list" and it makes that list. That's what I'm trying to accomplish now. Thanks!

[bbangel]

Thanks for the helpful video. I could successfully follow your instruction to send a POST request and create a list, but then tried and failed to send a GET requests to retrieve an existing list properties. The return response that I get is "status": 400, "message": "Unexpected response from the service". Hoping to see if you have any similar experience or can explain for me what problem is?🙏🙏🙏

[stephanedenis]

Thank you for this demonstration.
In my big box, the admin has blocked the use of Microsoft Graph Explorer. Do you think a derivative of this trick (_api/site/id) can be used to find the calendar ID of a shared mailbox? I saw some tutorials to find the ID... but always using Microsoft Graph Explorer.
Thanks again for these helpful videos.

[ntljncs]

I'm trying to figure out why I would use this method...

[subodhbaid]

Very helpful but struggling to get it to work. On the action to create a new list - it errors with a message "List not found clientRequestId: xxxx serviceRequestId: xxxx" even though I have a POST method and have setup the Uri and body as shown. Any ideas?

[ntljncs]

Can you show a real world purpose for this because it looks like it can only create one unique list at a time, manually... I don't quite get it...

[phd_gaming]

Hi, no clue if you will ever see this but I am kind of stomped right now. In my specific case I do not want the new list to appear on the sharepoint navigation tab but it keeps appearing automatically (without creating the link). I tried hidden=true, but then it totally disapear even from the site content. Help?