Call SharePoint Rest API with Admin Consent from Power Automate

Dhruvin Shah
Dhruvin Shah
2 هزار بار بازدید - 4 سال پیش - During this session, we will
During this session, we will learn how we can call SharePoint Rest API with Admin Consent from Power Automate. We all know that Power Automate flow always runs based on User context when it is being triggered by Power Apps or Power Virtual Agents. Here, we have considered an example to find out the users from SharePoint Group using Power Automate. Here, we are calling SharePoint Rest API to find out the name of users from SharePoint Group. Now, Let’s say if there is any member user who is not a part of the SharePoint group then the REST API will throw an error. But I want to achieve that my API called based on the Client ID and Client Secret, not based on User’s credentials. So how can I achieve this? How can we call SharePoint Rest APIs based on Client ID and Client Secret? Let us check the answers!

Here, first, we will register our SharePoint App to generate Client Id and Client Secret. Then we will create a Power Automate flow. The flow will trigger an HTTP action that calls our SharePoint rest API based on client ID and Client Secret from Power Automate. So, this doesn’t require any connection.

We will check the start to end procedure throughout this entire session. So, stay tuned with me!

Chapters for this session:
00:00 Introduction
00:23 Business Requirements
01:04 Behavior of Flow Run from Power Apps
01:55 Difference – Call HTTP request with SharePoint Vs HTTP(Premium)
03:04 Register App in SharePoint for the Client ID and Client Secret
03:57 Generate Client Id and Client Secret for SharePoint Rest API
05:00 Open appinv.aspx Page
05:46 Register app
06:05 Provide Site Collection Level Access
07:34 Flow to create SharePoint Rest API with a Client ID and Client Secret
09:33 How to get tenant ID for my M365 Account?
09:57 Call SharePoint Rest API with Admin User
10:35 Generate Access Token
11:00 Create Body to Generate Access Token
12:23 Call to get users from SharePoint Group using Power Automate
13:50 How to Parse Complex JSON Structure?
14:05 Test Flow
16:10 Other Real-Life Examples
17:15 Subscribe

#PowerAutomate #MicrosoftFlow #SharePoint #RestAPI #PowerPlatform #PowerAddicts #MSFlow #Microsoft #DhruvinShah

Download Code Files:
https://github.com/Dhruvinshah16/Powe...

Bonus Item:
How to Parse Complex JSON Structure in Power Automate?
How to retrieve Value from Complex JS...
4 سال پیش در تاریخ 1399/09/25 منتشر شده است.
2,065 بـار بازدید شده
... بیشتر