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

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Get Last 2000 data excel

(0) ShareShare
ReportReport
Posted on by 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)
)

 

I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    151,751 Most Valuable Professional on at
    Re: Get Last 2000 data excel

    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

  • firda59 Profile Picture
    372 on at
    Re: Get Last 2000 data excel

    @WarrenBelz 

     

    Hi, I can't click the video

  • WarrenBelz Profile Picture
    151,751 Most Valuable Professional on at
    Re: Get Last 2000 data excel

    @firda59 ,

    Try now

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 652 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 410 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 236

Last 30 days Overall leaderboard