Answered

Web scraping text from images

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I would like to scrape text from the below web table but I'm not able to extract element values from the column on left because the banks are listed as images. Is there a way to around this and get the names of the banks with the table?

When I inspect behind the images, all of the images are named as the banks so I wonder if it's possible to somehow copy the names from there? Please see the second picture below.

Spara pengar – Tips som får dina pengar att växa | Compricer

Thank you so much for all the help!

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

Verified answer

efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous !
You wanna grab this info, right?
If so, please copy & paste the following code in your Desktop Flow
@@source: 'Recorder' WebAutomation.ExtractData.ExtractList BrowserInstance: Browser Control: $'''html > body > div:eq(1) > div > article > div:eq(2) > section > div:eq(2) > div:eq(1) > table > tbody > tr''' ExtractionParameters: { ^['Css Selector', 'Attribute', 'Regex'], ['td:eq(0) > div > img', 'Alt', ''] } ExtractedData=> OutputData_2
Hope this helps!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @efialttes! Thank you for your help! Glad to see it is doable. I'm just learning Power Automate and since you seem to know a lot about it, I would like to ask your insights on the flow I've been trying to build. I would like to copy the diverse deposit rates from the Compricer website daily and build a historic database. So in addition to the names of the banks (the ones you got), I'd also need to copy all the interest rates. I thought it would be easy with Power Automate since I have never coded but turns out I was wrong haha. What would you recommend me to do?
Very thankful for all the tips!
efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous You will find attached as a zip file my PAD test code on how scrap the info andmerge deposit rates with names, just open the .txt and paste it on your PAD flow.
Please note when expanding the table the HTML structure differs, so I could not grab names from the 11 row onwards. I am afraid I am much more used to Power Automate Cloud than Power Automate Desktop, if you need the name of the 45 rows, my humble suggestion is:

1.-Mark this topic as "Solved" by clicking "Accept as a solution". THis way others with the same problem can find a solution faster. Please also note you can even select several responses as solution, even from different community members!

2.- Open a new thread for your next question, following the policy: 'One Question, one post'. This way you have more chances to attrack attention for superusers that are seeking for unanswered topics.

Thanx for your help making this community great!

ScrapCompricer.zip
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @efialttes! Thank you very much for your help 🙂
In case someone else is looking for answer to the above, I've created a new question here: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/HTML-structure-differs-when-scraping-text-from-images/m-p/2324047#M30520