Power Automate - Building Flows

The length of substring can't be longer than '8' which is the length of the source string.

(0) Share

Report

Posted on by blitz

Detailed flow steps

substring(outputs('Compose_Replace_NewLine'),0,outputs('Compose_Index_of_Thanks'))

indexOf(outputs('Compose_Replace_NewLine'),'Thanks')

replace(outputs('Compose_Email_Body'),outputs('Compose_NewLine'),'')

Im need to extract body from the email and create item in body column under sharepoint list but issue im running the flow is that

InvalidTemplate. The length of substring can't be longer than '8' which is the length of the source string.

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
I see you are using this expression with the substring function

substring(outputs('Compose_Replace_NewLine'),0,outputs('Compose_Index_of_Thanks'))

In this example the outputs Compose_Replace_NewLine has length of 8. However, the error message suggests that outputs of Compose_Index_of_Thanks is longer than 8. A substring function is not able to handle that and would give you an error in that situation.

For reference also see the docs: https://aka.ms/logicexpressions#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.

Was this reply helpful? Yes No
blitz on at

Like (0)

Report

Kindly help me how to modify below expression as per your reference

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

@Expiscornovus has explained why the scenario is happening. To handle we may need to re-write the expression. For example and easy to develop the expression- could you please share the what is input text and how it should be expected.

i have developed a sample which extracts the data from the email. see below, Not sure whether this fits your case/scenario.

I have used an email with format like this

Now coming to flow, I have developed for extracting email body data just before Thanks word

Expression used -

substring(outputs('Html_to_text')?['body'],0,indexOf(outputs('Html_to_text')?['body'],'Thanks'))

This gives me an output like this-

Well you can include the replace expression to replace new line something like below by modifying above expression

replace(substring(outputs('Html_to_text')?['body'],0,indexOf(outputs('Html_to_text')?['body'],'Thanks')),decodeUriComponent('%0A'),'')

Thanks & Regards,
Nived N

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
blitz on at

Like (0)

Report

Im facing the same issue and this time error is InvalidTemplate. The length of substring can't be longer than '4' which is the length of the source string.

I used below expression for the below scenarios
substring(outputs('Html_to_text')?['body'],0,indexOf(outputs('Html_to_text')?['body'],'Thanks'))

This my email sample screenshot

Scenarios email sample

Email Sample 1:

Email Sample 2: when i use the below expression,in this scenario its only create Hi,welcome text values and below values were removed as per this expression

substring(outputs('Html_to_text')?['body'],0,indexOf(outputs('Html_to_text')?['body'],'Thanks'))

Output:

Sharepoint list

Title Body

Hi,Welcome

Overall, my ask is that when create item in sharepoint list we should create body value by removing unncessary blank lines and email signatures images as its creating unreadable text values while flow parsing.

Was this reply helpful? Yes No