Substring in power automate got error

(0) Share

Report

Posted on by nitisak

162

Hi,

I would like your help about Substring function. I've using this function everyday and it can use normally.

Today I got this error. Here is my formular.

replace(trim(substring(variables('Emailt'), add(indexOf(variables('Emailt'), 'ORGANIZATION'), 13), sub(indexOf(variables('Emailt'), 'POSTCODE: '), add(indexOf(variables('Emailt'), 'ORGANIZATION'), 13)))),variables('New Line'),' ')

All responses (3)

Answers (1)

nitisak 162 on at

Like (0)

Report

Re: Substring in power automate got error

Hi @v-xiaochen-msft,

I got this !! Thanks for your help.

BR.
Nitisak.
Hardesh15 7,087 on at

Like (1)

Report

Re: Substring in power automate got error

@nitisak https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#substring

Make sure that the sum from adding the startIndex and length parameter values is less than the length of the string that you provide for the text parameter. Otherwise, you get an error, unlike similar functions in other languages where the result is the substring from the startIndex to the end of the string. The length parameter is optional and if not provided, the substring() function takes all the characters beginning from startIndex to the end of the string.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Verified answer

v-xiaochen-msft on at

Like (1)

Report

Re: Substring in power automate got error

Hi @nitisak ,

Please try:

replace(trim(Split(Split(variables('Emailt'),'ORGANIZATION')[1],'POSTCODE: ')[0]),variables('New Line'),' ')

Best Regards,

Wearsky