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

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 


Maintain SharePoint Lists using flow

List Items

Maintain SharePoint List Items using Flow


Create a folder in a document library


No posts yet, coming soon


Common Error Messages

Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using

View Comments

Recent Posts

Calculate the Sum for a SharePoint column in Power Automate

Last week Shane Young asked me about calculating the Sum for a SharePoint column in…

2 days ago

Object must implement IConvertible in Power Apps

In Power Apps when you do a Patch to create a new item or to…

6 days ago

Get started with adaptive cards in Power Automate

Getting started with adaptive cards can be difficult. In this post i have written some…

2 weeks ago

Create PDF documents from data in Power Automate

In this post I will look at how to create PDF documents from data. Use…

2 weeks ago

Unnest nested arrays in Power Automate

We all know this problem, you have a nested array in Power Automate but how…

3 weeks ago

Advanced settings not loading in Power Platform

Yesterday one of my clients showed me an issues where the Advanced settings didn't load.…

4 weeks ago