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
@mikekiser Here is a blog on the substring action:
I am trying to use this after reading the blog but I am getting a syntax error
Thanks for your response but it still failed
InvalidTemplate. 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. Please see https://aka.ms/logicexpressions#substring for usage details.'.
@mikekiser In the run of that error. Could you share the parse json2 address1 property value.
I want to confirm what is in the address1 property.
You are getting this error if the string you're trying to substring is too short.
Try adding a condition to check for this before doing the conversion
Please take a look at my POC:
Keep in mind I am using lots of Compose actions to show what is happening. You can use less for your solution
First I get the length of address1
Than I use a IF condition to check if address1 is greater than 30 chars
Use the substring() expression on address1
my expression is:
with address1= This Address is too short
With address1 = This Address is too long and will be trunked
Check out new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.