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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePoint List/Power ...
Power Apps
Unanswered

SharePoint List/Power App Limitations

(0) ShareShare
ReportReport
Posted on by 1,265

I have a SharePoint/Power App where we are collecting ~ 48,000 records per year.  As shown below, I would like to have a gallery that displays all records >= to the DatePicker date and then illustrate that in the graph (based on some grouping).  The value "1200" should be ~ 29,000 which is a Text Label = CountRows(Gallery1.AllItems).  Is Power Apps a platform where this can be accomplished or are the record limitations an issue?

RJF61_1-1711989581829.png

Categories:
  • Pstork1 Profile Picture
    69,665 Most Valuable Professional on at

    Its really not practical to display more than 2,000 records in a gallery.  It can be done if you download all the data into a local collection, but that has its own issues.  Its much better to provide users with access to a smaller subset of data details for them to look at.  No one is going to actually scroll through a 29,000 item gallery to get to the last record anyway.  For things like you graph there are other ways to display that kind of summary information. Instead of doing it from a gallery or local collection you can send the parameters to a Power Automate flow, have it do the filtering and calculations and then return the column totals as a collection that can be used to build the array.

  • RJF61 Profile Picture
    1,265 on at

    @Pstork1 Thanks for the feedback.  I've done some searching but haven't found any similar example Flows.  From my SP List there is a column GenMgr which I would like to subtotal (a count of the GenMgr occurrences).  Unfortunately, I'm kind of hung up.  Does the following make some sense?

     

    RJF61_0-1712000015166.png

     

     

  • Pstork1 Profile Picture
    69,665 Most Valuable Professional on at

    Very close to the way I would do it.  After the filter array use an append to array variable to append the GenMgr label and a Length() for the filter array for the count.  Then return that array after exiting the loop.  My screenshots below

    image.png

    image.png

    You can save that result to a collection and have a collection with the name and count for each manager.

     

  • RJF61 Profile Picture
    1,265 on at

    @Pstork1 Thanks again.  Is there an issue with the following format?

     

    Created gt '06-30-2023'

     

    I am not getting any items. 

  • Pstork1 Profile Picture
    69,665 Most Valuable Professional on at

    Dates and Times will be stored in UTC format yyyy-MM-dd. 

    Created gt '2023-06-30'
  • RJF61 Profile Picture
    1,265 on at

    @Pstork1 Not sure what is occurring.  Following is my Get Items...

     

    RJF61_0-1712058953495.png

    RJF61_1-1712059118810.png

    When I run, I am receiving no errors.  There are 20,943 records but I am receiving no data.

     

     

     

  • Pstork1 Profile Picture
    69,665 Most Valuable Professional on at

    My records are a bit earlier than yours, but I'm running the exact same query and it works for me.

    image.png

     

    Your sure you want Created and not Modified?

  • RJF61 Profile Picture
    1,265 on at

    @Pstork1 Yes, I need to obtain when the record was Created.  Following is Output.  Does this indicate an issue?

     

    RJF61_0-1712067878531.png

    I did create a new Flow from scratch and am seeing the same result.

  • Pstork1 Profile Picture
    69,665 Most Valuable Professional on at

    Since this is a really large list what do your pagination settings look like and what kind of license do you have?  If you haven't turned on pagination it might just be that the output is empty because none of the first 100 records (that's the default for Top count) are covered by the filter.

     

    Power Automate doesn't do delegation. Instead it retrieves records in pages. But that is turned off by default.

  • RJF61 Profile Picture
    1,265 on at

    @Pstork1 Was just getting ready to send an update.  That was the issue.  The Pagination was off.  I turned on and identified 50,000 on the Threshold.  I am now getting records.

     

    It appears I have other issues in the Flow but am addressing.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 190 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard