Error with Excel connector

[greenfire]

I create a flow and i have 2 issues:

1.  When add Excel connector: after choose location, i couldn't choose document library and display error message

401 unauthorized

2. I delete environment using at error 1, and create new environment, i step by step add Excel Connector and display below message. 

[fchopo]

Hello @greenfire 

Do you have read permissions on the document library where the excel file is stored?

Could you provide more detailed information? (trigger and idea of the flow)?

Ferran

[greenfire]

hi @fchopo 

my Excel file store in my onedrive or my sharepoint folder, so i have all permission.

I want to read all rows of excel file and add to sharepoint list.

With my onedrive business:

With my sharepoint folder:

[fchopo]

Hello @greenfire 

Could you try to review or recreate the connection to Excel? Have a look at this thread: https://powerusers.microsoft.com/t5/General-Power-Automate/add-a-line-to-excel-status-401-unauthoriz...

Hope it helps!
Ferran

[v-litu-msft · Accepted solution]

Hi @greenfire,

You could try these methods to solve your problem:

1. Log out the Power Automate account and log in back;

2. Create a new Excel connection in the Connection center;

3. Clear cache of the browser;

4. Using other browsers to open the Power Automate, such as Chrome, Microsoft Edge (Chromium).

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.