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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,996)