cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QuinceK
Frequent Visitor

Excel connector can´t find table

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, 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

powercorner
Resolver III
Resolver III

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
Frequent Visitor

Hi!

 

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

 

All the best,

Quince

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,436)