Create a SharePoint List quickly | Power Automate

[@franknielsen3219]

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 👏👏👏👏

[@DamoBird365]

Cheers Frank. I appreciate the encouragement.

[@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.

[@joannadzieglewska7001]

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

❤ Thanks Damien, great demo as always 👍🎖️

[@esbenk.d.jensen9345]

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

[@DamoBird365]

Let me know if I can help and of course how you get on.

[@moyura2]

@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.

[@DamoBird365]

If you use the developer options, you might be able to track the api on the network tab and get inspiration on how to achieve it. I’ve not tried myself.

[@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.

[@DamoBird365]

Interesting, I love the discussion and ideas that crop up. Use an existing list as the source for the schema. You can 😱 with get list learn.microsoft.com/en-us/graph/api/list-get?view=graph-rest-1.0&tabs=http it returns the column array 👍

[@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.

[@MrLemmo]

Ace as ever, can you create a lookup column?

[@stephencoatesstephen4501]

Was there any reply to this or an additional demo that explains it, that would also include the capability to get the additional columns from the destination. This would be extremely useful in the expansion of this topic.

[@stephanedenis5394]

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.

[@DamoBird365]

I've not done specifically what you are looking for but there is a native action for graph api for outlook in preview. Send an http request. With that, you can explore learn.microsoft.com/en-us/graph/api/calendar-get albeit it does look like you need to know the specific id. There won't be a SharePoint equivalent.

[@stephanedenis5394]

@@DamoBird365 Thank you for your feedback and sorry for the late response. I'm an enthusiastic newbie... but I can't figure out how to run an http request at all. As I wrote in my initial message, the company administrator blocks the use of Microsoft Graph. I am looking for how to retrieve the calendar ID of a shared mailbox. In a flow I have to retrieve events in this shared calendar (and not in my personal calendar, that I know how to do) and I need the ID of this shared calendar. And to complicate the thing I have in another shared mailbox, several calendars or I could want to make operations with PowerAutomate. An idea for new video, manipulation of mailboxes and shared calendars. :)

[@tonjewaasj8155]

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?

[@DamoBird365]

Ah, I didn’t make it. What’s your use case? Feel free to drop me details.

[@tonjewaasj8155]

@@DamoBird365 I am creating temperary lists for new employees to fill in their language skills. So the flow is going to run every time a new employee is onboaring. Thought it might be better to get the fields from an Excel file than to hardcode them into the HTTP action...

[@bbangel90]

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 /sites/{site-id}/lists/{list-id}/?expand=columns 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?🙏🙏🙏

[@DamoBird365]

You can run the get response in a web browser (paste into the address bar and run it) and check if you have constructed it correctly based on the hitstory output of the http request in the flow.

[@powerplatformjesus964]

Thanks!

[@DamoBird365]

Thank you 🙏

[@LOchu-qn6xv]

Thanks

[@DamoBird365]

Thank you 🤩

[@KalLif-k3i]

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

[@mariocesena2277]

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!

[@DamoBird365]

That sounds possible. Interesting use case.

[@lewiscarr6556]

@DamoBird365, where is the documentation for the columns formatting? I am trying to replicate this but struggling with adding columns. Thanks in advance / Love your content!

[@DamoBird365]

Thanks Lewis, links should be in description 👍 learn.microsoft.com/en-us/graph/api/list-create?view=graph-rest-1.0&tabs=http#request

[@lewiscarr6556]

@@DamoBird365 Sorry, I wasn't clear in my question. where is there a list of the different column types and how they represented in the JSON?

[@DamoBird365]

You should be able to get definitions from learn.microsoft.com/en-us/graph/api/resources/columndefinition?view=graph-rest-1.0

[@KalLif-k3i]

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...

[@DamoBird365]

A few scenarios, maybe you regularly create the same list, want templates or have to create duplicate lists for ALM, this API call can save you loads of time. It can be 100% dynamic. Create the list from a form, a Power App, a solution during migration. I’ve not demo’d these options but a lot is possible.

[@subodhbaid8619]

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?

[@DamoBird365]

No idea 🤷 have you built it in graph explorer?

[@phd_gaming5010]

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?

[@DamoBird365]

There is a SharePoint Rest API to add/remove links from Navigation, you could look into that or try the forum powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums

[@phd_gaming5010]

thanks for the response! I managed to debug it a little earlier by getting all the IDs from navigation, compose to remove everything but the ID related to the current name and then remove that ID from quicklaunch. Annoying but now working! Next step. Figure out how to implement dependencies and attachment archiving haha@@DamoBird365

[@MrLemmo]

Can you add a site column?

[@DamoBird365]

Add a column to an existing list? Is that what you mean?

[@MrLemmo]

@@DamoBird365 as part of the ‘Create List’ flow can you add either a Site Column or a Lookup Column?

[@MrLemmo]

@@DamoBird365 or even create a list from a list template?

[@AdiCristea]

Thanks

[@DamoBird365]

Thank you very much Adi 👍