Power Automate Tutorial - SharePoint HTTP Connector Part 1- GET

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
[Music] what's up guys welcome back I am joined today once again by Ashley Rogers Ashley how you doing today I'm great how are you I'm good I'm getting over the holiday hangover getting back into the swing of things but I'm excited it's uh it's 2020 it's a new year and it's gonna be a great one I have a good feeling about it awesome okay so Ashley recently joined us to help show us child and parent flows and after that video that she did such a great job I was like we got it we got to do some more stuff together and so I asked her if we could do something since her wheelhouses share point if we could do something on the sharepoint HTTP connector to which she obliged and so that's what we're here to do today and so I'm gonna actually introduce herself for those of you that might not know her and then Ashley after that the floor is yours okay guys so like John said we're gonna talk about the sharepoint HTTP connector empower automate today so really a great way to sort of power up your flows do some interesting cool thing this may be that you can't do out of the box so doing some things that aren't it's not premium that's a really great thing here this is not premium like the other HTTP connectors that you might be familiar with yeah um so again I'm Ashley Rogers I am a sheet senior SharePoint consultant with peat group I also do a lot of speaking and my focus you know lately has been power automate but really I've got a deep background in SharePoint so I love sharing that with you guys and seeing what we can do if you want to follow me on Twitter that's my handle there at Ashley Kay Hillier and if you want to check out my blog it's sp in between blog spot.com I'm actually working on a series right now where it's for SharePoint newbies so this is perfect power automate it's gonna be featured in there soon so check it out cool and I'll have her links down in the description for easy clicking alright so let's talk a little bit about SharePoint so if people aren't familiar with what Cheryl does it's kind of like a buzzword right everybody's familiar with the word SharePoint but maybe you're not using it every day or maybe you're using it at work and it's sort of boring and it really sure what you can do with it sure points actually super super cool so really this is a place for document storage and collaboration you can work with your office documents inside of SharePoint you can store different lists and all the metadata about those things so if you're if you're used to working maybe with c.d.s and entities it's a very similar concept you know you can build your lists you can store data about things and then do some super cool stuff inside power automate with SharePoint data another thing that we work on a lot is the end-to-end business processes so we've got support for requests and approvals there's a lot of add the Box stuff that works nicely with power automate you can do some things like portfolio management document sets are a specific piece inside of SharePoint but again you might you might be familiar with but maybe it's not something that you use all the time and I do a lot of stuff with SharePoint that that I can't even quantify here right there's a lot of stuff that that goes on that people request they want to say can SharePoint do this and my answer is yeah probably again let's figure it out yeah and so I think a quick way I always like to break these down and relate them for people like document storage it's like onedrive or Dropbox where can i whole things lists and metadata management it's like a fancy Excel spreadsheets columns and rows right and then end-to-end business processes before there were flow approvals and approvals and all sorts of other systems SharePoint actually has a whole built in system for approvals and requests and and managing all the the audit trail of all of that and so I think those are you know three quick real-world applicable ways that you are already familiar with some of the concepts happening here all right so what we're really talking about today is inside of power automate so the connector the SharePoint connector you've got lots of different triggers here the most popular ones that I've seen especially working in the forums and things like that people want to see things kick off when items are created or maybe when somebody modifies a document modifies an item we want to send a notification we want to do something cool with that and maybe build into that like a request process or an approval process things like that so I've got a lot of great triggers and there are over 40 actions in power automate for SharePoint there's some really interesting things in there that maybe if you're not super familiar with SharePoint might not be applicable to you yet but if you are a SharePoint person I definitely definitely stress you should go look at the documentation look at what's available to you and things keep getting at it stuff that I used to have to do with the HTTP connector and actually using you know rest calls there now making those into actual actions so we're taking the low code no code approach and really pushing that into SharePoint definitely there they're constantly trying to update that connector and add new stuff and make it accessible to everybody yeah for sure for sure and it's very exciting for me to see I love that stuff so so again today we're looking at the HTTP to SharePoint connector as I mentioned before unlike other HTTP actions this is not a premium connector it's actually the only one that's not premium because it's really a part of the Microsoft stack you're really staying inside of office 365 there's no handshake to third parties that you have to do it uses the connection that you already have inside of Office 365 your license is already there and it's so this really is a great reason to how is your data in SharePoint you know if it's something that you can do in SharePoint try it out try this you know try it on for size and and really try to dig in to see what you can what you can do with it totally yeah so and it's it's also super flexible right so if you're if you're used to HTTP if I say that and that that makes sense to you from a development standpoint you're gonna know that you can actually use things you're familiar with so rest calls and then the HTTP verbs which we'll go over you know get post patch delete these are words that we've heard before especially if you've done some of this and so you really can do a lot of powerful very cool things with this connector so the first thing I want to talk to you guys about is the anatomy of an HTTP request to SharePoint so if you're not super familiar with what's going on this is something that we really need to dig into and take a peek at so instead of boring it with the slides we're gonna go straight into a demo let's do this okay okay so what I've got for you here is a flow that has the get method for the HTTP request to SharePoint I'm gonna break these items down here I'm gonna show you what goes into each box but first I'm gonna bring it over to SharePoint to kind of level set us to get us where we need to be so if you watched the other video where we talked about the parent and child flows your this is gonna look super familiar to you and if you didn't I'll show you what I've done here I've got a list inside of SharePoint this is my Northwind traders site and I've got in this this is my flow testing area this is what I do when I've got something I'm trying to try out I've got a different type of column that's everything that's available inside of SharePoint so that I can just easily test and easily look things up here so we're gonna work against this list I'm gonna bring this back to my colors so we've got three items three different colors and this is what we're gonna be pulling back so if we take a peek at the URL here we've got our site name and then we've got forward slash lists and then forward slash flow testing so that makes sense right we're inside the Northwind traders site where we've got our call out to it's a list and we're gonna say that this is the flow testing list you don't need to think about any of the other stuff here the color set aspx and this UID that all has to do with what we're looking at but really what we care about is the URL so if I go back over here to our flow we're gonna see that all that stuff that is in the URL actually maps into the HTTP request to SharePoint action here so got our site address and then we've got our method that isn't mentioned in the URL but certainly we know that we're gonna grab some items so we're gonna use get and then the URI here it's not tricky it's really just something that stands for URL that's when you see URI you can think URL the only extras here that aren't involved in the other URL is the API if the underscore API forward slash web and then we see lists so what we're trying to do here is send a request to SharePoint that says hey I'm gonna talk to the API we're talking to the web I'm looking at the lists and then we've got get my title so we're talking to the lists for getting by the title and the title is flow testing and just put that in single quotes and then to indicate what I'd like to get back we just do a forward slash items the question mark it's a special piece don't worry about that for now but you just need to know that that's part of the formatting right so we've got the the call out to the endpoint and we'd say that we went back to the items if we wanted a particular item we put that inside parentheses we supply the ID but we don't need to do that right now okay so then in the headers this is again not super tricky but if you don't know what's going in here it can kind of it can kind of be intimidating all we want to do is say accept and then application four slash JSON Oh data equals verbose so this is gonna bring back this is telling the endpoint that I would like to bring back everything I want to see everything that's in the flow testing list I want all the metadata all the data about the data and bring back everything so that I can do something cool with it a side note because I know my developer friends are gonna say something about this when you're doing this in production you're gonna say oh data equals no metadata that's super important we don't want to bring back extra data it's something that we have a couple of blog posts about I can point you guys towards something after the video but definitely to do your development you want the OData equals four rows okay so when you do an HTTP request to SharePoint you're gonna get a whole bunch of data back now you might be familiar with the parse JSON action because we've done that before we've seen that in the last video that I've done and we're gonna need this in order to do something interesting with the data that comes back right so let's go ahead and run this flow and see what comes back we're gonna get a lot of data okay success so ignore the rest of this here I'm gonna demonstrate something to you in just a moment but we're gonna do is open the action here and then look at the body and you can see that I've requested all this metadata it's kind of great stuff in here it's everything that I had that came back all right so I can do whatever I want with this data I can then pass it into the parts JSON action I can then update another list I can send a notification this is basically bringing back everything now this might seem a little redundant right because we also have get items action and that is something that is out-of-the-box built-in and power automate you don't need any code for that so why do we use the HTTP request instead of just the get items well so the get items also provides support for filters order bys top counts all that good stuff that you could build into your HTTP request here I could add in filter anything like that here but a part comes in when you don't have support inside power automate to do a specific thing so for me this is all about document sets I love working with document sets I've talked about this before it's something that a lot of folks do in order to manage portfolios legal documents all that good stuff different requests and there's no support for document sets currently inside a power automate you've got to do all of that using the HTTP connector so as an example here I am building this request to send this over to SharePoint and say hey I want to get back all the content types which is going to be my first step and actually document-centric West we're not going to cover that here today but I just want to show you that the power of actually using this against SharePoint to do something really really cool yeah yeah and it's funny you know because like you said there were a lot of times where in the past this connector was needed to do things right but as time goes on like you said oh there's the scale items now I don't need to build a a get request from the from the API because I just have a native action and flow but I think you know the big point is when you're doing this when you're doing some advanced work in SharePoint there's still a lot that power automates not doing it supports a lot that the business user needs to do but from the admin side of things you know there's still some gaps and so I think you know that's why this is extra cool yeah for sure for sure and it's something that once you once you figure out how to build the small calls and how you how to actually get some items in there then you can start to build those and say okay well what do I actually need to do is something that that I just can build on top of so so it really does provide you with a lot of extra support now when you're doing these things like if you're working with document sets if you're working with permissions inside of SharePoint and you're gonna use that HTTP request there's a lot of documentation out there that's actually not related to power automate so we can provide a couple of links to those things as well and it might feel a little Devi but it's pretty easy to get started with and so the next time that we talk about this I'm gonna show how to do a post how to do a patch and how to do a delete so when you do those things there's some extra gotchas in there there's some information you've got to put into the body of the request and we'll go over all of that in the next video awesome okay so part one is here part 2 coming up soon Ashley thank you again for coming and joining and given a nice quick intro to getting started with HTTP here in SharePoint I actually I've never touched this myself so it was my introduction to this connector as well all right well it's my pleasure and I can't wait to show you guys the rest of it awesome all right so guys be sure to check the links in the description there's gonna be Ashley is Twitter in there and her blog will have some helpful links some documentation about the HTTP connector here and some things you need to know to get started although than that you guys know what to do click like click subscribe much love from me see you in the next one hi guys [Music]
Info
Channel: Jon Levesque
Views: 15,810
Rating: undefined out of 5
Keywords: jon levesque, jon levesque microsoft, microsoft flow, #flowhacks, flow, http, send an http request to sharepoint, http requests, sharepoint, sharepoint online, create list with http, create column with http, add folder with http, add task list with http, hyperlink display text, hyperlink column, sharepoint http connector, sharepoint http, http sharepoint, http microsoft flow, http power automate, power automate, microsoft power automate
Id: aCiImh9NMiY
Channel Id: undefined
Length: 16min 17sec (977 seconds)
Published: Tue Feb 18 2020
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.