SQL Server JSON Error

(0) Share

Report

Posted on by farhandsome

175

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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
farhandsome 175 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No