Answered

Extracting specific information from the body of the email to MS excel

(1) Share

Report

Posted on by power13

Hello,

I'm stuck with this task of extracting specific information from the body of the email (Attached) to MS excel. From the long email that is generated everytime a ticket is booked with the agency, I want to extract just the employee ID, flight #, booking ID, and the destination and arrival city and country of each leg in an excel file

I tried using different expressions to get these specific info from the email but couldn't get the required info to MS Excel.

split(outputs('Html_to_text')[4],':')[1]

first(skip(split(body('Html_to_text'),'Flight: '),1))

first(skip(split(body('Html_to_text'),'Flight: '),4))

Any help would be much appreciated.

Regards,

Raam

Categories:

Building flows

Travel email.docx

I have the same question (0)

All responses (3)

Answers (1)

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @power13 ,

I just helped someone yesterday do this and providing the link to that thread. Please mark as a solution and follow the steps.

Solved: Re: Extracting Specific Text from an Email Body - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Verified answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @power13 ,

I forgot to mention, once you have the individual variables of the email data you want, then you 'Add a row' Action and use those dynamic variables to add to your Excel workbook.

Was this reply helpful? Yes No

power13

37 on at

Like (0)

Report

Thank you @trice602 !! It worked well as expected. However, I have a challenge here. My travel itinerary may have two or three country of origin and departure date and I want to fetch each occurrence as a row and have it stop when there is no further data.

For example, from the attached email text, I want my output to show the information in the table below. The fields repeat with value changing and I want each one to show in a separate row in Excel. So grateful if you could resolve this one.

Emp ID	Flight	Origin	Departure date	Destination	Arrival date
999999	Qatar Airways	Bangkok, Bangkok Suvarnabhumi International Apt (BKK)	Thursday 28 September 2023 at 8:00PM	Doha, Doha (DOH)	Thursday 28 September 2023 at 10:50PM
999999	United Airlines	Doha, Doha (DOH)	Friday 29 September 2023 at 1:20AM	Washington, DC, Washington Dulles International Apt (IAD)	Friday 29 September 2023 at 8:50AM
999999	Air France	Washington, DC, Washington Dulles International Apt (IAD)	Friday 29 September 2023 at 1:20AM	Paris Charles de Gaulle Airport (CDG)	Friday 6 October 2023 at 8:50AM