Answered

Extract Body Text From Email

(0) Share

Report

Posted on by KJLog

I am using PowerAutomate to pull Text from a standard email template like below, I have tried splits previously, The problem I'm having is some of the fields such as "Vehicles" Aren't always on the same email line as some fields are multiple lines or single lines.

The bold Text is always the same.

Destination: Parnngurr

Arrival Date: 11/03/2024

Check In Time: 16:00

Vehicles: KJ33 1HPI 326 n/a KJ35 1HZU453 n/a KJ13 1HHN906 n/a n/a .n/a .

I'm currently using below variable mentioned in a post here, but I keep getting the The length of substring can't be longer than '251' which is the length of the source string, Regardless of what I change the numbers too.

substring(triggerOutputs()?['body/bodyPreview'],add(indexOf(triggerOutputs()?['body/bodyPreview'],'Departing From: '),14),sub(indexOf(triggerOutputs()?['body/bodyPreview'],'Travelling Via: '),add(indexOf(triggerOutputs()?['body/bodyPreview'], 'Departing From: '),7)))

Help is much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @KJLog ,

Could you please post a screenshot of your complete email body?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @KJLog ,

I did a test for your reference.

In my scenario:

My Outlook Inbox:

My Flow:

trim(split(split(outputs('Html_to_text')?['body'],'Vehicles:')[1],'Departing From:')[0]) trim(split(split(outputs('Html_to_text')?['body'],'Departing From:')[1],'Travelling Via:')[0]) split(outputs('Html_to_text')?['body'],'Travelling Via:')[1]

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
KJLog 10 on at

Like (0)

Report
Copy link

Link copied!

That worked perfectly thankyou very much 🙂

Was this reply helpful? Yes No