Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Problems connecting to excel

I'm trying to connect to an excel s/s held in a central sharepoint site, and when giong through the connection stages its very very flaky. At each selction step i sometimes get the response isn't in a json format, however after a few attempts its magically brings back the list of folders to select.


So thats one issue, then when i finally get to select my s/s and then the table to write a row to, i get another error (if i can get the image pasted!) but the error is 500: the response inst in a json format again.


Very frustrating. doesnt fill me with much confidence the service will work even if i get through this part.


Any ideas?2018_05_24_10_17_26_Create_your_flow_Microsoft_Flow.png


Community Support Team
Community Support Team

Re: Problems connecting to excel

Hi @AJP1,


The HTTP 500 error is a temporary or transient failure, please click or tap Resubmit to try the flow again to check if the issue is solved. More details about troubleshooting a flow, please check the following article:


I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:19.JPG

The flow works successfully as  below:20.JPG



Please check if the connection to the "Add a row into a table" action of your flow is invalid, if yes, please update the connection to this action and then try your flow again to check if the issue is solved.


More details about updating a connection in Microsoft Flow, please check the following article:

Update connection in Microsoft Flow


In addition, please take a try to clear cache of your browser and re-create a new connection to the "Add a row into a table" action within your flow, then try your flow again to check if the issue is solved.



Best regards,


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

Helpful resources


Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.


Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 338 members 4,471 guests
Please welcome our newest community members: