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

(0) Share

Report

Posted on by johnjohn123

3,506

I have the Store_x0023_ values = something as follow 123;#112 .. where i want to get the charterers after the "#".. so 112 on my case

Where i tried this formula:-

substring(triggerOutputs()?['body/Store_x0023_'],add(lastIndexOf(triggerOutputs()?['body/Store_x0023_'],'#'),1),sub(length(triggerOutputs()?['body/Store_x0023_']),lastIndexOf(triggerOutputs()?['body/Store_x0023_'],'#')))

But i will get this error:-

Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': '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.'.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Hi there,

I was able to get it using this:

substring(variables('txtHashtag'),add(indexOf(variables('txtHashtag'),'#'),1))

For you this would be,

substring(triggerOutputs()?['body/Store_x0023_'],add(indexOf(triggerOutputs()?['body/Store_x0023_'],'#'),1))

Can you try that out and let me know if it fits your needs?

Cheers,

Rhia

Was this reply helpful? Yes No