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.

February 3, 2023 in Office 365, Productivity

Understanding Organization-Wide Signatures and Disclaimers in M365

To create an organization-wide signature, you'll need to access the Exchange admin center in M365. From here, you can go to "Mail flow" > "Signatures." From the Signatures page, you can create a new signature and apply it to all employees in your organization. You can also edit existing signatures, as well as delete signatures that are no longer needed.
Read More
January 31, 2023 in Application Development, SQL Server

Using Query Store to Analyze Database Performance

Are you concerned about how your database is performing for your application? Did you know that there is a built-in feature in SQL Server and Azure SQL that you can use to evaluate your database for potential problems? Query Store has been available since the introduction of SQL Server 2016, and is enabled by default in Azure SQL and Azure SQL Managed Instances, but it has flown under the radar as a performance tool.
Read More
January 19, 2023 in Application Development

UX and Dev: A Perfect Partnership

There are many benefits of utilizing a UX designer’s expertise during a project, which include making it more efficient for the development team to implement the functionality. At a high level, a UX designer focuses on improving the interactions between a user and an application or website. In the past, these were often left up to us as developers...
Read More
January 9, 2023 in Agile, Application Development

Agile Project Management in Consulting

One of the key benefits of agile project management is that it allows for a more iterative and incremental approach to software development giving a faster Return on Investment (ROI) for the customer. Rather than trying to plan out every aspect of a project in advance, agile teams focus on delivering small, usable features of software on a regular basis. This allows the development team to be more responsive to changes in the project's requirements…
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!