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... Microsoft Employee

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

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

screencapture-make-powerautomate-environments-Default-a7b464e0-870c-43fc-8e72-6de7aeddfcd5-flows.png

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

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

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Thanks so much for the lovely comments.

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

Like (1)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your reply.

Was this reply helpful? Yes No