Length of substring error

[annabelh1]

Hi, I have created a flow which extracts information from an email and which has been running fine throughout testing but one of the actions has now shown an error with one of our tests:

This is the expression:

trim(substring(body('Html_to_text'), add(indexOf(body('Html_to_text'), 'Work Email'), 10), sub(indexOf(body('Html_to_text'), 'Work Phone'), add(indexOf(body('Html_to_text'), 'Work Email'), 10))))

And this is the email format:

There are multiple fields using the same format and none have had issues until now.

Any help appreciated! Thanks

[annabelh1]

I have noticed that the email is coming through in a different format now that it is being picked up directly from the mailbox:

(Old format) Html to text output (where the flow worked fine)

First Name

Joe

Last Name

Bloggs

Work Email

joe@bloggs.com

Work Phone

021112222333

(New format) Html to text output (errors in the flow)

First NameJoeLast NameBloggsWork Emailjoe@bloggs.comWork Phone02111888222

[annabelh1]

It seems to be that the format of the email has changed as the html to text is different than it was previously.

The old format of the html to text when the flow worked was:

First Name

Joe

Last Name

Bloggs

Work Email

Example email text here

Work Phone

Phone number here

The new format is like this which is producing errors:

First NameJoeLast NameBloggsWork EmailExample email here

[michael0808]

Would you mind sending an example of the text that is being inputted in plain text rather than a screenshot. You can redact any personal information if you wish?

Edit:

I think I more understand the issue now. It is recommended to extract each piece of data separately. Try creating a new compose for each piece of data you need. You can then piece it back together how ever you wish.

[annabelh1]

Hi, there is some example text in my reply above however it doesn't seem to matter what the text is for the email address field, I've tried a few different addresses now and only a very short email address worked (15 characters). However when that worked it then failed on a phone number field further down. That's when I realised that it wasn't related to the email address it was the format of the email. Thanks

[annabelh1]

I am currently extracting each piece of data separately, here is a screen shot of part of the flow:

The aim of the flow is to get the data from each field and then use the info to create a lead in dynamics crm.

I'm not sure if I need to adjust my substring expression now that the text is running together in the html to text conversion.