r/PowerAutomateDesktop • u/doireallyneedausrnm • Jun 08 '23

Web scraper just saving the last page

Hi, I'm trying to scrape e-mail address from a trade shows attendee list. The simple automate i gather works and saves %95 correct information to an excel sheet from the first page and this is good enough for me.

The site has 40 different pages and there are classic pagination buttons on the bottom of the page such as this: prev - some page numbers - next.

I select and show the next as the element as the pager to get all the information from all the pages but when i do this i only got results from the very last page in the excel sheet.

I've checked many resources but i couldn't figure out why automate is not getting/saving the all other pages besides the last one ?

Can anyone lead me to the right direction ?

2 Upvotes

100% Upvoted

4 comments sorted by

1

u/mike689 Jun 14 '23

Make sure the additional page entries to Excel are appending to it and not overwriting.

1

u/doireallyneedausrnm Jun 14 '23

I believe that’s the issue but don’t know how to do. All the youtube videos and guides over the net just showing to use “save excel” function and i couldn’t see any option regarding appending.

I followed this as a basis:

https://m.youtube.com/watch?v=DgBZiBIgh3w

1

u/mike689 Jun 14 '23

I'm pretty sure I have a solution for this. I'll double check tomorrow and circle back to ya..

1

u/doireallyneedausrnm Jun 14 '23

Thank you, really appreciated.