Import email outlook to excel

(1) Share

Report

Posted on by paul0021

I would like to import the beginning of text in an email to Excel via Powerautomate. The message contains: Good morning. My name is Paweł. How are you. I would like to import the first two sentences

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

HI

I would like to have seen a properly formatted message. Its the only way to help you properly. Since you just wrong a single string up top.

1. Have an Email Trigger for when one comes in

2. Use the HTML to Text Action for the Email

3. Parse the Email. Again I need to see the actual Email as its laid out to help you. Parsing can be done many different ways.

If everything ends in Periods.

Then do a Split(OutputOfHtmlToTextAction, '.')

This will create an Array

Then grab Array elements [0] and [1] and you have the first two sentences.

Now you can save it wherever you want.

Was this reply helpful? Yes No
Suggested answer

Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

To take out the first two sentences from the email body please do the following step as shown below

My email message contains the body below

I have created the flow which trigger on the modified of the Email message record

then used the “Html to text” Action which converts the description field which is HTML format into a string format

use compose action to make the array of sentences from the output of “Html to text”,

for that use the expression split(body('Html_to_text'),'.')
currently, we are splitting the sentence based on a full stop symbol (.)

then create a compose action which takes the first two sentences as shown below

expression used are
outputs('arrayOfSentence')?[0] :- this will give the first sentence
outputs('arrayOfSentence')?[1] :- this will give second sentence

Output of above flow will be

Please mark this answer as accepted solution if it helped you.

Hope this helps.

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No