Pagination issue in extract data from web page power automate

(0) Share

Report

Posted on by TN-20081510-0

i have a SAP webpage where it has more than 100 rows but all rows are in single page only. At a time only 10 rows are visible and rest of the rows are visible after doing scroll .

So extract data from web page is extracting only 10 rows at a time in power automate.

How to extract all rows at once?

PAD generated selectors are:

html > body > div:eq(1) > div > div > div > div > div:eq(2) > div > section > div > div:eq(1) > div > div:eq(1) > div > iframe > html > body > div > div > iframe > html > body > table > tbody > tr > td > div > div > div:eq(0) > div:eq(1) > div:eq(0) > div > div > div:eq(2) > table > tbody > tr > td > div > table > tbody > tr > td > div > table > tbody > tr:eq(1) > td > div > span > span > div > div > table > tbody > tr:eq(2) > td > table > tbody > tr > td > div > table > tbody > tr > td:eq(0) > table

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @TN-20081510-0,

I dont which action your using,Please try use this below action and it will extract the entire table even the rows which are not visbile.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 3,874 Super User 2025 Season 2 on at

Like (0)

Report
HI,

1. Launch Web Automation & Navigate

Use the "Launch new Chrome/Edge" + "Navigate to URL" actions or attach to the SAP web browser instance.

2. Initialize Variables

Create a list variable to store all extracted rows.

Example: Set Variable → AllRows = Empty List

3. Set Up a Loop

Use a Loop until or Repeat until structure to keep scrolling and collecting rows.

Example logic:

Repeat until <no new rows found>

4. Scroll to Load More Rows

Use the "Send Keys" or "Scroll UI Element into View" action on the table container:

Option A: Use JavaScript (Best if table has virtual scroll)

Use Run JavaScript function on web page:

document.querySelector('your-table-container-selector').scrollBy(0, 500);

You may loop this or scroll to the bottom:

document.querySelector('your-table-container-selector').scrollTop = document.querySelector('your-table-container-selector').scrollHeight;

Option B: Use "Send Keys" (if JavaScript isn't effective)

Send PageDown or ArrowDown to the table:

Action: Send Keys

Target: Table container element

Keys: [PageDown] or [Down]

Add Wait (500ms–1s) after each scroll for rows to load.

5. Extract Visible Rows

Use "Extract Data from Web Page" to grab the 10 visible rows.

Parse them into a temporary list.

Compare with previously collected rows.

Append unique rows to your AllRows list.

You can compare using a key column (like row number or ID).

6. Detect When to Stop

Use logic such as:

Stop when no new rows appear after scroll.

OR stop after N scrolls (if total is known, e.g., 10 scrolls × 10 rows = 100 rows).

7. Write to Excel or Output

Once complete, write AllRows to Excel, CSV, or wherever needed.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No