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

(1) Share

Report

Posted on by Community Power Pla...

Keep getting this error and do not know how to fix:

Goal is to find the values to the right of X-User-ID:

Categories:

Building flows

screencapture-mak...

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

I have made a video tutorial about this. Please have a look and comment.

https://youtu.be/U8LnANTHNgs

Thanks

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

@Anonymous Are you able to show the output you get from your Html to text action? It's difficult to know exactly what is required unless we see that output as it sometimes keeps the data on a single line, and splits to new line in other cases.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Amazing work!!! You blow my mind with the ease in which you put this automation together 🤯

Thanks so much for all of your help. Truly above and beyond anything I imagined in terms of a solution ✔️

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thanks for ask, the problem was solved last night by @abm

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Thanks so much for the lovely comments.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
If you're interested - this is how I would have done it, assuming the data was on the same line.

Based on the following email body.

Full flow below.

Expression used in the Compose is below that would extract out your data.
trim(first(split(last(split(outputs('Html_to_text')?['body'], 'X-User-ID:')), decodeUriComponent('%0A'))))

Output of the flow run.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you so much for your reply.

Was this reply helpful? Yes No