web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using For Each Loop to...
Power Automate
Unanswered

Using For Each Loop to loop Through Companies in Excel Sheet and pull data from their Websites (multiple websites in same loop)

(0) ShareShare
ReportReport
Posted on by 6

Hi all,

 

I have a spreadsheet containing hundreds of companies. I don't know the domain for the hundreds of companies that I have on my spreadsheet but I am hoping to get the contact details for most/some of them. As I don't know what the companies domains may end with, I have set the variables up to end with .co.uk, .com, .org, org.uk, etc. and the error handling is set so if it doesn't find a page, it uses the next sequence at the end of the domain and so fourth. The contact details will be stored in a variable and then written to Excel at the end of the loop. 

 

I have used "Extract data from Webpage" on the first row company and this works successfully for that company when testing, but for other companies, even for the companies that have web pages opened successfully during the running of the loop, the details are not extracted from that web page, only the first. I am guessing this might be due to DIVs being in different places on the websites?

 

Is it possible to extract from numerous web pages on the same loop through Power Automate? Or is this impossible due the fact each web page is laid out differently?

 

If it is possible, please advise me on how to do it. Many thanks.

 

Your time is appreciated. 

 

 

I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Vern2022 

    I think that is not possible as different websites has different layouts which would be difficult to capture the data from each.

  • Vern2022 Profile Picture
    6 on at

    Hi Nivid,

     

    I ended up coming to that conclusion, however, your comment is largely appreciated.

     

    I have realised that I am going to have to extract details from business pages on Facebook (those that are on it). Even that is having trouble with accessing UI elements.

     

    I have gone to modify the UI elements but finding that there are not on any dom tree. I had recorded the selections when designing the flow. Should the UI elements be part of a hierarchy tree? If the UI elements have been stored else where what does this mean?

     

    If you look at the right panel, you can't edit these as part of any dom tree. It is like they are separate individual elements. Is this right? Am I misunderstanding something? It is having trouble accessing the elements.

     

    Many thanks for your time, Nivid. Much appreciated.

     

    Vern2022_0-1655146626531.png

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Vern2022 

     

    You can edit the UI Element by the option which u will see while hovering the required ui element

     

    Nived_Nambiar_0-1655212561619.png

     

    Thanks & Regards,

    Nived N

     

  • Vern2022 Profile Picture
    6 on at

    Many thanks @Nived_Nambiar

    Much appreciated.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 233

#2
David_MA Profile Picture

David_MA 217 Super User 2026 Season 1

#3
Valantis Profile Picture

Valantis 190

Last 30 days Overall leaderboard