Unanswered

How to omit 2000 records in excel spreadsheet when pulling data in gallery, please?

(0) Share

Report

Posted on by MP-13011217-0

158

Hello, my data source is excel spreadsheet and I have now over 2000 records. I have tried with naming first 2000 BatchID = "1" and anything over that BatchID ="2" then creating collections depending on BatchID but this did not seem to work at all as the gallery still only can see these 2000rows. I can't delete any record from this table as well as all of them are quite important. Any ideas, please?

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @marcy_pi ,

Assuming "2" is a string (not a number), what do you get when you do this

ClearCollect( YourCollection, Filter( TableName, BatchID = "2" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report

Hi! Thanks for a reply. It shows me only record number 2001 nothing else. Just one record in a gallery.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @marcy_pi ,

Yes - Excel and Delegation - if all the records have BatchID of "2", then this is an Excel limitation - I do not use it, but understood that would work. I suggest you change to SharePoint if you can.

Was this reply helpful? Yes No