Power Platform Community Forum Thread Details

# General Overview

Posting this so someone does not have to go thru the troubleshooting I did....

I had a somewhat complex stored procedure that pulled from a few tables, and inserted in a few tables conditoinaly.. 20+ params

I followed the docs to add the SP to my canvas app, but was getting the following error when i called the SP in PowerFx

```JSON

{
  "status": 400,
  "message": "Invalid data type for parameter 'your-json-paramater' found.\r\nclientRequestId: 291b0037-eae1-4909-8dca-afa6679a3111",
  "error": {
    "message": "Invalid data type for parameter 'your-json-paramater' found."
  },
  "source": "sql-ncus.azconn-ncus-001.p.azurewebsites.net"
}

```

# important context

your-json-paramater was Dtype JSON on my stored procedure. This SP would only use this param to insert the value into a JSON column.

I am running AZ sql

# FIX !!!!
A Sr power app dev at my org said the MSSQL power app connector might not like json.. so I updated the SP `your-json-paramater` dtype to NVARCHAR(MAX).. Kept the collumn as JSON. Now everything works smoothly.

## QUESTION
why does this happen ?
my assumption is that with all the diffrent builds/versions/deployments/'flavors' of MSSQL now days the connector just does not allow JSON values as not all flavors of MSSQL have native JSON..

Categories:

Building Power Apps