Unanswered

Extract Data from web page (Values do not align)

(0) Share

Report

Posted on by JPC369

Whenever you see web scraping tutorials, they always use a vertical list to scrap from. Here is an example of a vertical list being

scraped:

The yellow highlight is the title and the blue highlight is the amount. After selecting a few titles and amounts, you get something like this from Power Automate /Desktop:

The values all match...everything is ok.

However, if you do the same thing with a list that is not vertical, the values do not align. Here is a non-vertical list from Amazon:

Titles are in yellow highlight and the amounts are in blue highlight.

Here is what happens with Power Automate:

Notice that values do not align anymore. The CSS selectors are different and maybe that is why they do not align; however, I assumed that the software was looking for a pattern. Is there a way to fix this issue?

Thanks!!!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ApexOrigin 150 on at

Like
a
(0)

Report
Copy link

Link copied!

As a workaround, you could do a check to see which type of page you are on. You mentioned the CSS Selector is different, so you can use an IF command to check the page for which CSS is present and then run a different set of Extract Data commands depending on which page is being presented at the time.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JPC369

A video for reference which has a horizontal list.

Also check the comments section of that video for the inconsistency in patterns and what css was added.

As you said that the Css selectors are not consistent then it is not going to be straight forward and will need finding out a suitable combination that works.

Power Automate Desktop - Web Extraction Part 1 | Price extraction from web page - YouTube

Was this reply helpful? Yes No