web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel connector can´t ...
Power Automate
Answered

Excel connector can´t find table

(0) ShareShare
ReportReport
Posted on by 37

Hi! 

 

I am actually runnning into a problem I am not able to fix. 

 

I built a flow for a client to get data from an email and safe it to a shared excel (saved on onedrive business) called 'BTB'.

The excel connector can´t find any table. 

I already tried

 

- checking the format of the table (table is formated and named 'AKT_Table'). 

- deleting the connection and set it up again

- trying the Get Table connector which gives me back '[ ]'

 

The excel can´t be edit online ( it appears '403 forbidden' on the screen) and I thought about if this could be a problem. 

Is there anything I could try while searching for the failure? 

 

Thanks in advice, 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,415 Most Valuable Professional on at

    If you get a 403 forbidden when trying to access the file in excel online then its probably password secured.   The Excel connector can't access password secured files.  There is no workaround other than removing the security.

  • powercorner Profile Picture
    477 on at

    Hello @QuinceK ,

     

    as @Pstork1 mentioned it could be a password protection, but on the other hand are you sure that the user who is starting the flow has access to the Onedrive and the file? Is it shared with him? 

     

    The fact that you configured the connection with your admin account does not mean that the flow uses the connection. It is usually using the triggered users account. If you do not define it differently in the "Run as" option.

     

    Maybe you can share some screens, so that we could understand your problem a bit better?

     

    WIth regards

    Kevin

  • QuinceK Profile Picture
    37 on at

    Hi!

     

    Thanks for your help. It was the password issue. Now everything works fine. 

     

    All the best,

    Quince

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 815

#3
Haque Profile Picture

Haque 630

Last 30 days Overall leaderboard