Pagination Not Working

Like (2) Share

Report

Posted on 7 Apr 2025 18:56:29 by CU03101624-0

'List rows present in a table' has a max retrieval of 256 items. I need to retrieve 994 rows.

I've turned on pagination and set the threshold to 1000 (though 4 should do it if I understand correctly).

When I run the flow, I'm still only retrieving 256 items (confirmed by 'Apply to each' loop running 256 times).

The same thing happens with 'Get items' or anything else I've tried to turn pagination on for. Am I doing something wrong or is this some subscription feature that I'm missing?

Thanks in advance

Categories:

Process Advisor

2025-04-07_14-54-...

All responses (4)

Answers (1)

CU03101624-0 12 on 18 Apr 2025 at 19:29:48

Like (2)

Report

Pagination Not Working

@Ellis Karim brilliant! Thank you very much
Verified answer

Ellis Karim 10,957 Super User 2025 Season 1 on 18 Apr 2025 at 18:36:07

Like (2)

Report

Pagination Not Working

Hi @CU03101624-0

The threshold limit was updated a few years ago.

Set the pagination threshold to the maximum number of rows and clear the Top Count property.

I have an Excel file with 36,780 rows (row 1 is the header):

In the example below I enabled pagination and set the threshold to 40,000 rows:

I added a compose action to count the rows.

The Excel file has 36,780 rows and the number of rows that were read, 36,780:

Ellis Karim
Blog | LinkedIn | Bluesky
CU03101624-0 12 on 07 Apr 2025 at 21:54:43

Like (1)

Report

Pagination Not Working

@creativeopinion probably a misleading screenshot. I've tried this with top counts of 1000 and 5000 with no success (concurrently with pagination thresholds of 1000+). At the time I took that screenshot I'd reset the top count to 256 because that particular action ('List rows present in table') is limited to 256--you're supposed to used pagination for anything higher than that, e.g. this thread: https://community.powerplatform.com/forums/thread/details/?threadid=f3022d91-7211-4f84-93a5-7b7a4414d48f
creativeopinion 10,419 Super User 2025 Season 1 on 07 Apr 2025 at 21:24:25

Like (1)

Report

Pagination Not Working

@CU03101624-0 You've set the Top Count to 256. Clear this field and you should be good to go!

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram