SortByColumns not showing all data

(0) Share

Report

Posted on by Appsforourlife

Hi experts,

I am struggling with the following function;

Distinct(SortByColumns('SP list',"Id",SortOrder.Descending),'BatchNr')

This function is used for a Combobox. The function worked perfect until my SharePoint list became big = (over 1500 rows), then the function stoped show the rows which is added recenlty.

My understanding is; the function is limited by using the tirm "SortByColumns".

Then I would like "Combobox" show the last 30 rows only. Or use a new extra date box and connect the existing Combobox??

Is anybody here can help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Appsforourlife,

Your current function will list the Batch Number of the records with the most recently created IDs. Do note that a ComboBox can only show up to 2000 items - the exact amount is defined by your Data Row Limit in your app settings.

If you only want to display the last 30 records, you can filter by ID descendingly as you do now and only take the first 30 records:

Distinct( FirstN( SortByColumns( 'SP list', "Id", SortOrder.Descending ), 30 ), 'BatchNr' )

You can also prefilter the data with only relevant records (e.g. add a DatePicker to your screen):

Distinct( SortByColumns( //Filter by date first Filter( 'SP list', Created >= DatePickerName.SelectedDate ), "Id", SortOrder.Descending ), 'BatchNr' )

Since you are filtering on ID descendingly (newly created records first) I wouldn't expect new records not to show up but rather older records disappearing.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Appsforourlife 67 on at

Like (0)

Report
Copy link

Link copied!

Hi @LaurensM ,

Unfortunately, it gives the same results. "not the newst data included"
I have stared to register data the in SH list since a year ago, the function worked perfectly until 28th of June. Drop list "Combobox" shoes all data before 28th but 29, 30/06 and up are not shown.

If i use distinct('SP list', BatchNr) then i see all the data but the newst is in the end ... of course not sorted descendingly because BatchNr column is not sortable. for this reason i wanted to sort according ID.

I really appreciete another suggestion.
BR

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Do you have the same issue when sorting via creation date? Unfortunately I am unable to recreate the issue on my end, both ID and Creation date work.

Distinct( Sort( 'SP list', Created, SortOrder.Descending ), 'BatchNr' )

I hope this helps!

Was this reply helpful? Yes No
Appsforourlife 67 on at

Like (0)

Report
Copy link

Link copied!

Thank you so match, this works!!😍

Was this reply helpful? Yes No