Overview
Recently, I needed to query a SharePoint list and retrieve some data for my Power Automate Desktop (PAD) flow. While PAD offers some SharePoint actions, these are premium and may require a premium license. To address this, I combined a web service request from PAD with an HTTP connector in Power Automate. Note that the HTTP connector is a premium connector, so you may already have access if you have a per-app or premium license.
Features
- HTTP request from Power Automate Desktop
- HTTP connector accepts the request, retrieves the record from SharePoint, and responds with the data
- PAD receives the request and processes it
Using the Solution
- The .zip contains one Flow and one text file
- Copy the text file and paste it into Power Automate Desktop
- Import the .zip file into Power Automate
