Answered

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

(0) Share

Report

Posted on by Xinlin

Hi,

I am developing a flow to convert email body from HTML into text. However, I've come across this error where it said it had exceeded the substring length limit. I do set the limit in the next step in "Compose 7" with 5000 characters. If I were to fix this issue, do I have to move it above or is there any extra steps I should add to it? Here I attached with my flow and the text error result.

Thank you.

Flow Sequence:

Flow Error Details:

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-dezhili-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Xinlin ,

The third parameter of substring() has the following restrictions.

Your string length is only 3296, you can change your function to
substring(outputs("Compose_6"),0,3296)
flow will run successfully.
But this will output all the characters of Compose_6 and there is no difference between referencing Compose_6 directly.
Could you please tell me your purpose of using substring()?

Best Regards,
Dezhi

Was this reply helpful? Yes No
Expiscornovus 33,970 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Xinlin,

I believe the calculation of the length in Compose 6 of this example is sub(-1,8). The outcome of that is -9, a negative number.

Which is not allowed as a length parameter in a substring function. That needs to be a positive number.

Was this reply helpful? Yes No
Xinlin 82 on at

Like
a
(0)

Report
Copy link

Link copied!
My flow got stuck at the 'Compose 6' stage which I think it will likely run into the same issue again even if I change it to
substring(outputs("Compose_6"),0,3296)
The purpose of this flow was to read body of incoming email and capture the text into an AI Model that I've built for text classification. Hence needed to convert email into text first.

Was this reply helpful? Yes No
Xinlin 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I see, do you mind sharing the possible solution i could look for to fix this issue?

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Xinlin ,

Sorry for my mistake.
From the output, it seems that there is no "Start time" string in your email body.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,970 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Xinlin,

Try this instead in the Compose 6

if(equals(outputs('Compose_5'), -1), 'Start Time not found', substring(outputs('Html_to_text')?['body'], outputs('Compose_4'),sub(outputs('Compose_5'),outputs('Compose_4'))))

Was this reply helpful? Yes No
Xinlin 82 on at

Like
a
(1)

Report
Copy link

Link copied!

I changed 'Start time not found' to the html to text output and it works, thank you so much!

Was this reply helpful? Yes No