Working with SharePoint List using SharePoint Send HTTP Request action in Power Automate

[@fletchergrimlock6885]

Clavin, you've saved my sanity! I couldn't for the life of me get my columns to show and was going mad. Thank you!

[@beyourbestselfeveryday391]

Learning made simple. Thanks, this really helped to identify the syntax elements, where to get them, how to use them and how to test end points.

[@alvaromachucabrena97]

You're amazing! Thank you so much!

[@alexbenedicto5255]

This is one bloody good tutorial! Thanks heaps!!

[@conaxlearn8566]

Great tutorial. It would also be good if you can show how to add a list item into a folder, and have the HTTP request return the Id (and other metadata) of the newly created item.

[@zerokhan858]

thank you so much clavin!!!

[@TestChannel-em3ol]

Great sir , thanks for this video

[@PabloMoricz]

dude, this is an EXCELLENT video! I'll suscribe now, thanks for the info!

[@clavinfernandes8566]

Thank you for the kind words...

[@venkatakishore7907]

Hey Clavan, First of all. Thanks for posting such an amazing video. I was trying to accomplish something and spent hours before I came across your video. And this video helped me to solve it. Thanks heaps and keep doing more videos. 👏🏻 ❤

[@user-fx6bk3tv4r]

fantastic tutorial, thank you!!

[@joysonyogarajah4471]

Hi Your session was great , Could you do a video to create list items with version history (full) in another list .

[@AbhilashSwain]

Thanks Clavin. Could you please help in a demo adding value to all type of columns.

[@jjactual9321]

this is amazing! thanks for sharing. Do you have a video (or can you please refer me to one) where we can POST multiple items?

[@sheeferzyed8957]

Excellent Tutorial, Thank You. Using send to Http, is it possible to update a value/property of a selected document in SharePoint library without changing version of the document. It would be grateful if you have videos for the same...

[@zerokhan858]

I do have a question though: what's the documentation that you used? it's the one in the description?

[@jaxonvvv]

Great!

[@lautarob]

Thanks, excellent video. Whenever you can, please make one for a stand alone sharepoint site (I meant, one that has its own domain, unrelated to microsoft or sharepoint domain).

[@clavinfernandes8566]

Great suggestion!

[@clavinfernandes8566]

I have created a couple videos - In this tutorial, we will learn how to Invoke a REST API with Power Automate - kzbin.info/www/bejne/bILHnHSFoL-MhKM and Invoke REST API from Power Apps - Power Apps Pen Input to PDF (Signature) - kzbin.info/www/bejne/jnWViWymiraBndE Related blog - clavinfernandes.wordpress.com/2021/10/25/invoke-rest-api-from-power-automate-and-powerapps/

[@khasimshaik2606]

Really thanks

[@Julio-i2i]

Great tutorial. and for updating ?

[@MoanaRasst]

I ask you to help in a question of work with Sharepoint. Documents have been saved to the desktop through synchronization. If you accidentally delete a large number of documents and return them using the button, how does this operation appear in the system? Can it show in the system that the documents were allegedly resent somewhere, instead of being deleted? Is it possible to resend documents at once directly from Sharepont or do I need to download them first? Moreover, the computer and all programs are protected and only the administrator has full access.

[@christylislyesther1688]

Clavin , i need to move all the site contents from sharepoint site to Azure Blob through Power Automate

[@clavinfernandes8566]

It should be possible using azure connector in power automate.

[@danishibadat6886]

Hello, You never mentioned where to get the header values from??

[@kmuralikrishna1582]

Thank you ... Did you get any chance to work on list/document library permission...? Example: Check document library has unique permission or not Update list/document library permission Etc....

[@clavinfernandes8566]

There are a few tutorials in the pipeline. Related to SharePoint HTTP, I will your request to the list :-)

[@kritikaperry7124]

Hello Its a great video it taught me to create the list but now how to get information to it. Is there a way to do this and have selective information be transferred from excel or another list - I followed your steps but now stuck in transferring specific project information to the list which we create- Example is List "Target" gets filled for upper management but now the list which we created for people on site for different projects - they only seek their project information nothing else on their list. Could you share insight on how to do that. Thanks in advance.

[@clebersonfelipe119]

Hello everything is fine? I can create a list using an existing list in sharepoint using automate?

[@frederickching1142]

Do you have a tutorial for Method: Get? I need to know how to perform action 'Get changes..' through HTTP request. Because the sharepoint site is On Prem. Thank you very much

[@imsourabhprasad]

Hi Clavin, I have to extract the "Page Content" of a sharepoint Page, how to achieve this using Send HTTP Request using GET. List contains the "Page Content" column but not allowing to get the content to read using powerautomate. I am talking about the default Page Content of the Page, where we enter some data to show into the page.

[@clavinfernandes8566]

Hey Sourabh, I did a quick Google search and found ( www.sharepointcass.com/2020/07/16/extracting-sharepoint-online-page-content-and-embedding-the-html-in-an-email/ ) - I have not tried the SharePoint REST endpoint yet.

[@sumanthd9319]

Hi, Can you please let me know how to add a filter using date column using Send an Http Request to get the items. Example: Get the items from past 14 days.

[@azuraabdullah3765]

Hi, how to update the SP using send http? This is to avoid infinite loop. I start with 'when item is created ...' and would like to update the item in SP. Please advise

[@tusharmehtadxb]

Nice 👍, To perform action, do we need Microsoft premium connector licenses or it will work without it ?

[@clavinfernandes8566]

The SharePoint HTTP action is not a premium action.

[@rachelriggin2129]

Hi Clavin, can you tell me whether it's possible to create multiple SharePoint columns with a single HTTP action? I can't find any examples of this and when I try it, Flow fails with this message: "Invalid JSON. More than one value was found at the root of the JSON content. JSON content can only have one value at the root level, which is an array, an object or a primitive value." I don't know if this is impossible or if I just have some error in my syntax. Flow allows me to save, so for what it's worth, it's not complaining about the JSON until it runs.

[@MovingOutMyMoms]

Great question Rachel, i'm working on this as well. Calvin the genius you are, is there a way to add multiple columns in a single HTTP action?

[@davidadams421]

Clavin, I am trying to add a comment but it keeps being deleted. Are they ending up 'for approval'?

[@clavinfernandes8566]

You can reach out to me at [e-mail]

[@davidadams421]

@@clavinfernandes8566 Done.

[@mrwhammer]

Will this work if i use adps api? I wanted to send an http request to adp to be able to link it together

[@kkb92-96x]

How do you upload a document this way?

[@wrm8460]

is there a way to use HTTP to get all list column names?

[@angelakaramitreska2686]

Hello, after I test the Sharepoint HTTP Demo 1 Create List, the Send an HTTP request to SharePoint is running too longc an someone help me and tell me how can I fix that?

[@manjeetsinghutube]

Nice

[@faycalarnaudkeita4617]

Very good tutorials, I tried to reproduce what you did but it does not work as I will certainly because of my flow say which is different from for you since for me you have to put a pdf file in a document library so that the flow first extracts the information inside then move the file to another document library and finally change the PDF name . That's where I'm stuck.

[@no.more.official]

thanks

[@christinahepzy]

👌👌👌

[@hussen3949]

lperfect

[@yaminikosarkar887]

I need to add data in lookup column using power automate api , how can I add?