web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Problems connecting to...
Power Automate
Unanswered

Problems connecting to excel

(0) ShareShare
ReportReport
Posted on by

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

 

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    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: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,

    Kris

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard