User guide to using the SharePoint REST API in Power Automate for no-code developers

Often I recommend to use the send HTTP request to SharePoint action in Power Automate. A lot of Flow users however struggle with the SharePoint REST API.

SharePoint REST API

In this series of posts I will go through all the API calls available within the SharePoint REST API for SharePoint Online. For all the API calls available Flow examples are included, the examples are maybe not flow optimized as I wanted to makes it as easy as possible for non developers to understand how to setup these flows.

The SharePoint REST API offers operations for:

  • Sites ( Webs)
  • Lists
  • List Items
  • Folders
  • Files
An example SharePoint REST API call in Power Automate
User guide to using the SharePoint REST API in Power Automate for no-code developers 1

Additionally, the REST API also includes:

  • ODate query operations
  • SharePoint Data Structure
  • Item Synchronisation
  • Permissions
  • Batch requests

It would be impossible to write about all of these above in a single post. Therefore this post will serve as an index to many posts to come soon.

Sites ( Webs)

Get site details

Create a site 

Lists

Maintain SharePoint Lists using flow

List Items

Maintain SharePoint List Items using Flow

Folders

Create a folder in a document library

Files

No posts yet, coming soon

Troubleshooting

Common Error Messages


Discover more from SharePains

Subscribe to get the latest posts sent to your email.

Avatar of Pieter Veenstra

Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com

Related Posts

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from SharePains

Subscribe now to keep reading and get access to the full archive.

Continue reading