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 / Gallery not showing al...
Power Apps
Answered

Gallery not showing all records

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

So I have a gallery that it's retrieving data from an excel sheet, I have it filtered and sorted with the following code, but it is not bringing me all the information, just 11 records and I have more. do you guys have any idea why?

 

SortByColumns(Filter(Registro,Estatus= "False",(Len(Searchbox2.Text) = 0
 ||
 StartsWith(NombreBase, Searchbox2.Text)
 )
 ),
 "Fecha",
 Descending
)

 

My app gathers info that users fill, with a ClearCollect and then send to an excel with a ForAll. So I use that gallery as a review of the previous records if they have a "False" status. And in another Gallery with the same code I use it to modify and update, and it has the same problem.

 

I checked other posts but it is different, do you guys have any ideas? How can I solve this?

Categories:
I have the same question (0)
  • mdevaney Profile Picture
    29,991 Moderator on at

    @Anonymous 

    Start by removing each condition individually to find out which one is causing the error.  Let me know once you’ve found the culprit.

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    So I only left the sort by columns and it is showing me records from may 12 and so on, which I think that is the problem, I have records since January, I double checked the Excel and copy paste the format from the data that is actually working, but still it is not showing the correct data.

     

    Do you have any suggestions?

     

    Thanks in advance @mdevaney !

  • Verified answer
    mdevaney Profile Picture
    29,991 Moderator on at

    @Anonymous 

    By default you can only read-in the 1st 500 rows of an Excel table.  This is because Excel is not a delegation-friendly datasource.  If you go to the Advanced Settings for your app you can increase this limit to 2,000 rows.

     

    If you must read-in more than 2,000 rows from your Excel spreadsheet it cannot be done.  There is no workaround.  You must move your data to a delegation-friendly datasource such as A SharePoint list.

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This was the thing, now I get it.

     

    Sorry for that.

     

    Thank you for your time!

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 392

#2
WarrenBelz Profile Picture

WarrenBelz 364 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 271 Super User 2026 Season 1

Last 30 days Overall leaderboard