Share
ReportHello I am relatively new to Power Automate, and I am trying to build a flow that automates the extraction of data to excel. I have been able to extract the headline data to excel from the web page list, but I am stuck on how to extract the details stored behind links on the same page to other webpages. I have been able to automate the extraction from the other links in only the top item on the webpage. Someone recommended I extract all the URLS of the other links and build a loop, but I'm doing something wrong as it just loops the first level of data. I've been able to Extract data from the webpages- case name, date and the hyperlink pretty easily, and it auto does that for each of listed cases in the first page. Then I ask the robot to click on the links until it gets to the other page, and when I extract that data ("case details"), it only let's me do that as a single variable. The robot then needs to navigate back to the main list and repeat the process, but moving down the list. I'd be grateful for any guidance on how to properly build this flow. If I need to extract all the URLs, can I do this using the hyperlink variables? Do I need to store the URLS in a table? What type of loop should I build and where should I loop? If anyone has done something similar before and wants to share a copy of their flow that would be great. Here is the website, if that's helpful-HUDOC - European Court of Human Rights (coe.int) I've watched a load of tutorials, and help guidance, but none of the guides are very user friendly at all. If there is an answer or a tutorial that's on point, please share the link. Thank you!
All responses (
Answers (
497
