Answered

500/2000 Row Limit and Delegation Filtering

(0) Share

Report

Posted on by OJBridger

Hello All,

I've recently stumbled upon an issue with an App I've done and the 500 (or 2000) row limit and then not displaying any new items.

A few days ago the 500 limit was hit, so as a temporary fix I pushed it up to 2000. This will also eventually be hit so I am on the clock to implement a work around ASAP. I am confused as to why this limit has been hit, because when creating the filtering I made sure to not get a Delegation Warning on the filter.

For info, the PowerApp is using a Sharepoint List as a Data Source.

My main 2 questions are:

1. Can I adapt the following code of the filter to overcome the 500/2000 Data Row Limit?

2. If that is not possible can I have it so it shows the NEWEST 500 records rather than the OLDEST? - I think I would prefer this fix as it would speed the app up, all records are required as part of an archive but having the newest created 500 shown on the front-end would be ideal.

Below is my filter. Many thanks in advance for the help!

With({_preFilter:
Filter([@DATA_SOURCE],
StartsWith('3Reg', regSearchBox.Text) || StartsWith('6Reg', regSearchBox.Text),
(IsBlank(satelliteCB.Selected.Value) || Satellite.Value = satelliteCB.Selected.Value)
)
},
SortByColumns(
Filter(_preFilter,
frame in aSelectionFilter.Result,
calculatedField in bSelectionFilter.Result
),
"Created",
If(SortDescending1, Ascending, Descending)
)

)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
Hi @OJBridger ,

Firstly for the newest 2000 (or whatever your limit is) records

With( { _preFilter: Filter( Sort( [@DATA_SOURCE], ID, Descending ), ( StartsWith( '3Reg', regSearchBox.Text ) || StartsWith( '6Reg', regSearchBox.Text ) && ( IsBlank(satelliteCB.Selected.Value) || Satellite.Value = satelliteCB.Selected.Value ) ) }, SortByColumns( Filter( _preFilter, frame in aSelectionFilter.Result, calculatedField in bSelectionFilter.Result ), "Created", If( SortDescending1, Ascending, Descending) ) )

I also have a couple of blogs that might interest you - Delegation Management and using the With() statement

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.

Was this reply helpful? Yes No
OJBridger 32 on at

Like (0)

Report

This works brilliantly, thank you. I will mark as solution.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello, sorry to ask but I believe I'm having the same problem. The code I current have is generating a delegation warning, but I already have deleted a good amount of rows in my Microsoft List.
The Gallery should show the items searched in the TextInput1 whose status correspond with what is checked in ComboBox3.

Could you help me with the code?
SortByColumns(Filter('Forecast Item Activation/Deactivation',Status.Value in ComboBox3.SelectedItems||IsBlank(ComboBox3.SelectedItems.Value)||IsEmpty(ComboBox3.SelectedItems)&&StartsWith(User,User().FullName)&&If(TextInput1.Text="", true ,Or(StartsWith(Forecast_x0020_Item_x0020_ID,TextInput1.Text),StartsWith(Forecast_x0020_Item_x0020_ID,Lower(TextInput1.Text)),StartsWith(Forecast_x0020_Item_x0020_ID,Upper(TextInput1.Text))))),"Date_x0020__x0026__x0020_Time",SortOrder.Descending)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
@lfarinha ,

Yuo do not need the Upper and Lower as StartsWith is not case sensitive

With{ { wData: SortByColumns( Filter( 'Forecast Item Activation/Deactivation', StartsWith( User, User().FullName ) && ( Len(TextInput1.Text) = 0 || StartsWith( 'Forecast Item ID', TextInput1.Text ) ), "Date_x0020__x0026__x0020_Time", SortOrder.Descending ) ) }, Filter( wData, Status.Value in ComboBox3.SelectedItems || IsEmpty(ComboBox3.SelectedItems) ) )

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
Community Power Pla... on at

Like (0)

Report

Thank you very much, I can't Accept as solution because I don't have this option here but it was very helpful!

Was this reply helpful? Yes No