Introduction

Thanks to a Power Automate custom connector linked to Powell Governance API, you are able to use any kind of scenario based on the endpoints available in the public API.

This new custom connector is the recommended way to integrate Powell Governance features into Power Automate. Unlike the old beta connector from the store, which is no longer supported and remains outdated despite our requests to Microsoft, this new connector offers more endpoints and use cases. It will also receive ongoing updates, unlike the previous version, which was static due to technical constraints.

Related ressources

• Powell Governance API documentation: https://docapiteams.powell-software.com/#api=public-powell-teams-api-beta
• Power Automate: https://make.powerautomate.com/
• Entra portal applications: https://entra.microsoft.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

Step by step

Step 1.1 - Create the Azure Application

Go to Entra: https://entra.microsoft.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

Click on « + New registration » to create a new application

Fill the needed information :

• Name of the app

• Who can access the app (by default selected on Single tenant)

• Don't define any redirect URL for now

Click on Register to create the app.

Step 1.2 - Define API permissions

Go to manage API permissions, and clicks on « + Add a permission »

In « Microsoft APIs » select « Microsoft Graph » and click on it.

On the new panel :

• Select « Delegated permissions »
• Add the following permissions
  • Directory.AccessAsUser.All
  • Group.ReadWrite.All
  • Notes.Read.All
  • Notes.ReadWrite.All
  • Sites.Read.All
  • User.Invite.All
  • User.Read
  • User.Read.All
• Click on « Add permissions »

Grant admin consent permissions by clicking on the following link

Consent the app by clicking on Yes on the alert message that appeared on the top:

Step 1.3 - Get the needed information

Application (client ID): On the Overview page, save the Application (client) Id

Client secret : On the Certificates and secrets page, click "New client secret"

• Define a name and an expiration period

Click on « Add to create the client secret »

On the client secret list, save the Value of the client secret

Step 2.1 - Import the Powell Governance connector in Power Automate

Go to Power automate: https://make.powerautomate.com/

Click on « Custom connectors » in the left menu. If the access is not visible in the menu, click on « Discover » and click on « Custom connectors »

Then on the top right, click on « +New custom connector » and « Import an OpenAPI file »

Import the Swagger file attached in this article (visible at the bottom of the page) in the pop-in displayed.
Click on "Import" and then on "continue".

Step 2.2 - Configure the custom connector in Power Automate

On the General tab :

• Select an icon
• Define a background color
• Don't change the other configuration preset thanks to the JSON file
• Go on Security tab

On the security tab :

• Set the Client id with your Application (client) ID saved before
• Set the Client secret with the Value of the client secret saved before (be careful you should use the value and not the Secret ID or your Client secret)
• Set the resource URL with the following value : https://graph.microsoft.com
• Let all the other information with their default values

Click on « Create connector »

Step 2.3 - Add the redirect URL on the Azure application

Once save, click on the new connector and copy the redirect URL

Come back on your Azure application on Entra

In the « Authentication » page, click on « Add platform »

In the modal opened, click on « Web »

Copy your redirect URL in the modal

Click on « Configure »

Step 3.1 - You can now use your connector in Power Automate!

When you create a new flow or edit an existing one, you have now the possibility to find all the endpoints of the Powell Governance API.

Add a new step in your flow

Select « Custom » in « Runtime »

Select the endpoint you want to use