I need to extract the table from email body

Help Studio
, ,
1

I need to extract the table from email body .im using 365 scope get mail activity. Below is the example. ISBodyHTML is returning false

The image shows a statement detailing two invoices from Clarios, LLC, including data on payment terms, project descriptions, invoice dates, amounts, and due dates in EUR currency. (Captioned by AI)
The image shows a statement detailing two invoices from Clarios, LLC, including data on payment terms, project descriptions, invoice dates, amounts, and due dates in EUR currency. (Captioned by AI)1832×481 22.5 KB

2

@sathish_moorthy

in the properties change the get body as html to true

image

then you can get html body…which can be saved as .html file and then open in browser and use extract table activity

cheers

3

Hi Anil im unable to see the Get as HTmL property in Get mail activity

The image shows the configuration panel for the "Get Mail" activity in UiPath Microsoft Office 365, set to retrieve up to 70 unread emails with the subject containing 'Soft Reminder for' from the Inbox folder, ordered by the newest first and marked as read, with the result stored in the... (Captioned by AI)
The image shows the configuration panel for the "Get Mail" activity in UiPath Microsoft Office 365, set to retrieve up to 70 unread emails with the subject containing 'Soft Reminder for' from the Inbox folder, ordered by the newest first and marked as read, with the result stored in the... (Captioned by AI)358×733 19 KB

4

Hi @sathish_moorthy

You can download the package "UiPathTeam.ExtractDataTablesFromHTML.Activities"
And then pass this way
Let output be the output of mailmessage

image
image415×101 2.3 KB

You will get the array of tables as output

Hope this helps!

1 Like
5

hey
Get As HTML option is available in property

image
image314×453 10.8 KB

UiPath version 2022.10.4
Office 365 activities version 1.15.1
System activities version 23.10.6
Automation activities version 23.10.13

Upgrade the packages to latest version then check again

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.