Unanswered

Delegation Get 6000 records instead of 2000 records

(0) Share

Report

Posted on by MAli_Ch

Hi, I have an app where I want to display last 6000 records. Currently I'm getting last 2000 records as power apps only supports 2000 rows data. Now using ID column how can I get the last 6000 rows record? I'm sharing my gallery item's formula below:

Sort(
 AddColumns(
 GroupBy(
 Filter(
 datasource,
 (
 (IsBlank(Dropdown_date.Selected) And date = Int(latest_date.Text)
 ) Or date = Int(Dropdown_date.SelectedText.Value)),
 (
 (IsBlank(Dropdown_city.Selected) And city = city
 ) Or city = Dropdown_city.SelectedText.Value)
 ),"PRODUCT_CODE", "from_store", "FS_OH", "GroupItems"),
 "TotalTransferValue", Sum(GroupItems, transfer_value)
),
PRODUCT_CODE,
SortOrder.Ascending
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

charlessexton 21 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you're trying to get more than 50 records you're doing something wrong. Why do you want to display so many records? It's not possible for the human eye to process them all.

Was this reply helpful? Yes No
MAli_Ch 95 on at

Like (0)

Report
Copy link

Link copied!

@charlessexton I want to display the records so user can select the required record using the filter. But Im only getting 2000 records

Was this reply helpful? Yes No
charlessexton 21 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can filter all 6000 records without needing to pull them through to the app in one go. A combobox can search all records, if that's what you mean?

Was this reply helpful? Yes No
MAli_Ch 95 on at

Like (0)

Report
Copy link

Link copied!

@charlessexton Goods interesting. Can you tell me how can I do it? I need get 6000 records based on the latest ID without asking from user.

Was this reply helpful? Yes No