Create a SharePoint List quickly

Create a SharePoint List quickly | Power Automate

Рет қаралды 6,295

Күн бұрын

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
Graph API Videos: • Graph API
Graph Explorer: developer.microsoft.com/en-us...
Graph Docs: learn.microsoft.com/en-us/sha...
Create a List Request: learn.microsoft.com/en-us/gra...
Column Types: learn.microsoft.com/en-us/gra...
#PowerAutomate #SharePoint
Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

Пікірлер: 41

@bi-ome 5 ай бұрын

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 👍🎖️

@franknielsen3219 9 ай бұрын

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 9 ай бұрын

Cheers Frank. I appreciate the encouragement.

@joannadzieglewska7001 4 ай бұрын

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

@powerplatformjesus964 Жыл бұрын

Thanks!

@DamoBird365 Жыл бұрын

Thank you 🙏

@Andychubs 7 ай бұрын

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.

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

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

@LOchu-qn6xv 3 ай бұрын

Thanks

@DamoBird365 3 ай бұрын

Thank you 🤩

@MrLemmo 4 ай бұрын

Ace as ever, can you create a lookup column?

@tonjewaasj8155 3 күн бұрын

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 3 күн бұрын

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

@tonjewaasj8155 3 күн бұрын

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

@mariocesena2277 6 ай бұрын

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 6 ай бұрын

That sounds possible. Interesting use case.

@moyura2 5 ай бұрын

@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 5 ай бұрын

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.

@bbangel90 4 ай бұрын

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 4 ай бұрын

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.

@user-nt7lj1nc8s Жыл бұрын

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

@subodhbaid8619 7 ай бұрын

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 7 ай бұрын

No idea 🤷 have you built it in graph explorer?

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

@phd_gaming5010 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

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

@user-nt7lj1nc8s Жыл бұрын

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.

@MrLemmo 4 ай бұрын

Can you add a site column?

@DamoBird365 4 ай бұрын

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

@MrLemmo 4 ай бұрын

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

@MrLemmo 4 ай бұрын

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

@AdiCristea Жыл бұрын

Thanks

@DamoBird365 Жыл бұрын

Thank you very much Adi 👍