Unanswered

How do I show the most recent 500 entries in my SharePoint list?

(0) Share

Report

Posted on by Community Power Pla...

I have a SharePoint list with around 700 entries. When I set the row limit to 2000 it displays my items in my gallery in descending order which is what I want, however when I change the row limit to 500, it does not show the most recent 500 entries.

See below my code. "Pages" is my datasource and I want all of the entries in this to be shown in descending order.

SortByColumns(
Filter(
Pages,
TextSearchBox1.Text in Text(Title),
FilterByDate.SelectedDate<=ArticleStartDate),
"ArticleStartDate",
Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

bdodu 399 on at

Like (0)

Report
Please try it now like this:

SortByColumns( FirstN( Filter( Pages, TextSearchBox1.Text in Text(Title), FilterByDate.SelectedDate<=ArticleStartDate ), 500 ) "ArticleStartDate", Descending )

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

Like (0)

Report

Hi @bdodu

Thanks for your reply. Unfortunately this is not working. It isn't throwing back any errors but it doesn't give the correct data.

Was this reply helpful? Yes No
bdodu 399 on at

Like (0)

Report
Not even if you place the First command in front?

FirstN( SortByColumns( Filter( Pages, TextSearchBox1.Text in Text(Title), FilterByDate.SelectedDate<=ArticleStartDate ), "ArticleStartDate", Descending) ,500)

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

Like (0)

Report

Unfortunately this is still not working and is not showing me the most up to date data

Was this reply helpful? Yes No
bdodu 399 on at

Like (0)

Report

ok, i will replicate it now in the test environment and I'll be coming back to you

Was this reply helpful? Yes No
bdodu 399 on at

Like (0)

Report

Meanwhile - what datasource are you using? is it a database or sharepoint?

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

Like (0)

Report

Thank you for your help. I am using a SharePoint list

Was this reply helpful? Yes No
bdodu 399 on at

Like (0)

Report

what do you mean by incorect data? do you get the 500 records but not in the proper order or what do you mean by incorect?
Is the limit you set to 500 the experimental feature for non-delegable datasources ?

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

Like (0)

Report

Yes it is bringing records back, but it doesn't look like it is the most recent 500 records.

I have set the limit to 500 in the experimental features

Was this reply helpful? Yes No
bdodu 399 on at

Like (0)

Report

I've set the limit to 4 for non-delegable and due to the date comparison in sharepoint which is not delegable the number of rows returned was 4.
The first formula i've provided works perfectly.
Therefore you have a different problem.

in some cases I saw that datepicker control is not correctly getting the selected date, please place a label on the form and give it the text property Text(<your_datepicker>.SelectedDate,"mm/dd/yyyy") and see the result

Was this reply helpful? Yes No