Unanswered

Parse HTML Email body

(0) Share

Report

Posted on by sherif77

Hello,

I have an HTML email that i received in specific created folder, I would need to parse the text within the email to SharePoint list where i have already set my headers to correspond the value in each email.

Request Number , Invoice Number , Invoice Date, Fees, Saddad Number, Biller Number

The typical Paragraph in the email is as follows :

Fees Payment

Dear \ XXXXXXXXXXXXXXXXXXX
An invoice has been issued for the request number 2020-105913 for service New Marketing Permission
Invoice Number : XXXXXXXXXX (Numbers)
Invoice Date : 31/10/2020 (Dates)
Fees: 15000.0 (Numbers)
Sadad Number : XXXXXXXXXX (Numbers)
Biller number : XXX (numbers)

Connectors i tried using When an email arrives, HTML to email, Compose ( then could not pass the compose ones)

Compose

length(body('Html_to_text'))= return 1730 character in the initial email received

Compose (Request number )

add(indexOf(body('Html_to_text'),'Request Number'),15) = output 675

Compose ( Invoice Number)

Int(indexOf(body('Html_to_text'),'Invoice Number')) = output 725

Compose (substract request Number from Invoice Number)

Sub(outputs('Request_Number'),outputs('Invoice_Number'))= output -50

I hope you could assist in this one urgently,

Regards,

Sherif

All responses (14)

Answers (0)

Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parse HTML Email body

Hello, you never pasted the HTML source. You posted some plain text, is that the result you got after Power Automate did a HTML to text operation?
sherif77 on at

Like (0)

Report

Re: Parse HTML Email body

@Paulie78

Hope all is well,
any feedback on this one ?

Regards,
sherif,
sherif77 on at

Like (0)

Report

Re: Parse HTML Email body

@Paulie78

Okay here you there
https://pastebin.com/y6HYF5Kc

Regards,
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parse HTML Email body

I wanted the HTML source code, so a link to the code on Pastebin would have been useful. You posted an image of what it looked like.
sherif77 on at

Like (0)

Report

Re: Parse HTML Email body

@Paulie78

Thank you,
This is how the Email was formulated on Pastebin.

تسديد المقابل المالي
السادة / XXXX XXXXXX XXXXXX XXXXXXXX
تم اصدار الفاتورة الخاصة بالطلب رقم 2020-119206 مقابل خدمة تعديل اذن تسويق
رقم الفاتورة: 2270947260
تاريخها: 27/12/2020
بمبلغ 5000.0 ر.س , و رقم سداد 2270947260
رقم المفوتر : 109
نود التنوية بأنه في حال عدم السداد خلال (30) يوم من إصدار الفاتورة سيتم إلغاء وشطب الطلب
وعليه يتطلب تقديم طلب جديد
للمزيد الرجاء الضغط على الرابط التالي
Fees Payment
Dear \ XXXX XXXXXXX XX XXX
An invoice has been issued for the request number 2020-119206 for service Update Marketing Permission
Invoice Number : 2270947260
Invoice Date : 27/12/2020
Fees: 5000.0
Sadad Number : 2270947260
Biller number : 109
please notice that if non-payment within (30) calendar days from issuing the invoice, the request will be canceled and closed and you are required to submit a new application
For more detail please click this link

All rights reserved to the XXXXX XXXX and XXXX XXXXXXXXX. Terms of Use | Privacy policy
جميع الحقوق محفوظة للهيئة العامة للغذاء والدواء . شروط الإستخدام | سياسة الخصوصية
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parse HTML Email body

It's totally possible, if you are new to Power Automate then I wouldn't class it as easy. The flow I gave you would have worked if your email actually matched what you originally posted 😁.

The best thing for you to do (because I can now see that it is a HTML email with a great deal of other content). Would be to get the HTML source and put it on pastebin.com - so I can at least help you with the same source content.
sherif77 on at

Like (0)

Report

Re: Parse HTML Email body

@Paulie78

I'm actually still learning a lot of information sounds gibberish to me but I'm trying. so, i apologize for any inconvenient information shared from my side.

Is it possible by any chance to get this done by powerAutomate or it will be hard.🤔

Thank you in advance.
Sherif,
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parse HTML Email body

Well, its a significantly different email format to the one you originally posted, so that would certainly explain it not working 😐
sherif77 on at

Like (0)

Report

Re: Parse HTML Email body

@Paulie78

I tried it didn't work for Me i don't understand why, but i think its for the following reason

The Email include Arabic words / letters

[http://dev-internet.XXX.XXX.XX/assets/email/logo.png] [http://dev-internet.XXXX.XXX.XX/assets/email/EmailLogo.png]
تسديد المقابل المالي السادة / شركه XXXX XXXXXX XXXXXX XXXXXXX
تم اصدار الفاتورة الخاصة بالطلب رقم 2020-107047 مقابل خدمة اذن تسويق جديد
رقم الفاتورة: XXXXXXXXXX
تاريخها: 04/11/2020
بمبلغ 19000.0 ر.س , و رقم سداد XXXXXXXXXXX
رقم المفوتر : XXX
نود التنوية بأنه في حال عدم السداد خلال (30) يوم من إصدار الفاتورة سيتم إلغاء
وشطب الطلب
وعليه يتطلب تقديم طلب جديد
للمزيد الرجاء الضغط على الرابط التالي
[https://XXXX.XXXX.XXX.sa/dashboard/email-notification/127937]
Fees Payment Dear \ XXXX XXXXXXX CO LTD
An invoice has been issued for the request number 2020-107047 for service New
Marketing Permission
Invoice Number : XXXXXXXXXX
Invoice Date : 04/11/2020
Fees: 19000.0
Sadad Number : XXXXXXXXXX
Biller number : XXX
please notice that if non-payment within (30) calendar days from issuing the
invoice, the request will be canceled and closed and you are required to submit
a new application.
Paulie78 8,416 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parse HTML Email body

Go into the run history and see what your email lines array contains (post it and change the data if you need to). It seems like the line split hasn’t worked for you.