Power Automate - Extract Text Values from Email!

Learn how to extract text values from emails using Power Automate. With this flow you can even achieve system integrations that would otherwise be impossible without API.

Expressions used:
Split Body Text: split(body('Html_to_text'),outputs('EnterKey'))
Compose: Name: last(split(outputs('Split_Body_Text')[6],': ')) (Where "6" equals the row of the output array of the value you want to extract)

#rpa #powerautomate #outlook #integration

[jibbsautomations]

Expressions used:
Split Body Text: split(body('Html_to_text'), outputs('EnterKey'))
Compose: Name: last(split(outputs('Split_Body_Text')[6], ': ')) (Where "6" equals the row of the output array of the value you want to extract)

[kyowakore]

This is exactly what I needed to implement. Great tutorial. Thank you!

[caleybell]

Thank you so much for this, I have watched heaps of videos trying to achieve this and yours was the clearest - I finally got the result I needed!

[cainweo]

Man you saved my life ! thanks a lot very straightforward

[allison]

This is an amazing tutorial! Thank you!

[beprovidelo]

Great Content! Warm Regards from Brazil! :)

[mhsea]

Excellent method and tutorial; thank you so much 😊🙏

[RolandoNispiros]

Awesome tutorial, thank you, this helped me!

[maximumtaste_]

I hope you see this in time, but I have the issue that all of the data is in one single line and I have a different output of data in every different e-mail

[pebkaclive]

I get the following error:

Unable to process template language expressions in action 'SplitBodyText' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'.

Any thoughts?

[RolandoNispiros]

Can you tell me how to only strip out text between words? For example I just want the word 'Financial' to be the output result from a place in the body of the email that has '2022/23 FY Financial Control Audit'. When I use the 'Last' expression and Split Body Text like you showed, 'last (split(outputs('Split_Body_Text')[11], ': ')), as an example, I get a full line of other data, including the word(s) I wanted.

[MaxineInUuPoep]

Hi! Thank you for this video, I'm doing the same steps but in the Compose step I get this error:
The input parameter(s) of action 'Compose' contain an invalid reference to 'Split_Body_Text'. Correct to include a valid reference to 'Split_Body_Text' for the input parameter(s) of action 'Compose'.

Not sure what I'm doing wrong?

[hariyalipatel]

Amazing video. I have word document and want to copy in email body in same format as it is in word document. Is this possible in power automate?

[ojclqqm]

Very helpful and have spent hours over the past few days trying to figure out how to do this exact function with no success until your video. Just out of curiosity, what is the point of the "EnterKey" action?

[PollynzDataTech]

Thank you for the video, could you help me on the issues I am having. The EnterKey compose is not working for me, it is saying "This filed is required"

[peterchu]

Thanks for this wonderful tutorial. My problem is when I compose for the Company name, I get this error: Property selection is not supported on values of type 'String'. I think its because my emails that I work with have pics, and Links. I cant seem to discard those, even if my first compose after the HTML_to_text function is a split function, essentially I get errors Whats a nifty way to remove all URLs after the Html_to_text function?

[chowdaryjaladi]

last(split(outputs('Split_Body_Text')[6], ': '))

This works but, i wanto to get the output of the lines from 4 to 10, what is the expression for that?

[zzexp]

I do not have any actions under 'Content Conversion' anyone know why?

[ultracamp]

How come the Compose Split Body Text is required? The input and output look identical in the test?

[Quadcrew]

Thank you that is great, would like to know, how to save the results into a sharepoint list, is there already a fitting video? Thanks very much in advance 👍👍