Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZuaNR9BVAWMgIQCZpV/dSt
Power Automate - General Discussion
Unanswered

The response is not in a JSON format Error code 302

Like (1) ShareShare
ReportReport
Posted on 25 Nov 2024 21:48:36 by 71
Hi all,
 
I am running into an issue when inserting rows into an Excel file.
 
I am using the M365 connector 'Send and HTTP request' to POST the rows into an Excel. 
The rows are in a JSON format.
 
The flow works fine if the JSON contains less than 20,000 rows of data. But as my dataset contains 25,000 rows, the flow is throwing a 'Redirect' message with code 302, which is not really an error.
 
So instead of troubleshooting the error below, I was thinking of finding a solution to the redirect error knowing that the flow works perfectly with less than 20k rows.
    "message""The response is not in a JSON format.",
    "innerError""Cannot read server response."
 
Any idea how I can handle this please?
 
Below is my Flow. We are getting the JSON from Powerapps and I am creating the Excel file on Onedrive.



Categories:
  • StephanJ Profile Picture
    71 on 26 Nov 2024 at 17:06:00
    The response is not in a JSON format Error code 302
    This is what I receive when it is returning the redirect 
     
    "Location""/error/error.html?aspxerrorpath=/x/_layouts/xlrestinternal.aspx",
     
    but in case of success the location is https://graph.microsoft.com/
     
  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 26 Nov 2024 at 02:29:07
    The response is not in a JSON format Error code 302
    Hi @ ,
     
    when getting the redirect url - any url value is found under response header ?
     
     
    Thanks & Regards,
    Nived N
     
     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard