cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joejoo
Frequent Visitor

Excel Online (Business) - This connection is not authenticated.

When I first added the connection in a flow, I was given a choice to allow all users in our organization to use it(or something similar), so I just chose that. Then I had an error telling me something like it was not possible to give those permissions. And, it failed. So,I removed the flow, I deleted all excel connections, created a new, and now I am stuck. Getting nowhere...

- Note that I dont remember exactly what the choice/error wording was when i firts created the connection, but as I recall it was something like I describe above...

 

All attempts to create a new connection/or sign in to authenticate/update password for a newly created connection just brings me to sign in with the work/school account, and then the sign in process completes with no other choices/error messages... I suspect this first erroneous choice is the problem, but where/how do I correct this?

 

The flow run (excel action) gives the following error:

 

{
"status": 403,
"message": "The request is forbidden by Graph API.\r\nclientRequestId: 60015387-6621-4110-802f-XXXXXXXX",
"source": "excelonline-ne.azconn-ne.p.azurewebsites.net"
}

 

I am a Global administrator with the Full administraion security role in our O365 E3 tenant.

 

If anyone could help, it would be much appreciated. Se pictures below. Thanks again!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
joejoo
Frequent Visitor

Solved, it was some problem with the excel file. Simple. Sorry, I forgot to update this post.

View solution in original post

5 REPLIES 5
v-yamao-msft
Community Support
Community Support

Hi @joejoo ,

 

What’s your current situation?

 

When testing this issue on my side, the Excel Online actions are working properly, no error message occurs.

 

If the issue still exists, please help collect the following info.

  • Location
  • An image of the flow
  • A URL to the flow

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Well, now the connection looks ok (connected/authenticated), but the problem with the flow is the same... I deleted my flow and connection, then deleted my user from excel online in Azure enterprise applications page. Then Created a new connection which seems ok now - connected. But the test flow with excel business connector and excel get worksheets action still fails. 

Tenant location europe

 

Error message as below...
"status": 403,
"message": "The request is forbidden by Graph API.\r\nclientRequestId: 51269c12-ffc0-41b0-8896-XXXXXXX",
"source": "excelonline-ne.azconn-ne.p.azurewebsites.net"
}

 

excel_connector.jpg

Well, now the connection looks ok (connected/authenticated). I deleted my flow and connection, then deleted my user from excel online in Azure enterprise applications page. Created a new connection and a test flow with excel business connector and excel get worksheets action. Error message as below...

Tenant location europe

url: https://emea.flow.microsoft.com/manage/environments/Default-e5f65f48-442c-4096-8e0e-72c8e1b2c393/flo...

"status": 403,
"message": "The request is forbidden by Graph API.\r\nclientRequestId: 51269c12-ffc0-41b0-8896-7d65e6c02ffa",
"source": "excelonline-ne.azconn-ne.p.azurewebsites.net"
}

excel_connector.jpg

Hi @joejoo ,

 

Thanks for updating.

I have reported this issue, I will back to you once I got any updates.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
joejoo
Frequent Visitor

Solved, it was some problem with the excel file. Simple. Sorry, I forgot to update this post.

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (3,244)