How to convert outlook email body to Data table

[Raja.G (Mr.RPABot)]

Hi Team,

I have data from mail body , i want to convert mail body to data table.

Please help me anyone for this.

Input:

Email body:

Hi Team,

Invoice Number: 12345
Invoice Date: 2024-03-25
xxx:235.23
yyy:1586.67
rrr:123

Regards,
Raja G

Expected output:

Regards,
Raja G

[vrdabberu (Varunraj Dabberu)]

Hi @Raja.G

Check the below xaml:
Sequence16.xaml (15.6 KB)

Output:

Regards

[Raja.G (Mr.RPABot)]

Hi @vrdabberu ,

Thanks, but column name is not static, it will come different name also.

So whatever data found in key and value should update in the datatable.

Example : “xxx”, “yyy”, “rrr” column it will come some other name as well, like “mmm”, “jjj”, “iii”

Regards,
Raja G

[vrdabberu (Varunraj Dabberu)]

Hi @Raja.G

Check the below updated workflow:
Sequence16.xaml (17.1 KB)

Please change the column names in Build Data Table according to yours.

Regards

[Raja.G (Mr.RPABot)]

Hi @vrdabberu ,

Build datatable i coudnt able to add the column because i dont know what column name it will found, whatever data found in the body we have get key as a column and value as column value.

Automatically column should create on the key of body value

Example:
Invoice Number:12355
Key is Invoice number and value as 12345

Regards,
Raja G