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'),' ')

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @nitisak ,

Please try:

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
nitisak 162 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft,

I got this !! Thanks for your help.

BR.
Nitisak.

Was this reply helpful? Yes No