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

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
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.
joejoo
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

joejoo
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

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.
joejoo
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
Did you attend MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’ve streamed the digital event live, or you're watching on-demand, claim your attendee badge to sport on your profile.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (5,957)