web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / PAD - Extract from sin...
Power Automate
Unanswered

PAD - Extract from single table on sap only returns data from the first 20 rows and not from all 120 rows?

(0) ShareShare
ReportReport
Posted on by 4

Hello Team I am facing issue to extract whole table content from SAP its only extracting top 20 rows not belows rows which are not visible.Please help me to extract the same

sdeokule1_0-1693461996354.png

 

SAP.png
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    What actions are you using to extract the data?

  • sdeokule1 Profile Picture
    4 on at

    Extract Data from Windows

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Can you share a screenshot of your flow? It might be that only the data that is visible on the screen is actually loaded at a time, and as such, PAD cannot access the lines that are not visible.

    I would suggest using some kind of a navigation to move to the next 20 lines and extracting them. You could use Create data table action to create a table, then use a Loop to keep looping until you hit the last row, extract the values of 20 rows at a time, and append them to the data table you created.

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

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • sdeokule1 Profile Picture
    4 on at

    yeah .This way tried already but its complex because the no of rows might be thousands also and I have to update the data in those rows

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 349 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard