Unanswered

HTML table to comma separated values

(0) Share

Report

Posted on by 3von

I receive data like this:

<tr><td colspan="2"><strong></strong></td></tr><tr><td colspan="2"><table><tr><th>_empty_</th><th>unique:2[]</th><th>unique:3[]</th></tr><tr><td>Male</td><td>50-59</td><td>Yes</td></tr><tr><td>Male</td><td>12-17</td><td>No</td></tr><tr><td>Female</td><td>50-59</td><td>Yes</td></tr></td></tr>

I'd like it to look something like this:

Male,70-79,Yes,Male80-89,Yes,Female,60-69,No

Is this possible?

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

You can get it done in two ways:

1) Out of the box (with no premium connectors)

Power Automate: Get HTML tag value - Manuel T. Gomes (manueltgomes.com)

2) You could convert the HTML into JSON using this connector and then use Parse JSON to extract the values

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

I can't find 'Get HTML tag value' and I have no idea how to use Parse JSON 😞

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

So I've learned that HTML to JSON doesn't work in my case because I get an error saying that there are no tables found.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@3von ,

Please refer the attached flow.

Stringmanipulatio...

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

Thanks for the help. Do I need the desktop version of Power Automate to use the attachment?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

No. Just go to my flows and import it.

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

I get this error.

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

Oh I got it now. I had to use the legacy option. Thanks.

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

I duplicated what you created and this is the error i get:

Was this reply helpful? Yes No
3von 35 on at

Like (0)

Report

Ok so I fixed the above error. Now I get this error when I run the flow:

Was this reply helpful? Yes No