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 👏👏👏👏
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.
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.
Hi there, great video! I was wondering whether you can remove the requirement of the Title column via HTTP after creating a new list? I would like to do this via REST where possible
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.
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. :)
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!
This is really good. thank you. I'm wondering if there is a way to get a list of group members and then create and populate that list on SPO using a similar method
@@DamoBird365 the office 365 groups connector in power automate will provide a list of people belonging to a group. the task is to get that list that the connector provides and create a list on SPO. I was able to accomplish this yesterday with your video. the one thing is that it creates a new table every time that the job runs. Would it be possible to get the list that was created and only look for the office group people who are either new to the group or who are no longer in it and add or remove them from the same list from the day before? i guess it is a way to track group/department changes.
@@DamoBird365 I was able to achieve that task with Help from your video. i retrieved the list with the 365 groups Connector. the second piece would be to compare the list today from the list yesterday to check for who is no longer on the first list. the issue im having is that the lists are created new, so I'm looking for a way to have the lists name in SPO static for example: an SPO Master list will be untouched, and the new list will always have the same name.
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...
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.
@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!
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
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.
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?
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 👏👏👏👏
Cheers Frank. I appreciate the encouragement.
Thanks!
Thank you 🙏
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.
@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.
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 Damien, great demo as always 👍🎖️
Thanks
Thank you very much Adi 👍
I really needed such a solution!
Thank you very much!❣
Thanks - I’ll give this a go and see if I can solve an deployment issue :)
Let me know if I can help and of course how you get on.
Hi there, great video! I was wondering whether you can remove the requirement of the Title column via HTTP after creating a new list? I would like to do this via REST where possible
I believe it would be possible. If you use developer tools, you might be able to spot the api call and repeat it.
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.
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. :)
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!
That sounds possible. Interesting use case.
This is really good. thank you. I'm wondering if there is a way to get a list of group members and then create and populate that list on SPO using a similar method
From an excel sheet? What are you thinking?
@@DamoBird365 the office 365 groups connector in power automate will provide a list of people belonging to a group. the task is to get that list that the connector provides and create a list on SPO. I was able to accomplish this yesterday with your video. the one thing is that it creates a new table every time that the job runs. Would it be possible to get the list that was created and only look for the office group people who are either new to the group or who are no longer in it and add or remove them from the same list from the day before? i guess it is a way to track group/department changes.
@@DamoBird365 I was able to achieve that task with Help from your video. i retrieved the list with the 365 groups Connector. the second piece would be to compare the list today from the list yesterday to check for who is no longer on the first list. the issue im having is that the lists are created new, so I'm looking for a way to have the lists name in SPO static for example: an SPO Master list will be untouched, and the new list will always have the same name.
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?
Ah, I didn’t make it. What’s your use case? Feel free to drop me details.
@@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...
@@tonjewaasj8155 I'm trying to do something similar with my flow as well. Was wondering if you had any further luck with this?
Ace as ever, can you create a lookup column?
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.
@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!
Thanks Lewis, links should be in description 👍 learn.microsoft.com/en-us/graph/api/list-create?view=graph-rest-1.0&tabs=http#request
@@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?
You should be able to get definitions from learn.microsoft.com/en-us/graph/api/resources/columndefinition?view=graph-rest-1.0
I'm trying to figure out why I would use this method...
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
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...
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.
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?
No idea 🤷 have you built it in graph explorer?
Can you add a site column?
Add a column to an existing list? Is that what you mean?
@@DamoBird365 as part of the ‘Create List’ flow can you add either a Site Column or a Lookup Column?
@@DamoBird365 or even create a list from a list template?
Thanks
Thank you 🤩