Skip to main content

How to use SharePoint REST APIs with Power Automate

Hi everyone! In this post I would like to chat a little about using Power Automate to evoke the very useful and powerful SharePoint REST API. Let’s get started!

What is Power Automate?

Power Automate is the online workflow service included in the Power Platform suite of services that allows users to automate actions across over 500 apps and services in the cloud, via the Representational State Transfer (REST) service, or on-premise, via an on-premises gateway. SharePoint Online is an example of a service that uses REST. For more information about Power Automate, click here

The SharePoint REST API service

SharePoint Online uses REST Application Programming Interfaces (REST APIs) to allow professional and citizen developers to perform Create, Read, Update, and Delete (CRUD) operations on SharePoint data. Power Automate uses HTTP requests to leverage the SharePoint REST API.

The following table provides an overview of some of the HTTP REST requests.

An HTTP REST request also includes a REST URL comprising an appropriate entry point, specific resources, and parameters for endpoints that correspond to methods in the client object model.

In the following example, the entry point is the SharePoint site URL with the ‘_api’ postfix that identifies the communication channel. The resource in this example is a list and the method is ‘getbytitle’ which as the name implies gets the list with the name parameter enclosed in the parentheses, ‘TestList’, in this example.

For more details on the SharePoint REST service, you can check this out

How to perform CRUD operations in SharePoint using REST APIs from Power Automate

Firstly, Power Automate has a ‘Send an HTTP request to SharePoint’ action, supporting various HTTP request types as shown below. In this blog however, we will focus on using it to add an item to a List using the ‘POST’ method.

Let’s take a closer look at this action. In the screenshot below, the ‘Site Address’ is a mandatory field that contains the address of the SharePoint site which contains the resource you would like to edit. In this case, the site is called ‘Power Automate Test Site’

The POST ‘Method’ communicates to the SP site it would like to create a resource, a list in this instance.

The Uniform Resource Locator or ‘Uri’ specifies the list that needs to be updated. In this example, it is the SP list called ‘HTTP’.

The ‘Body’ contains the metadata that will be added to the List, in this example, it will be the value ‘Test’ in the Title column.

The result will look like the screenshot below.

There you have it!! That’s all you need to add an item to a SharePoint List using the REST API. The approach would be similar for the other request types. However, if you would like to learn more about using the SharePoint REST APIs with Power Automate you can click here!

Let us build something amazing together
Connect with us.

With over 20 years of experience working with Microsoft Technologies, Imaginet can help you choose the right Microsoft 365 solution to adopt an effective hybrid workplace model and improve employee engagement. Contact us to get your free virtual consultation.

Let's Talk

Like what you read?

Check out our recent articles.

September 22, 2022 in Productivity, SharePoint

Using Entitlement Management to Provide External Access to SharePoint Online

Azure Active Directory (Azure AD) entitlement management is an identity governance feature that enables organizations to manage identity and access lifecycle at scale, by automating access request workflows, access assignments, reviews, and expiration.
Read More
September 13, 2022 in All Posts, Productivity, SharePoint

Implementing External Email Tagging in Outlook

In this blog, let's discuss implementing an 'external' tag identifier on your business email. This feature implements an "External" tag identifier on Outlook for email messages received from outside your organization. Microsoft created this feature in hopes that the external tag will help users easily identify spam and phishing threats from external senders. When someone outside your organization receives an email, an "External" title will be present in Outlook on the web, Outlook for Mac,…
Read More
September 6, 2022 in All Posts, Productivity, SharePoint

How to use SharePoint REST APIs with Power Automate

Hi everyone! In this post, I would like to chat a little about using Power Automate to evoke the very useful and powerful SharePoint REST API. Let’s get started!
Read More
August 23, 2022 in All Posts, Application Development, Productivity

Your Estimates Are Wrong (… and What to Do About It)!

Estimates are always wrong. It is the sad reality of our industry. And they can be wrong for many reasons. From missing or poorly defined business requirements to false assumptions, from lack of technical expertise to overestimation of development team capabilities, there are a myriad of issues that can arise during a project that can cause even the most carefully constructed estimate to end up wildly off the mark. 
Read More
Stephan Alexander

I’ve held various roles in technology over the last 21 years. In my first job after completing my degree in computer science, I developed business applications (using Visual Fox Pro 6!!!) and maintained the local area network as well as the telecom infrastructure of a manufacturing company in the US. Quite an accomplishment for someone who four years prior never used the Internet or owned an email address. Three (3) years later I returned to Trinidad to lead the technology department of a well-known vocational training state agency. While there I played a critical role in navigating many projects towards their digital transformation with the introduction of online application and registration, blended (and fully online) learning, a student management system, and a human resource information system among others. The company's newly developed online productive capacity, and the blended learning in particular were critical in buoying operations a few years later during nationwide lockdowns due to the Covid 19 pandemic (2020-2021). These projects had such a positive impact on the nation that the organization was named a national finalist in The President's Award in Innovation and Service Excellence in the Public Sector in 2021 and winning the People's Choice Award in the same category. After 15 years as an IT Team leader and Manager, my professional journey came full circle when I re-entered the custom business application development arena as a consultant for an award winning Microsoft partner. During my two year stint there I assisted various companies achieve their strategic objectives, reducing costs and increasing productivity, winning the business consultant of the year (2021) as an individual and the Trinidad and Tobago Microsoft Partner of the year (2021) as a member of the team in the process. Currently, I am a Microsoft Collaboration Consultant in Winnipeg, Manitoba CA, where I reside with my lovely wife and wonderful twin boys.

Let‘s Talk.

Let's talk!