cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
E_S
Frequent Visitor

Error: Http request failed: the content was not a valid JSON. Error while parsing JSON: 'Unexpected character encountered while parsing value: R. Path '', line 0, position 0.'

I am trying to write a flow and I get this error:

Http request failed: the content was not a valid JSON. Error while parsing JSON: 'Unexpected character encountered while parsing value: R. Path '', line 0, position 0.'

 

The flow it's really simple, variables and an execute query.

I am trying to get texts from power app and use them to modify a string variable in power automate. Then I use the modified string variable as a query. 

 

I start with a trigger from power apps and I specify what I want to save as a variable and use in power automate:

E_S_1-1645110265128.png

Then I have a variable to save my query as a string and I use the previous variable to modify it (I find it in the required fields). 

E_S_3-1645110912629.png

 

E_S_2-1645110825738.png

 

Here it seems that everything works, but I do not understand what  is "Impostavariabile_valore". 

E_S_4-1645111019801.png

 

E_S_5-1645111047965.png

 

The error appears in the last step, when I try to execute the query

E_S_7-1645111249504.png

 

 

E_S_6-1645111140810.png

 

Can you give me some advice? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
David_Pezzoli
Kudo Collector
Kudo Collector

I think it is a generic flow error:

Try to paste in the correct format the query directly into the action: "Esegui una query SQL"

In this way, you might get the exact new error of your query. 

Here is another solution using Try/Catch in order to detect a specific error:

 

https://powerusers.microsoft.com/t5/General-Power-Automate/Error-while-parsing-JSON-Unexpected-chara...

 

View solution in original post

54 REPLIES 54
DEV_SCASSIANO
Regular Visitor

**bleep**, I occur the same error!

David_Pezzoli
Kudo Collector
Kudo Collector

I think it is a generic flow error:

Try to paste in the correct format the query directly into the action: "Esegui una query SQL"

In this way, you might get the exact new error of your query. 

Here is another solution using Try/Catch in order to detect a specific error:

 

https://powerusers.microsoft.com/t5/General-Power-Automate/Error-while-parsing-JSON-Unexpected-chara...

 

David_Pezzoli
Kudo Collector
Kudo Collector

Try to using correct OData format, as example for SQL Sever Get Rows filter query:

ERROR: colRowId eq QR000001

OK: colRowId eq 'QR00001' 

the second will be accepted because you explain with quotes '' it is a string

jeffMazUr
New Member

Friends,
In my case, it worked putting the name of the O'DATA Filter column between quotation marks - because it has a graphic accent (pt-br) and spaces - simple as well as the value you want to compare.
Ex.:
'N_x00fa_merodes_x00e9_rie' eq '0ARYBJEM30001W'

Remembering: You must inform the column name as it appears when using the field in an expression.

binki-dcx
Advocate I
Advocate I

I got this same exact error on a flow which normally works fine. If I understand correctly, the remote endpoint is claiming that the input the flow provided is malformed. There is no way for us to debug this—it requires Microsoft to look into it.

 

It could be that some logging in the flow stuff gets written to the request. Or the flow request logic is written in a way which is not threadsafe so that an HTTP header shows up in the middle of the request body.

 

Here’s my error in a request to Outlook’s Reply to Email (V3):

 

Http request failed: the content was not a valid JSON. Error while parsing JSON: 'Unexpected character encountered while parsing value: R. Path '', line 0, position 0.'

@binki-dcx I've gotten that exact error 4 separate times today, on 4 separate flows, all on the "Send an email from a shared mailbox (V2)" action part of them. 

All of them went through on a resubmit, so a good use case for a custom workflow failure monitoring solution and hopefully something that knocks it off soon.

My advice is take glance the correct syntax of: the expressions, OData query or SQL query. Sometimes it's necessary add the quotes '....' and the blank spaces to the right place. So, look for similar examples on the Web that use the same steps. Check carefully the exact syntax of the steps used in the Web examples. Make sure the Web examples are recent blogs (with most PA updated version).

@nerfherderInteresting. Sounds like that particular service was broken for a while then.

 

@David_PezzoliPlease understand that this error comes up when Power Automate itself is having a temporary error or incorrectly handling transient errors from connected services. It has no relation to the correctness of our flows or expressions in our data. Did you read the thread or ever experience this error yourself?

David_Pezzoli
Kudo Collector
Kudo Collector

Maybe it could be an error due to a recent update in Power Automate of the version of the action? From my experience, when a new version of the action is released, sometimes the syntax also changes ....however, I agree  with you that this is too general a mistake and sometimes temporary!

nerfherder
Advocate II
Advocate II

@binki-dcx Never had this error before the other day, just had it again on a 5th flow. Resubmitting without changing source code results in successful run (error cannot be replicated?).

 

@David_Pezzolithere are not any new actions, expressions, or queries of the SQL or ODATA variety here. just plain dynamic content from one action to the next. 

 

whats the trick to getting someone from microsoft to see/respond to this thread?

 

 

nerfherder
Advocate II
Advocate II

seems to be related to the Outlook connector

@nerfherder you should open a ticket to Microsoft Power Automate support from Power Platform panel.

Anonymous
Not applicable

Happened here too, on multiple flows, intermittently, between Nov 3 and 7, when calling the Outlook Email action.  when re-submitting today, all flows ran without error.  Took me 2 hours to find them all and re-submit.

@David_Pezzoli lol i wish our microsoft admins had allowed it, our environment doesnt display in the little widget and im not 100% sure the virtual agent made a support request. The pace of these failures has slowed/dropped to zero so maybe they saw our posts here and fixed whatever it is. 

 

Thanks for sharing the Microsoft Learn documentation! I went through it and didn't see a reference to this specific error or it being a known issue on the actions I'm using (shared inbox email send) that have been failing.

@Anonymous there's a way to build custom error notifications in at the end of your flow so that these errors won't take you hours to search and fix. we use the "workflow" expression to pull out the important bits of dynamic content we need to make a link to the specific flow run that failed, and use configure run after failed to make us an individual notification on every failure. This way we aren't waiting around till Sunday or whenever the PA generated failure notification goes out.

@David_Pezzoli the only thing i can think of is that I'm only using one connection across 80+ flows for outlook, so its just getting overwhelmed by volume and sometimes throwing this error

Anonymous
Not applicable

Thank you @nerfherder.  We have just begun the task of adding custom error notifications to all of our flows – we have a long way to go! 

--Susan

@Anonymous yes but definitely worth it because of SLT. what we did is we came up with the design/layout we wanted in its own, manual flow. then we boxed up all the actions in a Scope and copy pasted it into every flow we're running. no need to manually add each time, love this tool!

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (3,269)