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

Unable to connect to table

HI folks,

I'm new to using flow and trying to build a flow to import excel data into a SP list

First problem is I when I go to select the table in my file I get a message saying "Could not retrieve values. Error exectuing the api". I definetaly have my data in a table in this spreadsheet.Flow Connection Error.PNG

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User II
Super User II

According to the Troubleshooting a Flow documentation, a 502 Error is "transient" or temporary.  Others have reported a similar issue, so there might be a problem with the Flow/SharePoint Online service at the moment. 

If the error code 500 or 502 appears, the failure is temporary or transient. Click or tap Resubmit to try the flow again.

You can check the status of your Office 365 tenant at portal.office.com/servicestatus. If the issue persists, you should submit a support request at support.office.com.

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!

View solution in original post

Community Support
Community Support

Hi @Rockstar55 ,

 

Please try to log out of the Flow account and log back in.

Then reconfigure or update Excel online connection and create a similar Flow check to see if the problem still exists.

 

I did a test on my side and can normally select the expected Table from the Excel file. When configuring File, please select the specified File through File Browse.

11.PNG

This seems to be a temporary error. MS Flow Support has not updated any issues with the service.

Please try it a few times.If the problem persists, please let us know.

 

Best Regards,

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

View solution in original post

4 REPLIES 4
Super User II
Super User II

According to the Troubleshooting a Flow documentation, a 502 Error is "transient" or temporary.  Others have reported a similar issue, so there might be a problem with the Flow/SharePoint Online service at the moment. 

If the error code 500 or 502 appears, the failure is temporary or transient. Click or tap Resubmit to try the flow again.

You can check the status of your Office 365 tenant at portal.office.com/servicestatus. If the issue persists, you should submit a support request at support.office.com.

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!

View solution in original post

Community Support
Community Support

Hi @Rockstar55 ,

 

Please try to log out of the Flow account and log back in.

Then reconfigure or update Excel online connection and create a similar Flow check to see if the problem still exists.

 

I did a test on my side and can normally select the expected Table from the Excel file. When configuring File, please select the specified File through File Browse.

11.PNG

This seems to be a temporary error. MS Flow Support has not updated any issues with the service.

Please try it a few times.If the problem persists, please let us know.

 

Best Regards,

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

View solution in original post

Advocate II
Advocate II

Hi @Rockstar55 ,

 

Might be the error is because your Excel file has set to been check-out before the edit, so the connector has no permission to get the table.

 

ilu989

 

Anonymous
Not applicable

@ilu989 This was the cause of my error. I could get to the site, collection, and file, but could not select a table with the error above. Had the owner disable "require checkout" on the collection, and it resolved the issue.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (90,602)