Get Rows From Google Sheet - 256 limit

[fabianbramptc]

Hello, 

I am trying to get more than 256 rows from a google sheet and I have already changed the Top Count to 600 but the flow only returns 256 rows. Anyone had this issue? 

[v-bacao-msft · Accepted solution]

Hi @fabianbramptc,

You could set it up for Get rows action, click Settings, configure Pagination, set the limit to the expected value, and click Done.

Use Length() function to check if more rows are getting.

Please take a try.

Best Regards,

[fabianbramptc]

Great, @v-bacao-msft!

It worked as you said. Thank you!