Get Last 2000 data excel

(0) Share

Report

Posted on by firda59

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)
)

Categories:

General Questions

Dataflows

Using Apps Using Formulas

Connecting to Data

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 151,751 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Get Last 2000 data excel

@WarrenBelz

Hi, I can't click the video

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (1)

Report

Re: Get Last 2000 data excel

@firda59 ,

Try now

Was this reply helpful? Yes No