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.
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 👏👏👏👏
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.
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 👍
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 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...
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!
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.
@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!
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.
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.
@@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. :)
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.
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?🙏🙏🙏
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.
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.
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?
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.
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?
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
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
