SortByColumns not working with "Created" column for one SP list

(0) Share

Report

Posted on by romankorchak2

125

Hi All

I have a strange issue where SortByColumns gives blank collection if used with "Created" column
SortByColumns(MySPlist, "Created", SortOrder.Descending) - gives blank collection

but it works with other columns, like ID

SortByColumns(MySPlist, "ID", SortOrder.Descending) - gives collection with lots of items

And it only happens with one particular SharePoint list

Any idea why it could be happening?

Thanks

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @romankorchak2 ,

Have you ever tried copying the List into a collection and then sorting it? What's your version number?

Best regards,
Rimmon

Was this reply helpful? Yes No
romankorchak2 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorting collection does work, but I still need to filter the list as its bigger then 2000 items and filter needs to be editable by the user
Authoring version is 3.24012.8

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried just using Sort instead of SortByColumns?

Was this reply helpful? Yes No