You’re offline. This is a read only version of the page.
Announcements
25
Hello guys, Sorry I am new in Power Automate and could not find a decent tutorial that will solve my issues. I hope you can help me.
So I am doing some analysis for an esports team and I need to extract all data from a webpage.
Here is the link I want to extract https://www.opendota.com/teams
So under those teams on webpage I have an excel file which has the list of top esports team that I should only scrape please see sample below.
| Teams to scrape |
| Team Name |
| Team Liquid |
| Gaimin Gladiators |
| Shopify Rebellion |
| Tundra Esports |
| Evil Geniuses |
Power Automate will only scrape the links which the name of the team and my list on excel file match.
Is that possible?
so the scraping will get the hyperlink which is already working however it's getting the whole population.
Instead of extract data from webpage, i have use get details of webelement action to extract link associated with each team in webapge from excel
I have used excel like this
Flow design
under for each i have used get element details from webpage action with below properties
Selector used for this scenario
(this will make selector dynamic for each row team name, so added %row[0]% as dynamic part there)
Next for demo, displayed the team name and link value obtained for each team
sample output from flow
==============================
You can trying using extract details from webpage action but once you extract it, you many need to use join operation to join two datatables (one in excel, other extracted data with links) to get the data present in excel
But currently join action is not present in PAD, thus need to use sql or basic flow operation which would be complex.
Hope this helps
Mark it as solution if it resolves your query 🙂
Share
Report
All responses (
Answers (
