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

[Vern2022]

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. 

[Nived_Nambiar]

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]

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.

[Nived_Nambiar]

Hi @Vern2022 

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

Thanks & Regards,

Nived N

[Vern2022]

Many thanks @Nived_Nambiar

Much appreciated.