cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Frequent Visitor

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

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
Highlighted
Community Support
Community Support

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

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.
Highlighted
Frequent Visitor

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

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

Highlighted
Frequent Visitor

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

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

Highlighted
Community Support
Community Support

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

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.
Highlighted
Frequent Visitor

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

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
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (5,562)