Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Is there an Excel Row limit when I extract data

(0) ShareShare
ReportReport
Posted on by 133

Hi,

 

I have made a Flow where it will be making updates to an Excel file depending on the action. However, I will be adding rows each week. 

 

Is there a limit to how many rows Flow can pull at once? 

 

I made a flow a while back where it would extract from Excel and create a task in MS Planner but it would stop after 256 rows. 

 

 

 

 

Thanks!

 

James

  • Verified answer
    v-bacao-msft Profile Picture
    on at
    Re: Is there an Excel Row limit when I extract data

     

    Hi @Json123 ,

     

    Follow @efialttes 's suggestions, you could enable Pagination to get more rows:

    174.PNG

     

    Best Regards,

  • efialttes Profile Picture
    14,756 on at
    Re: Is there an Excel Row limit when I extract data

    Hi!

    In order to read more than 256 rows with 'List rows present in a table' action block, you need to activate pagination

    https://www.shanebart.com/flow-excel-256-limit/

    Hope this helps

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,552 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,928 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow