Answered

Gallery not showing all records

(0) Share

Report

Posted on by Community Power Pla... 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 !

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

This was the thing, now I get it.

Sorry for that.

Thank you for your time!

Was this reply helpful? Yes No