Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,451 questions
Logic App SQL Insert Truncating Column Value
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 44%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jack Speidel
0
Reputation points
Logic App that is used to insert a row into SSMS Table is truncating the value of a string. The column receiving the data is set to type "varchar(max)" and is receiving data that, while substantial, is less than 2GB. The Logic App value shows the full string, so the issue is happening somewhere in-flight or on insert.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Loknathsatyasaivarma Mahali 1,290 Reputation points Microsoft External Staff2025-03-25T21:57:42.9433333+00:00 Hello Jack Speidel,
Thanks for reaching out, could you please confirm on the below
- Which action in the Logic App are you using to perform the insert, and does it involve any SQL stored procedure with casting or conversion of parameters?
- What is the character length set for the SQL columns, and is the length consistently capped across all row writes?
-
Loknathsatyasaivarma Mahali 1,290 Reputation points Microsoft External Staff
2025-03-27T19:16:28.8733333+00:00 Hello Jack Speidel,
Could you please share the required details so we can better understand and investigate the issue, and provide an appropriate solution?
-
Loknathsatyasaivarma Mahali 1,290 Reputation points Microsoft External Staff
2025-03-29T00:00:49.2833333+00:00 Hello Jack Speidel,
We wanted to follow up on the issue you encountered. Please let us know if it's resolved or if you need further assistance.
Sign in to comment
Sign in to answer