cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JulieTE
Level: Powered On

add a line to excel - status 401 unauthorized

Hello, 

 

I have a flow that works very well but for one person it failed and I am not sure why.

It looks like an access error, but I don't know who was connected on the flow so I can't check the permission to the file. Is this information available somewhere (clientrequestid maybe ) ?

Is it possible that the problem comes from elsewhere ?

Thanks,

 

Julie

 

{
"status": 401,
"message": "Access token validation failure.\r\nclientRequestId: cbd1204d-b426-47a9-b8ad-211149c247d1",
"source": "excelonline-wus.azconn-wus.p.azurewebsites.net"
}

401.PNG4012.PNG

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: add a line to excel - status 401 unauthorized

Hi @JulieTE ,

 

Please check if the connection account currently configured for this action has the corresponding permissions.

You could try to update or create a new connection.15.PNG

 

In addition, you could try to replace the trigger with a Button, click Test to run Flow, and click Edit connection to see the details of the action configuration when Flow is running.

If it is not expected, please switch to the expected connection:16.PNG

 

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JulieTE
Level: Powered On

Re: add a line to excel - status 401 unauthorized

Hi Barry,

As I mentioned my flow works fine for any other case, I actually resent it and it worked (with the account currently configured which is mine). Also, other users had it triggered with no issue since.

I would just like to understand why this one time didn't work because I don't want it to reproduce.

Is it linked to the user who triggered it or it is an isolated bug ?

 

Helpful resources

Announcements
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
Users Online
Currently online: 388 members 6,807 guests
Please welcome our newest community members: