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

Having issues connection to an excel file in sharepoint

I am having an api issue getting tables from my excel file which is stored on sharepoint. I am getting table data from another excel file in the same directory, so I know it's something to do with the file itself. There are tables in this document. I get an error that says "Could not retreive values. Error executing the api"

Any ideas?

 

1 ACCEPTED SOLUTION

Accepted Solutions
tcabel
Frequent Visitor

Yes I figured out the solution. I was using an excel document that had some features that were unsupported by excel online. Removing these features fixed this issue. 

View solution in original post

4 REPLIES 4
yashag2255
Dual Super User II
Dual Super User II

Hi @tcabel 

 

Can you confirm that the excel sheet is not open in any of the tabs when you are creating the action? Can you please post a screenshot of the error message/ flow? 

 

You can try logging out of the current session and closing the browser window, start a fresh session and try again. At times such errors pop up due to caching issues. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

v-yamao-msft
Community Support
Community Support

Hi @tcabel ,

 

Does this issue still exist?

 

I have made a test to Get tables from an Excel file which is stored on SharePoint, it is working properly.

1.PNG

 

As far as I know, sometimes the error caused by Graph API was due to some unknown reason, which will be expected to get fixed automatically.

 

Please try again with it to see if it is working for you now.

 

Best regards,

Mabel

 

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tcabel
Frequent Visitor

Yes I figured out the solution. I was using an excel document that had some features that were unsupported by excel online. Removing these features fixed this issue. 

View solution in original post

yashag2255
Dual Super User II
Dual Super User II

Hi @tcabel 

 

Glad that it worked. Can you please mark this question as solved (to the response that helped you with the query). Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search.

 

Thanks, 

Helpful resources

Announcements
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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (39,925)