SharePoint Online- Update SharePoint document Library Metadata using Rest API and Power Automate

hi all welcome to my another video in this video we will see how we can update document metadata so this is our employee site here we have a document library ratio so here you can see we have one file here also we have some other column like country and detail so today our plan is like we are going to update the country using power automate and rest api so let us see how we can do so just go to your flow create a new flow so here we are creating an instant cloud flow so mallet triggering flow and our flow name will be documents on publish so let me create so now here we have to add another action like here we are going to post a request to sharepoint so for that we have to use an action like send an http request so let me add that step so if you search here send that http so whenever you are working with restb and sharepoint you have to choose the action like send an http request to sharepoint so just click here here we have to select ourselves employee site so here you can see in our case our site is employed so just select that site then request is supposed because now we selected the site now the method is post because we are adding the data so for that we have to use like post so now here we have to pass the url so we have to pass the resume plus tb url so that is type so here you can see our url api web list get by title and the document library name and the item which we are going to update so if we change here resume folder here you can see our item id for the john file is three so we have to update this file so let me add the item as three so in your case if you are doing dynamically you have to pass this data dynamically okay so now we have to pass the head up so let me add qt and i will show you what are the headers here you can see we have added the header like accent content type the next http method is patch and if match now we have to pass the body so here we have to pass the type and the column which we are going to update so let me just keep a and that also so here we have added the metadata and the type so here type is our document library name here sp dot data dot your document library name then we have to add the item so that is how we can create the type so after that you have to pass your field name so here you can see our field is country so we have to pass the country so the parameter what i will do like i will pass dynamically so what we can do like we have add one trigger here so let me add country here so here we have added the country so now we will pass this country in the country body so let me just add qt here so here you can see the country which is passing from the manually triggering flow so let us may add that so that we have added so now let us test the flow in this one so here you can see now the country is empty so we'll check so let me test the flow manually will trigger the flow here we will pass like usa so this let me run the flow done so our flow successfully run so if you check here you can see the data we pass like the metadata and the country name so if you go to your resume folder here you can see countries updated so like this way you can pass all the parameter

Channel: Sharepoint World

Views: 9,120

Keywords: sharepointonline, restapi, powerautomate, microsoft365

Id: uyaco5MI9e4

Length: 4min 32sec (272 seconds)

Published: Wed Apr 13 2022