cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Is there an Excel Row limit when I extract data

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Is there an Excel Row limit when I extract data

 

Hi @jamesjson ,

 

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

174.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Dual Super User III
Dual Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

Re: Is there an Excel Row limit when I extract data

 

Hi @jamesjson ,

 

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

174.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,130)