Need help with data extraction from web

(1) Share

Report

Posted on by 安ヌ-17100425-0

Hello everyone.
I'm pretty new to Power Automate, and I'm encountering a problem extracting data from the web.

I want to get the data from this table below, particularly the time stamps in the grey boxes.

I tried to extract the whole HTML table, thinking that I can do post-processing later, but when I tried to do that and export it to CSV, I found that it extracts everything BUT the time stamps in the grey boxes.

Below is the extracted CSV from the first row of the table above.

I would like to know what's the best way to solve this problem.
Thank you in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

So you need the data in same format as present in the table - right ? as i could see from the extracted results is some column data is not extracted as required

Was this reply helpful? Yes No
安ヌ-17100425-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hi Nived,
Yes I do, and it's as you see that some data are not extracted. Do you have any advice to solve the problem?

Was this reply helpful? Yes No
Meekou 200 Moderator on at

Like (1)

Report
Copy link

Link copied!

For extracting table from Html to Excel, you might download the html, and then loop the html by path to get every cell value.

Based on screen shot, we could not understand the html content, if this is a public web page, you could share the link, if not, you can check and share the html string for this page.

Regards,

Meekou

Private Support

Was this reply helpful? Yes No