How to fix 'Unknown Error' when I try to connect to the Excel Online (Business) connector in Logic Apps?

Question

When I try to add an action from the Excel Online (Business) in a Consumption Logic App, I get 'Unknown Error' after signing in using my Microsoft account. I've tried in other browsers and in private mode, same for all. And same with the SharePoint connector and Word Online connector. I've seen on another post that it might be a permissions issue, but what permissions would I need? I have Contributor on that Resource Group and I don't have this issue with any other connectors. Also I can add that connector in Power Automate no issues.

Answer 1

@Alex Feuchtwanger

Thanks for the update! Glad to see you were able to resolve your issue. Thanks for posting your solution so that others experiencing the same thing can easily reference this.

Since the Microsoft Q&A community has a policy that the question author cannot accept their own answer, they can only accept answers by others, I'll repost your solution in case you'd like to Accept the answer.

Issue: The Excel Online (Business) connector in Logic Apps showed an "Unknown Error" when trying to sign in.

Resolution: The issue was related to the authentication pop-up. Logging out first and then logging back in within the same pop-up window resolved the issue.

Quick Fix:

Allow pop-ups in your browser – The connector uses OAuth 2.0 authentication, which requires a pop-up for login. If blocked, authentication may fail.

When the sign-in pop-up appears, log out first instead of continuing with the existing session.

Log back in within the same pop-up to refresh the authentication and establish the connection.

This fix can also help with similar issues in SharePoint and Word Online connectors.

Please do not forget to click "Accept the answer” and Yes Hope this helps others facing similar issues!