You’re offline. This is a read only version of the page.
372
Hi,
I want to get 2000 latest data from 21k rows excel, I used this but cant work, is there any solution?
Thankyou!
Formula that I used:
ClearCollect(
ProductID,
Filter(
Table1,
Value(No) <= 21000, // Limiting to 2000 rows
Value('Delivered (mod)') = 0
),
Sort(Table1, Value(No), SortOrder.Descending)
)
Hi @firda59 ,
Not unless you have a numeric sequential number as one of the columns. I need to add here that Excel is a far less than ideal data source for Power Apps (this video may be worth watching), which gets worse the bigger the list gets (21k rows will present you with a lot of challenges).
If you import it all into SharePoint, your requirement is quite easy - just sort by ID descending.
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.
MVP (Business Applications) Visit my blog Practical Power Apps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
