“Token type is not allowed” Error when Invoking SharePoint REST API

Recently I blogged on how to "Invoke SharePoint REST API from Power Automate Desktop", in the blog we are granting Power Automate Desktop Application access using SharePoint App-Only Authentication. All worked well for me, however one of my subscribers complained that they are getting the error below - {"error":"invalid_request","error_description":"Token type is not allowed."} As a … Continue reading “Token type is not allowed” Error when Invoking SharePoint REST API

Invoke SharePoint REST API using Power Automate Desktop

This blog is a continuation of a previous blog post , in which we used the SharePoint client object model (CSOM) to get SharePoint List items. In this blog, we will learn how we can "Invoke SharePoint Online REST APIs" using Power Automate Desktop. The blog is majorly divided into two parts: Granting access using … Continue reading Invoke SharePoint REST API using Power Automate Desktop

Select SharePoint Files and Merge Them into a Single PDF Using Power Automate

Due to the ongoing COVID situation, teachers have been using Teams and SharePoint to deliver trainings Online. In the SharePoint Site, the Teacher creates a Folders with the library with unique permissions such that Student A cannot access the Folder\Files of Student B. Student usually send their assignments as attachments to their respective teachers in email attachment. The teachers find it difficult to manage the individual attachments.

Get Rows(Parse) from CSV file using Power Automate and bulk generate documents

This is my solution to an Idea(Text (CSV) file - Get rows) requested by Power Automate community which have 500+ upvotes. In this article, I will demonstrate how to get the CSV files Content in Power Automate, Parse the CSV using a little bit of 'TypeScript magic' using the 'Excel Run Script action' (yes you read it right - we are going to invoke code without a third party action in Power Automate) and we will then use result from the 'Run script' action and bulk generate documents.

Working with SharePoint List using SharePoint Send HTTP Request action in Power Automate

The SharePoint Connector in Power Automate provides many actions with which you can create items, get items, delete items etc. But some scenarios the out of box actions do not handle your requirements (You cannot create a SharePoint List etc.), or the action you are looking for is not yet available in the SharePoint connector. In Power Automate, the SharePoint Send HTTP Request action lets you construct and execute SharePoint REST API queries and help you handle scenarios the out of box actions do not handle your requirements.