News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows how can i get a value ...

Power Automate - Building Flows

Unanswered

how can i get a value from email body

(3) Share

Report

Report

Posted on by Appmaker

6

How can i get the value from the body of a email?

I have manny video with this question but i have a problem.

in the video`s i see that the name is like "Guide Last Name : Mol" and i get the name in the next row how can i get this?

and to make it more dificulte it is not always on the same place.

see the pictuer down here.

split(outputs('Html_to_text')?['body'],outputs('Compose_2'))

Categories:

Business Process Flows

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

how can i get a value from email body

Hi

The value you after is always at the end of the array? I am looking the example you had given, then you could use expression last() to get that value eg: Mol

last(split(outputs('Html_to_text')?['body'],outputs('Compose_2')))
Suggested answer

Michael E. Gernaey 43,474 Super User 2025 Season 1 on at

Like (0)

Report

how can i get a value from email body

Hi

You said,

and to make it more dificulte it is not always on the same place.

see the pictuer down here.

If your format is completely different each time, then you have to do a lot more work as you would need to identify the pattern the email uses, then use a Switch to then find the last name.

It's not possible to write it for you as I do not know all the patterns you have.

Also you should share the PRE-split data, not the split data as I have no idea why you have so many blanks or spaces because I cannot see the data.
Chriddle 7,793 Super User 2025 Season 1 on at

Like (0)

Report

how can i get a value from email body

I assume this is easier with the HTML. Can you show it?

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans