Extract specific table in email body

[TengkuMaestro]

Hi guys,

i required some help to extract the JA table. i managed to extract the first table but unable to extract the 2nd table. below is the example email body to be extracted. thank you in advance

_______________________________________________________________________________________________________________________________

Dear 1060 SD,

On Behalf PM , Kindly please create tickets as details below:

CASE :

No	Item	Selection
1	Description Information
Subject	Request for ticket create for Site Installation
Description	Appreciate to raise 1 SRF ticket for the task completed by my end
2	Case Information
Source	Email – VADS ICT (1MA)
Severity	3-Medium
Impact	User
Priority	3-Medium
Status	Open
3	Contact Information
Account Name	VADS
Contact Name
Reported By
Preferred Acknowledgement	Email
4	Service Request Details
Category	1MA Customer
SubCategory	Network Service and Support
Catalog Item	Installation
Catalog Item ICT	4089 - Installation
TM Product Name	Internal
TM Completed Date	23/06/2023 08:54
Reason	Customer Request
5	Asset Information
Asset/Service
Project Name

JA :

Description	Appreciate to raise 1 SRF ticket for the task completed by my end
Assignment	SD-Enterprise-ICT- L1- Service Desk

[VictorIvanidze · Accepted solution]

Please show how you are extracting the first table.

[AlexEncodian · Accepted solution]

@TengkuMaestro 

You can use Encodian's Utility - Parse HTML Table to parse tables received in email bodies and convert them from HTML into JSON.  
 
You can also pass through a table ID so you just have to loop through each table in the email to get the second one. 

FYI –  actions with the “Utility“ prefix only consume 1/20th of an Encodian action count . For example, a Standard plan has 500 actions so utility actions can be used 500x20 = 10,000 times. They are designed to be an incredibly cost effective productivity boost for your flow builds! 

---- 

*Encodian Flowr is a Standard Power Automate connector with 100+ actions to supercharge flow builds. Conversion, merging, splitting, OCRing, data extraction, QR/Bar codes, searching and much more. And we just added "Utility" actions, which are almost free to use and accelerate solution builds and remove maintenance overheads with actions like Extract text between values, extract URLs, extract email addresses, Password/GUID/HMAC creation, escaping/unescaping HTML, parsing HTML tables, etc. 

[TengkuMaestro]

Thank you @AlexEncodian i will try using it