Answered

Data from plain text email body

(0) Share

Report

Posted on by itman0806

Thank you for taking the time to read this.

I am working at building a flow that extracts text from received email. The email is plain text and all the examples I have come across are html and use the html to text option. The text I am looking for is the following.

Notification Source: Service

Notification Type: RECOVERY

Service: NotRealService

Host: NotRealHost

Host Alias: NotRealHostAlias

Address: x.x.x.x

I have followed the examples using the html to text but, text becomes one line with no delimiters.

Notification Source: Service Notification Type: RECOVERY Service: NotRealService Host: NotRealHost Host Alias: NotRealHostAlias Address: x.x.x.x

I tried splitting the output of the compose but the split function does not like that. The information after the colon varies in length. Normally I would loop through the rows and match the text to the left of the colon, then assign accordingly.

Ideally what I am trying to do is find the data Host: (and other data listed above) and take everything to the right of the colon. and assign it to a variable. var_Host, var_Service, and so on.

I am going to keep at it and search more through this forum.

Any help is appreciated. Thank you for your time.

Paul

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

Hi @itman0806 ,
Please use split to separate the required content, and use the headings before and after the required part as the dividing line
As long as the title does not change, you can accurately obtain the required content
I made a template for your reference:

Notification Source: trim(first(split(last(split(outputs('Html_to_text')?['body'],'Notification Source:')),'Notification Type:')))
Notification Type: trim(first(split(last(split(outputs('Html_to_text')?['body'],'Notification Type:')),'Service:')))
Service: trim(first(split(last(split(outputs('Html_to_text')?['body'],'Service:')),'Host:')))
Host: trim(first(split(last(split(outputs('Html_to_text')?['body'],'Host:')),'Host Alias:')))
Host Alias: trim(first(split(last(split(outputs('Html_to_text')?['body'],'Host Alias:')),'Address:')))

Address: trim(last(split(outputs('Html_to_text')?['body'],'Address:')))

Best Regards
Cheng Feng

Was this reply helpful? Yes No
itman0806 5 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft ,

Thank you for the detailed information. This is very helpful. To help me visualize the steps I broke them out.

This is also giving me more ideas on how to use power automate flows.

Thank you again for your time.

Paul

Was this reply helpful? Yes No