Power Platform Community Forum Thread Details

Hello everyone,

I am trying to create a connection to Excel Business Online connector using the "Create Connection" action in Power Automate.

Here's my setup :

I have an app registration in Azure that has the following API permissions :

- user_impersonation

- User.Read

I generated my token as follows using the tenant_id,client_id and client_secret associated with my app registration

curl -X POST https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token \bf56}/oauth2/v2.0/token \
-H "Content-Type: application/x-www-form-urlencoded" \
-d "client_id={client_id}" \
-d "scope=https://graph.microsoft.com/.default" \
-d "client_secret=secret" \
-d "grant_type=client_credentials"

While the Power Automate action does not fail and creates the connection, it remains unconnected, Here's the ouptut trace showing that something went off with bearer token authentication :

{

"status": "Error",

"target": "Token",

"error": {

"code": "Unauthenticated",

"message": "This connection is not authenticated."

}

Any idea on how to fix this and possibly efficiently test this?

Categories:

Building flows