Hello, I have a PAD flow using data from an Excel spreadsheet with a loop configured to Send Keys:
{Control}({F})%CurrentItem['Investor_Trimmed']%{Escape}{Enter}
The flow opens the Excel document and a Microsoft Edge session with a configured web site. The loop works correctly the first time through - it loads the first line of data, finds the matching line, selects it (Escape, Enter), moves through the rest of the process, returns to this page but on the second loop, it doesn't find the matching line of data. I've confirmed the data is successfully being looped but it's not loading in the Control-F after the first time.
Any ideas what could be causing the problem?
Also, is there a way to load the extracted data from the web scraping to the Excel spreadsheet that's being used to provide data to the loop? I want the scraped data to be associated with the investors I'm using to load the loop, not create new blank spreadsheets that have no association. I also don't want 220 spreadsheets; I just want one with feeder data and associated scraped data.
Thank you.
