cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
awadheshyona
Regular Visitor

Loop through multiple links on web page and get details

Hi All,

 

I am new to PowerAutomate Desktop and I want to know how can I achieve this.

 

1. Open web browser(chrome) and paste a URL.

2. This URL has multiple links which open in a different page if clicked.

3. Click link and extract some information from each clicked link.

 

I am able to do all of the above process with suggestions provided by @Highboy , however only for one of the first link(or any link) on that URL. I want to repeat this process for all links available on that URL and grab all information. I tried Web recorder also but it does not go back to the URL and opens second link and so on. I tried adding it one by one and it works however number of links on the URL(web page) will keep on changing daily.

 

Please suggest. Let me know if you need further details.

 

@Highboy  Can you please help.

 

Regards,

Awadhesh

1 ACCEPTED SOLUTION

Accepted Solutions
Highboy
Super User
Super User

I am not sure i understand what you are trying to do.
Could you attach a screenshot of the webpage you are working with?

But this could work

Highboy_0-1635421958676.png

Use "Extract data from web page" to extract all the links, and loop throuh all of them - no need to go back to first page.

Highboy_1-1635422171295.png

 

View solution in original post

6 REPLIES 6
Highboy
Super User
Super User

I am not sure i understand what you are trying to do.
Could you attach a screenshot of the webpage you are working with?

But this could work

Highboy_0-1635421958676.png

Use "Extract data from web page" to extract all the links, and loop throuh all of them - no need to go back to first page.

Highboy_1-1635422171295.png

 

That is really helpful @Highboy  This is what I was trying to achieve and it worked. Thanks once again.

BzshBzsh
New Member

Hi, @awadheshyona @Highboy 

 

I am trying to do the same thing or at least something very similar. I have a web page with 116 links on it. Each link takes me to a contact page where I need the Name, Phone, Fax and Address. I would like all the results to show up in 1 excel sheet with 116 rows. Using the example, I was able to save the links, have the webpage load and have the first link spit out the right data, then it loops, opens the next link but spits out a blank excel document. What am I missing? Also, I'm not sure if this matters but some of the links don't have a fax number.

BzshBzsh
New Member

I got it figured out!

I needed to save my extracted data as a variable and then use that variable to write it to an excel sheet.

Here is what my loop looks like.

RCMP Loop Flow.png

 

mhenderson95
New Member

Would you be able to post a screenshot of the entire flow you put together? I am trying to do something very similar and keep hitting a wall!

You may not need all the excel steps and you could simply launch excel before your loop starts. I have mine set up to copy the current data from sheet 1, paste it into sheet 2, erase the data from sheet 1 and then paste the new information into sheet 1. I then have conditional formatting set in my excel to check for differences between the 2 sheets. This may not be the best way to have it set up but it seems to work for me. Hopefully you have luck too.

RCMP Flow.PNG

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,764)