Working with more than 2000 records

[AppsBe-Med]

Is there any method to work with more than 2000 records in PowerApps?

When  I open my form which has some Dropdowns and one Gallery I only get one single record instead of 33. 

This is my code:

Form: OnVisible: ClearCollect(colAll;Quellendaten)

Gallery: Items: SortByColumns(Filter(colAll;If(IsBlank(DropdownAbteilung.SelectedText.Value); true ;Title=DropdownAbteilung.SelectedText.Value)&&If(IsBlank(DropdownKlasse.SelectedText.Value); true ;Klasse=DropdownKlasse.SelectedText.Value)&&If(IsBlank(DatePickerAU.SelectedDate); true ;Datum=DatePickerAU.SelectedDate));"Klasse";If(SortDescending1;Descending;Ascending))

Or is there any other way how I can filter records from my SharePoint list? 

[hpc]

Hi Sik,

here is what I got: "Sort" and "Filter" works (SortFilter.png), but "If" doesn't work (If.png).

Is there any other way to select for "Abteilung" and "Klasse" or empty?

Best regards,

Hans Peter

[AppsBe-Med]

Hi Sik,

selection by "Klasse" works as well. 

If the first two dropdowns ("Abteilung" and "Klasse") are blank and the DatePicker shows the date of today then all the records of today should be shown. How can I handle this as I may not use If()?

Best regards,

Hans Peter

[v-siky-msft · Accepted solution]

Hi @AppsBe-Med ,

Thanks for you debug, that reminds me a thread I ever answered: Hitting Non-Delegable query limit when I think I'm using delegable functions  .

It seems the IF function in the SortByColumns/Filter function will cause the non-delegation error. And the workaround is to move If part function to the beginning of the formula, first to check IF condition. Although you have three if condition, the code could be much complex, I think it deserves a try.

Best regards,

Sik

[AppsBe-Med]

Hi Sik,

so far it works (if.png).

Best regards,

Hans Peter

[hpc]

Hi Sik,

it works (All.png, All.png)!

How about the date transfer into numbers? This also doesn't work for big datasets.

Best regards,

Hans Peter

[v-siky-msft]

Hi @AppsBe-Med ,

it looks good now, but do you still think the gallery doesn't show all match item?

Is there any delegation warning there? How many items it should be?

BR

Sik

[hpc]

Hi Sik,

the filter works correct, I get all the items.

Thank you for your patient and extensive help. It is really much appreciated!

Best regards,

Hans Peter