Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Extract text from Body of an email in Flow

I want to extract information from the body of an email and populate fields in a SharePoint. An extract of the email is follows;




Account Number 99999999

Contact Name Mr A N Other


Telephone 0123456789

Incident Reference XXXXX-XXXXX

I'm using the expression;


substring(body('Html_to_text'),lastIndexOf(body('Html_to_text'),'Account Number '),8)


Which is just populating the SharePoint field with 'Account ' whereas I actually want it to populate with '99999999'. I've tried a few different things to try and add on a value to the lastindexof value but I'm running into various errors.


Any suggestions would be appreciated.Capture.PNG




Accepted Solutions
Helper II
Helper II

Found the solution. Sure I tried this previously but working today.


substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Account Number '), 15),8)

View solution in original post

Helper II
Helper II

Found the solution. Sure I tried this previously but working today.


substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Account Number '), 15),8)

I have email content as below


Resolution Description : Test test test............................................................... can be 500 words

Department : IT Devlopement Team 

File Path: abcd\dba\ddd\fff\\\gggh\hhhh


Each of the content needs to be mapped against lsit column.


I tried with below formula but its also getting the department information as well but i just need Resolution Description

substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Resolution Description'), 19),500)


I'm assuming here so forgive me if I'm wrong, your Resolution Description can be a variable length, that is it could be a maximum of 500 words?


If thats the case I used the following to account for variable lengths of data;



substring(triggerBody()?['Body'],add(indexOf(triggerBody()?['Body'],'Account Number'),30),sub(indexOf(triggerBody()?['Body'],'Contact Name'),add(indexOf(triggerBody()?['Body'],'Account Number'),30)))

 So based off the above if you use;


substring(triggerBody()?['Body'],add(indexOf(triggerBody()?['Body'],'Resolution Description'),25),sub(indexOf(triggerBody()?['Body'],'Department'),add(indexOf(triggerBody()?['Body'],'Resolution Description'),25)))


The output of the above would be 'Test test test............................................................... can be 500 words' based off your example.


Not applicable



I'm having a similar problem, I am am trying to write an expression that will extract, from the email body, the date given after 'Start Date' (in this example, 28th December) and add that date it to the 'Start Time' Field in 'Create event (V2)', and do the same for End Date. Even if I could do that, would the date format be compatible or would I need to add a further expression to convert into an acceptable date format (and if so, what might that look like?)


The following leave request has been Approved by your line manager.


Employee: xxxx xxxxxxxx

Leave type: ANNUAL LEAVE

Start date: 28-DEC-17

End date: 28-DEC-17


Any suggestions/help would be greatly appreciated.


Many thanks




This should work, obviously replace Start with End for the End Date.


substring(triggerBody()?['Body'],add(indexOf(triggerBody()?['Body'],'Start Date'),30),9)

In terms of the date format being complatible, not used the Create event (V2) action myself so I'd just give it a go. If it does not work you could try using the formatDateTime fuction to convert it to an acceptable format, you'll find more information on that and the schema in general here.


Not applicable

Hi Mark,


Thanks very much for your help - much appreciated!


Unfortunately the flow is still failing - the error details are:


The string was not recognized as a valid DateTime. There is an unknown word starting at index 0. clientRequestId: 6e0beff4-c7ad-4817-ab13-e833cd0b3324


I guess that means I need to add the formatDateTime function, but not quite sure where in the expression I should add it - does it matter?





Can you screenshot the failed Flow with what it is outputting so we can see what it is trying you use as the date time?

Not applicable

Hi Mark,


Screen shot below. Does that give you enough info?  Many thanks again for your help.


 Failed Flow.png

Sorry was the inputs above that that I needed. I've done this myself though, although I had to run the Body through a Conversion action first because inputs were not showing a date but some of the html within the Body of the email. Structure of the Flow is below, Start and End Date expressions also follow.


substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'Start Date'),12),9)
substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'End Date'),10),9)



I just copy pasted the formula but it didnt work for me .I am getting below error.


Invalid text value. A text field contains invalid data. Please check the value and try again.  


I am keeping entire email content as Html_to_text.


I am thinking if any condition can be applied to read the data and exclude as sson as there is new line. appriciate for any solution.

I am completely new to flow.

Hi ,


I further observed below lines of formula is working


substring(triggerBody()?['Body'],add(indexOf(triggerBody()?['Body'],'Account Number'),30),sub(indexOf(triggerBody()?['Body'],'Contact Name'),add(indexOf(triggerBody()?['Body'],'Account Number'),30)))

 But how do i get the value from Html_to_text instead of  ['Body'].Please help .I am close to the solution.

You would need to replace all instances of triggerBody()?['Body'] with body('Html_to_text') assuming your conversion action is titled Html_to_text.

It worked. Thanks a lot.


I need one help. How to check if the output has null value and update space for null value for  below formulas.


substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'Alarm Display Id'),20),sub(indexOf(body('Html_to_text'),'Alarm Description'),add(indexOf(body('Html_to_text'),'Alarm Display Id'),20)))


substring(body('Html_to_text'),add(lastIndexOf(body('Html_to_text'),'Severity'), 10),6)

You could try wrapping the previous expression with this


if(empty(replace with expression),value if true, value if false)

Not tested it but should work. More information on the scehma can be found here

Hi there,


Just for future reference, Parserr, a conenctor available on Microsoft Flow extracts text from emails, PDF, Excel etc

Helper II
Helper II

Yeah I did look at that, unfortunately due to the volume of email this would require a financial commitment that the company would be unwilling to agree to for what we are using it for. So a zero cost solution was required. Would have made things much easier though!
Frequent Visitor

I tried to format the date without time in Flow:

EXPRESSION Can format it. However WITHOUT THE OPTION of DATE in the Excel and Flow

I used Dynamic Content, the date from excel can found but NO Format option there.

How can I format it?

This is pure gold!!!!! You just saved my day THX



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,267)