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.