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 / get data from List and...
Power Automate
Answered

get data from List and excel limitation by automate cloud flow

(0) ShareShare
ReportReport
Posted on by 4

By using 'list rows present in a table', it is only possible to get maxium 256 data rows from a excel table.

And by using 'let items, it is only possible to get maxium 100 data rows from a list in a sharepoint.

 

Is it related to enviroment setting or related to default setting?

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Wesdfg ,

     

    Please turn on this setting.

    vxiaochenmsft_0-1681269721087.png

    vxiaochenmsft_1-1681269741754.png

     

    Best Regards,

    Wearsky

  • Wesdfg Profile Picture
    4 on at

    Very nice. Working!

    Thanks!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard