Skip to main content

Notifications

Community site session details
Power Automate - Using Connectors
Answered

Excel connector can´t find table

Like (0) ShareShare
ReportReport
Posted on 23 May 2021 12:28:20 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, 

 

 

 

  • QuinceK Profile Picture
    37 on 30 May 2021 at 20:59:39
    Re: Excel connector can´t find table

    Hi!

     

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

     

    All the best,

    Quince

  • powercorner Profile Picture
    477 on 23 May 2021 at 17:45:48
    Re: Excel connector can´t find table

    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

  • Verified answer
    Pstork1 Profile Picture
    66,535 Most Valuable Professional on 23 May 2021 at 12:52:51
    Re: Excel connector can´t find table

    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.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Using Connectors

#1
DBO_DV Profile Picture

DBO_DV 25 Super User 2025 Season 1

#2
CU09051456-0 Profile Picture

CU09051456-0 22

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 21 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started
Loading started