web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I need to know if ther...
Power Automate
Answered

I need to know if there is a limit on records returned / tested on Power Automate - is this a license issue or what see below ?

(0) ShareShare
ReportReport
Posted on by

I need to know if there is a limit on records returned / tested on Power Automate - is this a license issue or what see below ?

 

--------

 

I have a flow where I'm attempting to match a created date to a number of days in the past with an approval date blank and then I'm to act / email on that condition.  The flow is not working in production but does in test. 

 

I copied the prod list to a new 'test' name.  Both lists have the same everything far as columns / settings.  I can see in the dropdown in get items from the same site my test list and select that. Seems no issue there.

 

In my new test list I only have a couple records, in production could be hundreds.  

 

Here is the result of the condition on test being met and sending me an email.  NOTE:  there are only two records on this test list.

 

landsend_1-1666289483545.png

 

QUESTION:  In my prod flow run I only see 100 of what I know are should be closer to 300 records but only am seeing always 100 -.

 

prod run results only show what appears to a first 100 records.  Why is that about ?  When opening 'raw data' on get items I only see what appears to be a limited number of records with no dates this year only from back in 2020. 

 

Here is my condition - works in test but not in prod which has hundreds records, test only two records.

 

landsend_2-1666289925000.png

 

This is my question.  Why am I only seeing 100 records in the apply to each when I know there should be well over 100.  

 

landsend_3-1666290051919.png

 

In get items in prod and opening 'Show raw inputs' I don't see anything this year just what appears to be records valid but from long time ago back in 2020.  

 

landsend_4-1666290156322.png

 

I know when looking at get items there appears to be a default of get 'all' records but that does not appear to be what I am seeing at the end of the run.  

 

landsend_5-1666290295710.png

 

 

 

 

 

 

Categories:
I have the same question (0)
  • Rhiassuring Profile Picture
    8,690 Moderator on at

    Your settings on Get Items looks different than mine (are you in the preview?), but for me, I can turn on pagination and set a threshold if I want to: 

     

    Rhiassuring_0-1666296413044.png

    From other posts, I see that turning on pagination and setting the limit / threshold quite high can resolve this issue. 

  • landsend Profile Picture
    on at

    Thanks for your response I've never found that. How do I get to that setting ??? 

    And, what do you mean by ' are you in preview ' ?? 

     

    Basically how do I get to 'Settings for Get Items'  ??

     

    And are you on what type of instance of Power Automate.  Is that setting specific for a version / cost ? 

     

     

  • Verified answer
    Rhiassuring Profile Picture
    8,690 Moderator on at

    I'm on a Business Standard license, no additional licensing. 

    On your Get Items action, click the " ... " in the top right hand corner. You will see Settings. Click that, and then you should see similar to my screenshot above. Let me know!


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard