cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AminBasri
Regular Visitor

Parsing Email Body

Hi guys,

I have issue to parse email body. Before this it working as expected however, after some changes where the email body still in the HTML format but the value I can't extract.

 

Old Format: No problem, got the value..

 

 

Date: 2021/2/12

Time: 00:00 UTC

Incident: SF123

Segments: A

Location: Paris

Region: EMEA

EndText

 

 

 

Current Format:

 

 

Date:       Incident:   Segments:

2021/2/12   SF123       A

Time:       Location:   Region:

00:00 UTC   Paris       EMEA

EndText

 

 

 

When I do the HTML to text the result:

 

 

Date:

Incident:

Segments:

2021/2/12

SF123

A

Time:

Location:

Region:

00:00 UTC

Paris

EMEA

EndText

 

 

The value of data is separated from the KeyID which is Date, Incident, and Segments, etc thus I cant get the desired result.

 

I tried to use Initialize Variable using split functions:

 

 

- first(split(variables('EmailBody'),'Time:'))
- last(split(variables('step1'),'Segments:'))

 

 

 

Result:

 

 

2021/2/12

SF123

A

 

 

how I can get the specific value and insert to new row in Excel?? because the current result will take all value and insert in 1 row.

 

Full flow

Image 1.pngImage 2.pngImage 3.pngImage 4.pngImage 5.png

0 REPLIES 0

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (68,714)