Logic App Truncate?? Please help...urgent

Question

Hi

We have some addresses that are greater than 30 chars and I have to truncate those to 30 chars max.....what I am trying to do is

"Condition_2": {
"actions": {
"Set_variable": {
"inputs": {
"name": "Address",
"value": "@{substring(body('Parse_JSON_2')?['address1'],0,29)}"
},
"runAfter": {},
"type": "SetVariable"
}

The error I am getting is: PLEASE HELP! Thanks Mike Kiser
Unable to process template language expressions in action 'Set_variable' inputs at line '1' and column '2956': 'The template language function 'substring' parameters are out of range: 'start index' and 'length' must be non-negative integers and their sum must be no larger than the length of the string

Answer 1

Hello @Mike Kiser ,

You can utilize the "if" logical comparison function long with the greater ,length and take in the following manner.

"value": "@if(greater(length('enter_your_value'),30), take('enter_your_value',30), 'enter_your_value')",  

Please let me know if this solution does not solve your issue I will be happy to continue with our discussion.