nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there Limit on # of Rows I can pull?

Damian Chua

I'm trying to set up an automation that will update a custom attribute on a filtered list of gifts

When trying to use Power Automate to pull a list of gifts, I ran into a limitation of 5000 rows.

Is this an API thing or a Power Automate thing? Is there a way for me to bypass this limit?

Thanks

samplegiftslistwpagination_20200825.zip

Find more posts tagged with

Microsoft Power Platform

Comments

Dan Bowman

HI Damian Chua‍. The 5000-record limit pertains to the RENXT connector's List gifts action. Same limit exists if you call the corresponding API endpoint directly.

If you look at the connector reference for the List gifts action, you'll see two parameters - Limit and Offset. The maximum value for Limit is 5000, but it's possible to use both parameters to configure pagination logic for your flow in Power Automate. That way, you'd be able to fetch records 5001+ in your flow.

Another thought...Consider specifying other parameters to reduce the volume of gifts returned in a single flow run. A new version of the connector just released this week, It includes a few more List gifts parameters:

List
Start gift date
End gift date
Start gift amount
End gift amount

Cheers,

Dan

Dan Bowman

Just a quick follow-up to my initial response...I built a sample flow to illustrate how you can add pagination logic. See screenshot below and sample flow attached.

f78e15cefd270224248f696c2913619e-huge-li

samplegiftslistwpagination_20200825.zip