Is there Limit on # of Rows I can pull?

Damian Chua
Damian Chua
Fourth Anniversary Participant Facilitator 1
in SKY Developer General Discussions
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
Tagged:

Comments

  • Dan Bowman
    Dan Bowman
    Eighth Anniversary Kudos 1 Name Dropper Participant
    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
    Dan Bowman
    Eighth Anniversary Kudos 1 Name Dropper Participant
    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

     

Categories