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?
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:
https://docs.microsoft.com/en-us/flow/fix-flow-failures
I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:
The flow works successfully as below:
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,
Kris