cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Excel (Business) "Access Token is Empty"

Excel is not letting me add a row to a table. This was working just fine last week, now it seems I don't have authorization. I am logged in to Flow, Excel, and Powerapps. I have edit permissions to the Excel file. I included a screenshot of the error details below. Thanks for your help!

 

 

ExcelFlow.PNG

32 REPLIES 32
Community Support Team
Community Support Team

Re: Excel (Business) "Access Token is Empty"

Hi @Anonymous,

 

Thanks for feedback. I can reproduce this issue on my side with the same error message.

 

I will help report this issue on my side and back to you once I got any updates.

 

 

Best regards,

Mabel Mao

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.
Mline07
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

I have exactly the same error. 

 

I check my connexion to Excel Business online and it's connect, also I have some other flow that work the same with à different excel but in the same file ans theys work fine every days so I really don't understand what goes wrong  just now on with this one... 

 

I hope you're update for this error will be soon... 

beach_fossil
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

I'm also running into this issue. Crossing my fingers that it can be fixed very soon Smiley Happy

Infojic-BCN
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hello,

 

I'm having this problem as well since Wednesday. @v-yamao-msft I'm contacting both Microsoft General Support and Flow's Team Support to track and solve this problem.

 

I'll try to post updates, @Anonymous, @beach_fossil and @Mline07, from whatever information I can get from the Support Team but this will be on Monday. I'm sure they won't contact me by this time.

 

This flow allowed the workers to do a task around 3 / 4 times faster so it's a huge issue for me.

 

I hope its not your case.

 

Regards,

 

Alex Torregrosa Romero

KeithNJ
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Also having the same issue.

 

Start time
Aug 10, 2:06 PM (2 min ago)
Duration
00:00:08
Status
Failed
Error
Action 'Add a row into a table 2' failed
Error Details
Access token is empty. clientRequestId: 
LevoHealth
Level: Power Up

Re: Excel (Business) "Access Token is Empty"

I am having this same issue. I started trying to use zapier but zapier gave me an error so i thought i would try out ms flow but no luck here either...it works in google sheets....

LevoHealth
Level: Power Up

Re: Excel (Business) "Access Token is Empty"

Actually, for me, it looks like running on an excel in the root folder of my onedrive was an issue moving it to my documents folder fixed the issue

Infojic-BCN
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hello @LevoHealth,

 

My issue is with SharePoint Online and not with OneDrive, so this isn't my case.

 

I'll try to workaround this problem but, from MS Flow Team Support, said that they could not find the problem so they were contacting with product team to look into the issue.

 

I can tell thought that the problem seems like the system is not able to retrieve the token and so executing API REST functions it says "Access token is empty" and so you're not allowed to execute anything.

 

Well, time will tell us, I hope sooner rather than later.

 

Regards,

Alex Torregrosa

Infojic-BCN
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hello!

 

Next is part of an email from MS Flow Team:

 

I am communicating with product team on this issue.

As per the team update, API hubs connection status says "Connected" so it seems like an issue with the excel connector in validating the token and we are working to get it fixed. 

Will keep you post on update.

They got the bug tracked at least, I hope they can solve it today.

 

Good luck!

 

Regards,

Alex Torregrosa




Infojic-BCN
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hello there!

 

I've got the issue fixed ( yey! Smiley Very Happy) but I'm still waiting with Flow's Support Team to get an update from Product's Team.

 

Please, @Anonymous, @Mline07@beach_fossil and @KeithNJ, can you confirm to me that you got the issue fixed as well?

 

@v-yamao-msft, we've got nothing from you since Tuesday, are you ok?

 

That's all from me.

 

Best whishes,

Alex Torregrosa

x-spd-gallego
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hey Alex,

 

 I still get the "Access token is empty" message whenever I try to add a new row into Excel Online.

 

Did you do something on your Flow?

 

Regards,

Nelson

Infojic-BCN
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hello @x-spd-gallego,

 

It failed for me as well, but:

 

As the problem was related with "Estabish connection" and "Check if user is valid" topics, you should give a try on deleting the connection and creating it again.

 

For that, just go to Flow's website and do the following:

 

Settings (Gear icon) > Connections > (email address) Excel Online (Business) > "..." > Remove / Delete

 

Then go to the specific flow and you should be able to see the Excel Online (Business) with an alert, it will ask you to create a new connection for fixing the issue:

 

image.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(Sorry for the Spanish text), just click on "+ Add new connection" to recreate the connection.

 

Even though, as I said before, I didn't received any email back about the fix, so it might be temporary.

 

Please let me know if it doesn't work, so I can push the issue again to the Flow's Support Team.

 

Regards,

Alex Torregrosa

KeithNJ
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

I have tried this a few times and still get the same 'unauthorized' message.  

Infojic-BCN
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hi there @KeithNJ!

 

I'm sorry to hear that, I'll message them inmediatly.

 

I've asked feedback from Product Team (which I'm communicating through Flow's Support Team) and see what they tell me.

 

I'll post as soon as I get any information, or on Thrusday if they don't answer me back.

 

Regards,

Alex Torregrosa

x-spd-gallego
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hi Alex,

 

 Thanks for your response.

 

 I've done it step-by-step and still got the error:

 

 Capturar.PNG

 

 

Regards,

Nelson

x-spd-gallego
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Hello everyone,

 

 just a heads up: things are working for me now. Haven't done anything, so it seems the Microsoft Team got it fixed.

 

Regards,

Nelson

npnigro
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Any update on this? One flow broke for me and I removed/re-added the Excel connection and now none of my flows are working that rely on that connection. Any other ideas for a workaround or timing for a proper fix from Microsoft? 

brianhull
Level: Power Up

Re: Excel (Business) "Access Token is Empty"

This worked for me. 

Just kept messing with the flow and selecting alternate connection for the Excel (Online) and it eventually prompted me right inside the flow.

Error I was getting.

Access token is empty. clientRequestId: fc9fddc2-2131-4d8c-a025-1f7a37523304

 

Thanks!

npnigro
Level: Powered On

Re: Excel (Business) "Access Token is Empty"

Update from me: I'm now only getting the error if I manully run the flows now (e.g., resubmit a previous flow). Flows that run automatically seem to be ok with the Excel Online connection. I have a ticket open with Microsoft and will follow-up with what I learn. 

Helpful resources

Announcements
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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,624)