Using the excel business action in power automate throws a 401 error. But no error message

[escroc]

I'm using Power Automate to control Excel business behavior.

For a while, it worked fine.

However, since a week ago, I've been getting an unexplained 401 error.
It is not happening with all Excel Business actions, but only with the actions that control rows.

The error message is as follows

{

  "status": 401,

  "message": "clientRequestId: (Client Request Id Code...)\r\nserviceRequestId: (Service Request Id Code...)",

  "error": {

    "message": ""

  },

  "source": "excelonline-~~~

}

1. is anyone else experiencing the same symptoms as me?
2. what region are you in?
3. when did this start happening?
4. have you found a workaround?

[Nived_Nambiar]

Hi @escroc 

Just to confirm- does the excel file path in that action is correct ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[escroc]

Yes, that's correct.

The excel is stored on OneDrive, path, permissions, everything is correct.

If it were a path issue, all actions would be failing, not just the Row action in Excel Business, but only the Row action is failing.

[Nived_Nambiar]

Hi @escroc 

Try and see whether re-creating connection helps ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[escroc]

I also tried completely removing and recreating the Excel connection, but that didn't work.

I also tried removing and recreating the OneDrive connection, but that didn't work either.

[Nived_Nambiar]

Hi @escroc 

May be try re-add action again and see whether that helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[escroc]

Thank you for your continued help.

I've tried deleting the action, adding a new action, and even creating a completely new flow, but I'm still having the same issue.

[Nived_Nambiar]

@ManishSolanki  @abm 

- any thoughts on this issue ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[abm]

Hi @Nived_Nambiar 

What's the exact message along with that 401?

Thanks

[escroc]

Hi abm 

The error message is clientRequestId,
serviceRequestId. Sometimes only clientRequestId is returned as an error.

And the detail error message doesn't return any message as written above.