Unanswered

how extract HTML tables from body email

(0) Share

Report

Posted on by marcomizz

Hello

in my email there are several HTML tables, so in the HTML code, there are several <table> tags, in total there are 4 tables, as you can see in the attached html code.

is there a way on power automate to indicate which table I should consider in order to extract the data? for example I need to extract only the table marcked in the green box.

regards

marco

Categories:

Business Processes

AI Builder

HTMLTables.txt

I have the same question (0)

All responses (2)

Answers (0)

Chriddle 8,087 Super User 2025 Season 2 on at

Like (0)

Report

how extract HTML tables from body email

Make the HTML compatible to XML with a few string replacements. Then use xpath

Compose-HTML
Your HTML text.

Compose-XML

(The forum software does not accept this code, therefore a screenshot)

Select
From:
skip(
        xpath(
               outputs('Compose-XML'),
               '//table[2]/tbody/tr'
        ),
        2
)

Map Item:
json(item()).tr.td[0]?['#text']

Map Activity:
json(item()).tr.td[1]?['#text']

Map Mold Serial Number:
json(item()).tr.td[2]?['#text']

Add more table columns using this pattern

Result

1 people found this reply helpful.

Was this reply helpful? Yes No
NathanAlvares24 1,683 Moderator on at

Like (0)

Report

how extract HTML tables from body email

Hi @marcomizz!

Is the data you want always in the "fund request line" section?

Regards,

Nathan Alvares

1 people found this reply helpful.

Was this reply helpful? Yes No