Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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
Community Support

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


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!


Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

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


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (9,865)