Unanswered

Select specific row and column data from HTML table

(0) Share

Report

Posted on by sglund

Hi All,

I've been watching https://www.youtube.com/watch?v=i4GHCGMAD88 and this has helped me get some data from a HTML table in an email. However, I have run into and issue that I can't seem to fix.

So far I have gotten to the SelectRowsFromHTML

Screenshot 2023-09-12 at 7.49.43 pm.png

Screenshot 2023-09-12 at 7.54.33 pm.png

with the value being an expression -

xpath(xml(outputs('ComposeHTML')),'//table[1]//tr[13]/td[2]//text()')?[0]

However, when I test this, I get 17 rows in the ComposeCountRowsMinusOne and when I go to select the row/column etc, It populates all 17 with the data from row 13.

I just want to select the data in that specific row and column.

Any advice would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Your xpath expression looks weird. Did you mean '//table[1]/tr[13]/td[2]/text()' ?

Was this reply helpful? Yes No
sglund 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chriddle - unfortunately it returns Null - if I do not have '//table[1]//tr[13]/td[2]//text()')?[0] with the double /
in that youtube clip, there was a comment that mentioned they needed to use the // to get results.

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you show me your HTML, I might be able to help.

Was this reply helpful? Yes No
sglund 10 on at

Like (0)

Report
Copy link

Link copied!

@Chriddle - I've attached an xlsx that has the html code I am currently using.
This HTML code forms the table inside an email - the body of that emails is where i am trying to extract specific data from to then use that in our internal ticketing system.

HTMLProblem.xlsx

Was this reply helpful? Yes No