This is how the infinite scrolling works manually.
Scroll the page and then it loads a certain number of records (about 30).
So I tried to mimic the same using the PAD flow, with the only difference of scrolling to the very end of the page.
In doing that it was found that after scrolling for 57 times with a delay of 3 seconds between each, then it shows all the records ie; 1709 rows.
If you think that in future there could be more records so you could increase the Loop no. of 57 to some higher number. There is no harm if you give it to a higher number even if there are no more records. But unnecessary processing time will increase.
You can also remove the first "Extract data" action because there is already one in the loop.
Starting from 0, the 1708th row is the last record with Z alphabet.
@@source: 'Recorder'
WebAutomation.LaunchChrome.AttachToChromeByUrl TabUrl: 'https://global-industrie.com/en/liste-des-exposants' AttachTimeout: 10 BrowserInstance=> Browser
WebAutomation.ExtractData.ExtractList BrowserInstance: Browser Control: $'''html > body > div:eq(0) > div:eq(1) > section > section > div > div > div:eq(1) > div > div > div:eq(0) > a''' ExtractionParameters: {[$'''div > span''', $'''Own Text''', $''''''] } PostProcessData: False TimeoutInSeconds: 60 ExtractedData=> OutputData
LOOP LoopIndex FROM 1 TO 57 STEP 1
WebAutomation.ExecuteJavascript BrowserInstance: Browser Javascript: $'''function ExecuteScript()
{
window.scrollTo(0, document.body.scrollHeight);
}''' Result=> Result
WAIT 3
WebAutomation.ExtractData.ExtractList BrowserInstance: Browser Control: $'''html > body > div:eq(0) > div:eq(1) > section > section > div > div > div:eq(1) > div > div > div:eq(0) > a''' ExtractionParameters: {[$'''div > span''', $'''Own Text''', $''''''] } PostProcessData: False TimeoutInSeconds: 60 ExtractedData=> OutputData
END
Display.ShowMessageDialog.ShowMessage Message: $'''COMPLETE''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
# [ControlRepository][PowerAutomateDesktop]
{
"ControlRepositorySymbols": [],
"ImageRepositorySymbol": {
"Name": "imgrepo",
"ImportMetadata": {},
"Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}"
}
}
Paste the above flow in a new editor and test it. Once working fine then add it to your original flow.
Currently it takes 5 mins to grab the entire records but is far much better than not being able to fetch the records at all.
