Data extraction from table with 'lazy load'

[CABH09]

Hello everyone. 

I have come across a difficult task while working for a customer. The idea is to match records based on a variety of variables. This is not the difficult part. The difficult part is the loading of data into the grid. 

The backstory is that this task is to be performed in Dynamics 365 F&O. On here the data is kept in data grids, which by default is alright. The problem is that now all rows are loaded at once, which means that when my RPA extracts the data, it only extracts the 'visible' data. That is an issue. Loading is done when scrolling down. 

Does anyone have an idea as how to to load all data at once or make the RPA capable of scrolling and recognize newly loaded data? 

I know the solution of exporting to Excel and working from there, but that is not the desired solution. 

Thanks in advance 🙂

[Rkv_]

@CABH09 
Use Focus Text filed on WebPage action to focus on last visible record. (Here you should capture the last visible record selector). The above will scroll the webpage to view next set of records. 
Similarly use the above action in a loop until the action fails, on error you should use go to label at outside of the loop.
So after scrolling to the last record you can use Extract Data from webpage action to read entire data.

[CABH09]

Hello @Rkv_, 

Thank you for taking your time to come up with this suggested solution. I will definitely try this out and see if I can make it work. 

Have a nice weekend and thank you once again.