cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
farhandsome
Level: Powered On

SQL Server JSON Error

Hi all,

 

Just made the switch of data from SharePoint to SQL. However, I'm having trouble connecting to my SQL Server. I have made a test flow and keep getting this error:

 

Power Automate SQL Connector Error.PNG

 

I have never gotten this error before but now my flow won't run without triggering it. Can anyone tell me what the cause of it is?

 

Thanks,
Farhan

3 REPLIES 3
Super User
Super User

Re: SQL Server JSON Error

HI@farhandsome 

 

Indeed it's a strange case. Are you fetching all values or doing some sort of query to limit the information?

 

The issue here is that there's an invalid JSON but all of this should be abstracted in the action.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

farhandsome
Level: Powered On

Re: SQL Server JSON Error

Looks like it went away after I refreshed.. lots of bugs with a SQL server if it is continuously updated.

Super User
Super User

Re: SQL Server JSON Error

hi @farhandsome 

 

Super strange but could be a temporary glitch in the system. At least it's solved.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

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

Top Solution Authors
Top Kudoed Authors
Users online (9,859)